Gem install mysql

Rails
1

I’m trying to to ‘gem install mysql’ because it keeps saying that the
libraries i’m using for mysql are not fit for production.

the packages i have installed for ubuntu hardy 8.04 are:

mysql-client-5.0
mysql-client-5.0

i am running rails 1.87 and gem 1.2.0

here are my results:

root@webapp1:/u1/app/wonderland/log# gem install mysql
Building native extensions. This could take a while…
ERROR: Error installing mysql:
ERROR: Failed to build gem native extension.

/usr/bin/ruby1.8 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… yes
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.

any idea what else i might need to install?

here are some other packages that i might need but i don’t want to break
production if i don’t have to:

p libdbd-mysql-ruby - Ruby/DBI driver for MySQL
p libdbd-mysql-ruby1.8 - Ruby/DBI MySQL driver for Ruby 1.8
p libmysql5.0-cil - MySQL database connector for CLI

does anyone know offhand? thanks!

2

did you install build-essential and update?

sudo apt-get install build-essential
sudo apt-get install update

i think you’ll need this one too:

sudo apt-get install libmysqlclient15-dev

3

just to be clearer, i recently installed the mysql gem in
ubuntu 804 and this is what i had to install:

sudo apt-get install update
sudo apt-get install build-essential
sudo apt-get install mysql-server
sudo apt-get install libmysqlclient15-dev
sudo apt-get install libdbd-mysql-ruby

4

PP Junty wrote:

just to be clearer, i recently installed the mysql gem in
ubuntu 804 and this is what i had to install:

sudo apt-get install update
sudo apt-get install build-essential
sudo apt-get install mysql-server
sudo apt-get install libmysqlclient15-dev
sudo apt-get install libdbd-mysql-ruby

ah ok thanks. i did do update and build-essential

do you think i should install libdbd-mysql-ruby or libdbd-mysql-ruby1.8

what version of ruby are you running ppjunty?

5

ruby 1.8:

sudo apt-get install ruby1.8 ruby1.8-dev rdoc1.8 ri1.8

i installed libdbd-mysql-ruby, don’t now what would be
better.

ah ok thanks. i did do update and build-essential

do you think i should install libdbd-mysql-ruby or libdbd-mysql-ruby1.8

what version of ruby are you running ppjunty?

6

cool thanks i got it installed with that advice.

hmm…i have restarted my sql and apache, how do i know if i’m using the
gem libraries for mysql or my original install libraries?

7

rails will place the warning below in your log
file if the mysql gem is not being used:

“WARNING: You’re using the Ruby-based MySQL library that
ships with Rails. This library is not suited for production.
Please install the C-based MySQL library instead (gem install mysql).”

Scott K. wrote:

cool thanks i got it installed with that advice.

hmm…i have restarted my sql and apache, how do i know if i’m using the
gem libraries for mysql or my original install libraries?