Twitter Linkedin Tumblr Facebook Flickr Lastfm

Building the MacPorts MySQL gem on OS X

I’ve been running with the Rails MySQL adapter for a while now after failing to build the native MySQL gem under Leopard. The problem, I thought, was that I’m using the Macports MySQL, and it turns out I was right. If you attempt to build the MySQL gem and you get an error like this:

Building native extensions.  This could take a while...
ERROR:  While executing gem ...
(Gem::Installer::ExtensionBuildError)
    ERROR: Failed to build gem native extension.
 
ruby extconf.rb install mysql
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lm... yes
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lz... yes
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lsocket... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lnsl... no
checking for mysql_query() in -lmysqlclient... no
 
Gem files will remain installed in
/opt/local/lib/ruby/gems/1.8/gems/mysql-2.7 for inspection.
Results logged to
/opt/local/lib/ruby/gems/1.8/gems/mysql-2.7/gem_make.out

All you need to is tell gem where to find to find mysql_config5 so the MySQL headers and library files can be discovered automatically. Credit to Igor Petrushenko for pointing out this shortcut in the comments.

sudo gem install mysql --\
  -with-mysql-config=`which mysql_config5`

Similarly, if you already have the MySQL gem installed you can update it using the same arguments:

sudo gem update -- \
  -with-mysql-config=`which mysql_config5`

Tags: , , , ,

This entry was posted on Sunday, February 3rd, 2008 at 9:15 pm and is filed under rails, ruby. You can follow any comments to this entry through the RSS 2.0 feed. You can leave a comment, or trackback from your own site.

4 comments

  1. HY
    October 1, 2008 at 5:17 am

    This worked great for me and saved me a ton of time.

  2. Igor Petrushenko
    December 3, 2008 at 5:08 pm

    Hi, all

    The only one thing, which actually works for me:

    sudo gem install mysql — –with-mysql-config=`which mysql_config5`

    Thank you,
    Sincerely,
    Igor,
    http://www.MyTaskHelper.com

Leave a comment