Tuesday, December 30, 2008

Getting MySQL to work with Rails 2.2.2 on Mac OS 10.5.6

Weird errors: dlsym(0x256ee10, Init_mysql): symbol not found - /usr/local/lib/ruby/gems/1.8/gems/mysql-2.7/lib/mysql.bundle

It turned out I had installed the x86_64 version of MySQL and it does not work with Ruby.

[BLATANT COPY/PASTE BEGIN]
0. In Terminal: ls -l /usr/local ## Showed that mysql was pointing to a PowerPC version instead of i686
1. EXPORT ALL DATABASES FROM CURRENT MYSQL
2. Downloaded MySQL 5.1.30 (I am on OS X 10.4.11 so I used Mac OS X 10.4 (x86))
3. Ran installation package (be sure to see the README first about stopping current server, etc)
4. In Terminal: sudo gem uninstall mysql
5. In Terminal: sudo gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config
6. Started up my app's script/server
[BLATANT COPY/PASTE END]

Source: RailsForum

2 comments:

  1. You are a MAJOR lifesaver...I've been struggling with this problem for a bit and your steps above worked like a charm!!!

    ReplyDelete
  2. Do you have guide about mac os 10.5.4 (tiger) for getting mysql to work with rails 2.2.2 ?

    ReplyDelete