[mysql gem] Failed to lookup Init function

rubyonrails-talk
1

Hi, with mysql.rb removed from rails 2.2 I need to install the mysql gem

I have mac osx 10.5.5

I have mysql installed in /usr/local/mysql, so, after a bunch of try, I've installed the gem with:

env ARCHFLAGS="-arch i386" gem install mysql -- --with-mysql-config=/ usr/local/mysql/bin/mysql_config

the gem seems installed in /usr/local/lib/ruby/gems/1.8/gems/ mysql-2.7/

but when I try to fire up a command than involves mysql e.g.: rake db:create I get this error:

LoadError: Failed to lookup Init function /usr/local/lib/ruby/gems/1.8/ gems/mysql-2.7/lib/mysql.bundle from /usr/local/lib/ruby/gems/1.8/gems/mysql-2.7/lib/mysql.bundle

I also tried with:

env ARCHFLAGS="-arch i386" gem install mysql -- --with-mysql-include=/ usr/local/mysql/include --with-mysql-lib=/usr/local/mysql/lib --with- mysql-dir=/usr/local/mysql --with-mysql-config=/usr/local/mysql/bin/ mysql_config

and many other ways, but still get the same error.

Any ideas?

Thanks

2

UPDATE:

After a load of pain and suffer i solved Installing mysql5 client from port

sudo port install mysql5

and re-installing the mysql gem with this options:

sudo env ARCHFLAGS="-arch i386" gem install mysql -- --with-mysql- include=/opt/local/include/mysql5 --with-mysql-lib=/opt/local/lib/ mysql5 --with-mysql-config=/opt/local/lib/mysql5/bin/mysql_config

Hope this can help somebody to save some hours of googoling.