# Problem install mysql Gem OS 10.6.4 **URL:** \ **Category:** Ruby\ **Created:** [September 20, 2010, 5:04pm UTC](https://www.ruby-forum.com/t/problem-install-mysql-gem-os-10-6-4/195257 "2010-09-20T17:04:59Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![webwizart](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/f07891/32.png) [@webwizart](https://www.ruby-forum.com/u/webwizart)\ **Post date:** [September 20, 2010, 5:04pm UTC](https://www.ruby-forum.com/t/problem-install-mysql-gem-os-10-6-4/195257/1 "2010-09-20T17:04:59Z")
Hello there, I’m trying to install the Mysql Gem but getting error’s. I read a few artikels on the forum here, but honestly i don’t understand the problem. Im running ruby 1.8 on a mac osX 10.6.4 ## ERROR = sudo gem install mysql Building native extensions. This could take a while… ERROR: Error installing mysql: ERROR: Failed to build gem native extension. /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/bin/ruby extconf.rb 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 checking for main() in -lmygcc… no checking for mysql\_query() in -lmysqlclient… no \*\*\* extconf.rb failed \*\*\* Could not create Makefile due to some reason, probably lack of necessary libraries and/or headers. Check the mkmf.log file for more details. You may need configuration options. Provided configuration options: –with-opt-dir –without-opt-dir –with-opt-include –without-opt-include=${opt-dir}/include –with-opt-lib –without-opt-lib=${opt-dir}/lib –with-make-prog –without-make-prog –srcdir=. –curdir –ruby=/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/bin/ruby –with-mysql-config –without-mysql-config –with-mysql-dir –without-mysql-dir –with-mysql-include –without-mysql-include=${mysql-dir}/include –with-mysql-lib –without-mysql-lib=${mysql-dir}/lib –with-mysqlclientlib –without-mysqlclientlib –with-mlib –without-mlib –with-mysqlclientlib –without-mysqlclientlib –with-zlib –without-zlib –with-mysqlclientlib –without-mysqlclientlib –with-socketlib –without-socketlib –with-mysqlclientlib –without-mysqlclientlib –with-nsllib –without-nsllib –with-mysqlclientlib –without-mysqlclientlib –with-mygcclib –without-mygcclib –with-mysqlclientlib –without-mysqlclientlib Gem files will remain installed in /Library/Ruby/Gems/1.8/gems/mysql-2.8.1 for inspection. Results logged to /Library/Ruby/Gems/1.8/gems/mysql-2.8.1/ext/mysql\_api/gem\_make.out ## And Here is the mkmf.log file = find\_library: checking for mysql\_query() in -lmysqlclient… -------------------- no "gcc -o conftest -I. -I/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/universal-darwin10.0 -I. -I/usr/local/include -D\_XOPEN\_SOURCE -D\_DARWIN\_C\_SOURCE -arch i386 -g -Os -pipe -fno-common -DENABLE\_DTRACE -fno-common -pipe -fno-common conftest.c -L. -L/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib -L/usr/local/lib -L. -arch i386 -lruby -lmysqlclient -lpthread -ldl " conftest.c: In function ‘t’: conftest.c:3: error: ‘mysql\_query’ undeclared (first use in this function) conftest.c:3: error: (Each undeclared identifier is reported only once conftest.c:3: error: for each function it appears in.) checked program was: /\* begin _/ 1: /top/ 2: int main() { return 0; } 3: int t() { void ((volatile p)()); p = (void (()()))mysql\_query; return 0; } /_ end \*/ "gcc -o conftest -I. -I/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/universal-darwin10.0 -I. -I/usr/local/include -D\_XOPEN\_SOURCE -D\_DARWIN\_C\_SOURCE -arch i386 -g -Os -pipe -fno-common -DENABLE\_DTRACE -fno-common -pipe -fno-common conftest.c -L. -L/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib -L/usr/local/lib -L. -arch i386 -lruby -lmysqlclient -lpthread -ldl " ld: warning: directory ‘/usr/local/lib’ following -L not found ld: library not found for -lmysqlclient collect2: ld returned 1 exit status checked program was: /\* begin _/ 1: /top/ 2: int main() { return 0; } 3: int t() { mysql\_query(); return 0; } /_ end \*/ I think i’m missing a library or file but i have no idee where or what to do. Some help would be nice thx ---
**Author:** ![webwizart](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/f07891/32.png) [@webwizart](https://www.ruby-forum.com/u/webwizart)\ **Post date:** [September 20, 2010, 5:34pm UTC](https://www.ruby-forum.com/t/problem-install-mysql-gem-os-10-6-4/195257/2 "2010-09-20T17:34:53Z")
Younes, I stopped using mysql gem. The whole gem is messed up seriously. When I had the same problem on my Ubuntu, I just installed _libmysql-rub_, restarted the mysql-server and everything was roses. This solution worked on Ubuntu versions 8.04, 8.10, 9.04, 9.10 and 10.04. I’m sure there must be a corresponding library in OSX 10.\* . But if you still insist to have mysql gem, then try this one out: [http://blog.maxdunn.com/articles/2006/12/12/installing-mysql-gem-on-mac-os-x-10-4](http://blog.maxdunn.com/articles/2006/12/12/installing-mysql-gem-on-mac-os-x-10-4) . Gem regards, * * * Edmond Software Developer | Baobab Health Trust ([http://www.baobabhealth.org/](http://www.baobabhealth.org/)) | Malawi Cell: +265 999 465 137 | +265 881 234 717 _“Every Rubygem has its own gemspec”_ – Edmond K. 2010/9/20 Younes B. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) ---
**Author:** ![webwizart](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/f07891/32.png) [@webwizart](https://www.ruby-forum.com/u/webwizart)\ **Post date:** [September 20, 2010, 5:38pm UTC](https://www.ruby-forum.com/t/problem-install-mysql-gem-os-10-6-4/195257/3 "2010-09-20T17:38:24Z")
2010/9/20 Edmond K. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) > Younes, > > I stopped using mysql gem. The whole gem is messed up seriously. > > When I had the same problem on my Ubuntu, I just installed _libmysql-rub_, > restarted the mysql-server and everything was roses. This solution worked on > Ubuntu versions 8.04, 8.10, 9.04, 9.10 and 10.04. I’m sure there must be a > corresponding library in OSX 10.\* . I meant to say \*libmysql-ruby. \* ---
**Author:** ![webwizart](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/f07891/32.png) [@webwizart](https://www.ruby-forum.com/u/webwizart)\ **Post date:** [September 20, 2010, 6:34pm UTC](https://www.ruby-forum.com/t/problem-install-mysql-gem-os-10-6-4/195257/4 "2010-09-20T18:34:01Z")
On Sep 20, 12:34 pm, Edmond K. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > Younes, > > I stopped using mysql gem. The whole gem is messed up seriously. Really? How? Please provide the real details. I package the MySQL/Ruby extension as a gem and tested in Ubuntu, Snow Leopard, Leopard and even Windows. Please be more specific on what you mean by that. It is clear from the mkmf.log output that either the wrong mysql or the wrong compilation options are attempted to be feed into the compile process. ---
**Author:** ![webwizart](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/f07891/32.png) [@webwizart](https://www.ruby-forum.com/u/webwizart)\ **Post date:** [September 20, 2010, 7:20pm UTC](https://www.ruby-forum.com/t/problem-install-mysql-gem-os-10-6-4/195257/5 "2010-09-20T19:20:51Z")
On Sep 20, 1:46 pm, Younes B. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > > Leopard, Leopard and even Windows. > > > Please be more specific on what you mean by that. > > > It is clear from the mkmf.log output that either the wrong mysql or > > the wrong compilation options are attempted to be feed into the > > compile process. > > if it works with you can you tel me how for snowleopard. For you it is > obvious but not for me How you installed MySQL? using binaries form [dev.mysql.com](http://dev.mysql.com) or using MacPorts (sudo port install mysql5?) If using ports, it should find the path automatically. If not and was installed by binary packages, first you need to ensure the binaries are in the same architecture your Ruby installation. After checking that, you need to ensure mysql\_config or mysql5\_config is available in the path (using which). Then you can provide it to the gem installation process: gem install mysql – --with-mysql-config=/path/to/mysql/bin/ mysql\_config ---
**Author:** ![webwizart](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/f07891/32.png) [@webwizart](https://www.ruby-forum.com/u/webwizart)\ **Post date:** [September 20, 2010, 10:36pm UTC](https://www.ruby-forum.com/t/problem-install-mysql-gem-os-10-6-4/195257/6 "2010-09-20T22:36:22Z")
Luis L. wrote: > On Sep 20, 1:46�pm, Younes B. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > > > > Leopard, Leopard and even Windows. > > > > > Please be more specific on what you mean by that. > > > > > It is clear from the mkmf.log output that either the wrong mysql or > > > the wrong compilation options are attempted to be feed into the > > > compile process. > > > > if it works with you can you tel me how for snowleopard. For you it is > > obvious but not for me > > How you installed MySQL? using binaries form [dev.mysql.com](http://dev.mysql.com) or using > MacPorts (sudo port install mysql5?) > > If using ports, it should find the path automatically. If not and was > installed by binary packages, first you need to ensure the binaries > are in the same architecture your Ruby installation. > > After checking that, you need to ensure mysql\_config or mysql5\_config > is available in the path (using which). > > Then you can provide it to the gem installation process: > > gem install mysql – --with-mysql-config=/path/to/mysql/bin/ > mysql\_config Everybody thanks voor the help, also i have to apologize to all of you. Because i forgot that i had a clean install of OSX, So wen Luis wrote: "How you installed MySQL? " I remembered that i dident instlall MySql. Again i apologize Younes B. ---
**Author:** ![webwizart](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/f07891/32.png) [@webwizart](https://www.ruby-forum.com/u/webwizart)\ **Post date:** [September 20, 2010, 6:46pm UTC](https://www.ruby-forum.com/t/problem-install-mysql-gem-os-10-6-4/195257/7 "2010-09-20T18:46:15Z")
Luis L. wrote: > On Sep 20, 12:34�pm, Edmond K. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) > wrote: > > > Younes, > > > > I stopped using mysql gem. The whole gem is messed up seriously. > > Really? How? Please provide the real details. > > I package the MySQL/Ruby extension as a gem and tested in Ubuntu, Snow > Leopard, Leopard and even Windows. > > Please be more specific on what you mean by that. > > It is clear from the mkmf.log output that either the wrong mysql or > the wrong compilation options are attempted to be feed into the > compile process. if it works with you can you tel me how for snowleopard. For you it is obvious but not for me thanks webwizart