MySQL and Rake - Library Not Loaded
When trying to run a Rakefile that I created under a linux environment on OS X for the first time I ran into this message:
dlopen(/Users/myuser/.rvm/gems/ruby-1.9.2-p290/gems/mysql2-0.3.11/lib/mysql2/mysql2.bundle, 9): Library not loaded: libmysqlclient.18.dylib
Referenced from: /Users/myuser/.rvm/gems/ruby-1.9.2-p290/gems/mysql2-0.3.11/lib/mysql2/mysql2.bundle
Reason: image not found - /Users/myuser/.rvm/gems/ruby-1.9.2-p290/gems/mysql2-0.3.11/lib/mysql2/mysql2.bundle
(See full trace by running task with --trace)
Note: I was using MySQL provided by the OS X installer PKG file from the mysql website, rather than using MAMP
I googled the issue and found the problem on a stack overflow post—which seemed to have useful information—but it didn’t work for me.
A comment one on one of the answers stated:
Your instance of the mysql2 gem was built against the
/usr/local/mysql/lib/libmysqlclient.16.dyliblibrary. For one reason or another, that library is not currently available on your system at that pathname (MySQL removed/moved/upgraded?).
and another comment had to offer:
You probably need to rebuild your mysql2 gem and point it to the mysql_config (or mysql_config5) from your MySQL installation (in /usr/bin?):
gem install mysql2 -- --with-mysql-config=/usr/bin/mysql_config
I tried the second option, by replacing the --with-mysql-config= with the one
I found on my system in /usr/local/mysql/bin/mysql_config but this didn’t
help. Then I looked at my error message and compared it to the one on the stack
overflow post and I realized the problem: the dylib was not in my path.
The Solution
The solution was to add the library to my path. Once again I poked around in
/usr/local/mysql/ and located the proper path to the dylib and added it to my
DYLD_LIBRARY_PATH environment variable in ~/.profile:
#add mysql dylib to dylib path
export DYLD_LIBRARY_PATH="/usr/local/mysql/lib/"blog comments powered by Disqus