gem install mysql giving error on linux

Hi, I have mysql installed on linux. Whenever I am trying t "gem install mysql -- --with-mysql-dir=/usr/bin/mysql" I am getting following error:-

Building native extensions. This could take a while... ERROR: Error installing mysql:         ERROR: Failed to build gem native extension.

/usr/local/bin/ruby extconf.rb --with-mysql-dir=/usr/bin/mysql checking for mysql_ssl_set()... *** 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=/usr/local/bin/ruby         --with-mysql-config         --without-mysql-config /usr/local/lib/ruby/1.8/mkmf.rb:364:in `try_do': The complier failed to generate an executable file. (RuntimeError) You have to install development tools first.         from /usr/local/lib/ruby/1.8/mkmf.rb:432:in `try_link0'         from /usr/local/lib/ruby/1.8/mkmf.rb:437:in `try_link'         from /usr/local/lib/ruby/1.8/mkmf.rb:549:in `try_func'         from /usr/local/lib/ruby/1.8/mkmf.rb:794:in `have_func'         from /usr/local/lib/ruby/1.8/mkmf.rb:690:in `checking_for'         from /usr/local/lib/ruby/1.8/mkmf.rb:279:in `postpone'         from /usr/local/lib/ruby/1.8/mkmf.rb:253:in `open'         from /usr/local/lib/ruby/1.8/mkmf.rb:279:in `postpone'         from /usr/local/lib/ruby/1.8/mkmf.rb:253:in `open'         from /usr/local/lib/ruby/1.8/mkmf.rb:275:in `postpone'         from /usr/local/lib/ruby/1.8/mkmf.rb:689:in `checking_for'         from /usr/local/lib/ruby/1.8/mkmf.rb:793:in `have_func'         from extconf.rb:50

Gem files will remain installed in /usr/local/lib/ruby/gems/1.8/gems/mysql-2.8.1 for inspection. Results logged to /usr/local/lib/ruby/gems/1.8/gems/mysql-2.8.1/ext/mysql_api/gem_make.out

Can anyone tell me how to solve this? Thanks, Tushar

Do you have the mysql header files ?

Fred

Hi, I solved the issue. I forgot to install "mysql-delop" client. My problem I was working on windows since last 2 years. I moved to linux now and I am facing lot of problem for installation. I don't why the installation process for platforms is different as well as cumbersome to install.

Anyone have any answer on this. Thanks, Tushar