# Problem install mysql Gem OS 10.6.4 **URL:** \ **Category:** ruby-talk\ **Created:** [20 September 2010 15:05 UTC](https://rubytalk.org/t/problem-install-mysql-gem-os-10-6-4/60133 "2010-09-20T15:05:02Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Younes\_Baghor](https://avatars.discourse-cdn.com/v4/letter/y/f0a364/32.png) [@Younes\_Baghor](https://rubytalk.org/u/Younes_Baghor)\ **Post date:** [20 September 2010 15:05 UTC](https://rubytalk.org/t/problem-install-mysql-gem-os-10-6-4/60133/1 "2010-09-20T15:05:02Z")
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 > -- > Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/). ---
**Author:** ![Edmond\_Kachale](https://avatars.discourse-cdn.com/v4/letter/e/85e7bf/32.png) [@Edmond\_Kachale](https://rubytalk.org/u/Edmond_Kachale)\ **Post date:** [20 September 2010 15:34 UTC](https://rubytalk.org/t/problem-install-mysql-gem-os-10-6-4/60133/2 "2010-09-20T15:34:33Z")
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/%5C)) | > Malawi > > Cell: +265 999 465 137 | +265 881 234 717 > > \*"Every Rubygem has its own gemspec"\* -- Edmond Kachale > > 2010/9/20 Younes Baghor \ > > > 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 > > -- > > Posted via [http://www.ruby-forum.com/\](http://www.ruby-forum.com/%5C). ---
**Author:** ![Edmond\_Kachale](https://avatars.discourse-cdn.com/v4/letter/e/85e7bf/32.png) [@Edmond\_Kachale](https://rubytalk.org/u/Edmond_Kachale)\ **Post date:** [20 September 2010 15:37 UTC](https://rubytalk.org/t/problem-install-mysql-gem-os-10-6-4/60133/3 "2010-09-20T15:37:44Z")
I meant to say \*libmysql-ruby. > **···** > > 2010/9/20 Edmond Kachale \ > > > 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/%5C)) | > > Malawi > > > > Cell: +265 999 465 137 | +265 881 234 717 > > > > \*"Every Rubygem has its own gemspec"\* -- Edmond Kachale > > > > 2010/9/20 Younes Baghor \ > > > > 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 > > > -- > > > Posted via [http://www.ruby-forum.com/\](http://www.ruby-forum.com/%5C). ---
**Author:** ![Luis\_Lavena1](https://avatars.discourse-cdn.com/v4/letter/l/f08c70/32.png) [@Luis\_Lavena1](https://rubytalk.org/u/Luis_Lavena1)\ **Post date:** [20 September 2010 16:30 UTC](https://rubytalk.org/t/problem-install-mysql-gem-os-10-6-4/60133/4 "2010-09-20T16:30:44Z")
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. > **···** > > On Sep 20, 12:34 pm, Edmond Kachale \ wrote: > > > Younes, > > > > I stopped using mysql gem. The whole gem is messed up seriously. > > -- > Luis Lavena ---
**Author:** ![Younes\_Baghor](https://avatars.discourse-cdn.com/v4/letter/y/f0a364/32.png) [@Younes\_Baghor](https://rubytalk.org/u/Younes_Baghor)\ **Post date:** [20 September 2010 16:46 UTC](https://rubytalk.org/t/problem-install-mysql-gem-os-10-6-4/60133/5 "2010-09-20T16:46:17Z")
Luis Lavena wrote: > **···** > > > On Sep 20, 12:34�pm, Edmond Kachale \ \> 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 > -- > Posted via [http://www.ruby-forum.com/\](http://www.ruby-forum.com/%5C). ---
**Author:** ![Luis\_Lavena1](https://avatars.discourse-cdn.com/v4/letter/l/f08c70/32.png) [@Luis\_Lavena1](https://rubytalk.org/u/Luis_Lavena1)\ **Post date:** [20 September 2010 17:20 UTC](https://rubytalk.org/t/problem-install-mysql-gem-os-10-6-4/60133/6 "2010-09-20T17:20:09Z")
How you installed MySQL? using binaries form 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 > **···** > > On Sep 20, 1:46 pm, Younes Baghor \ wrote: > > > Luis Lavena wrote: > > \> On Sep 20, 12:34 pm, Edmond Kachale \ \> \> 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 > > -- > Luis Lavena ---
**Author:** ![Younes\_Baghor](https://avatars.discourse-cdn.com/v4/letter/y/f0a364/32.png) [@Younes\_Baghor](https://rubytalk.org/u/Younes_Baghor)\ **Post date:** [20 September 2010 20:36 UTC](https://rubytalk.org/t/problem-install-mysql-gem-os-10-6-4/60133/7 "2010-09-20T20:36:27Z")
Luis Lavena 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 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 Baghor > **···** > > > On Sep 20, 1:46�pm, Younes Baghor \ wrote: > > -- > Posted via [http://www.ruby-forum.com/\](http://www.ruby-forum.com/%5C).