mysql gem warning on ubuntu

rubyonrails-talk
1

i just deployed my app on ubuntu with passenger. i installed the mysql gem as follows:

$ sudo gem install mysql Select which gem to install for your platform (i486-linux) 1. mysql 2.7.3 (mswin32) 2. mysql 2.7.1 (mswin32) 3. mysql 2.7 (ruby) 4. mysql 2.6 (ruby) 5. Skip this gem 6. Cancel installation

3

Building native extensions. This could take a while... Successfully installed mysql-2.7

ok. restarted my app and in my log file was

"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)."

i tried installation switchers like "-with-mysql-config" and "-with-mysql-dir" but none solved the problem. i checked for missing packages (rub1.8-dev, build-essential, libmysqlclient15-dev, etc) and they are there. any ideas? thanks.

2

my database.yml configuration:

production:   adapter: mysql   encoding: utf8   database: myapp_production   username: root   password:   host: localhost   socket: /var/run/mysqld/mysqld.sock

3

Did you try follow the instructions it gave you? Try to do gem install
mysql.

4

hello Ryan, thanks for your reply. as i stated above:

"i installed the mysql gem as follows:

$ sudo gem install mysql"

i got the warning after the installation.

Ryan Bigg wrote:

5

dont worry about that. Try to copy and paste libmySQL.dll from your mysql/bin to your ruby/bin. Sorry, if my solution will not answer your problem.

Reinhart http://teapoci.blogspot.com

6

what happens if you open an irb prompt and type require 'rubygems' require 'mysql'

Fred

7

Rails Terrorist, i'm on ubuntu. are you sure?

Fred, i followed your advice, and the result was:

$ irb irb(main):001:0> require "rubygems" => true irb(main):001:0> require "mysql" LoadError: no such file to load -- mysql   from (irb):1:in `require'   from (irb):1 irb(main):002:0>

i did some research on this error message and found a tip about a package called libdbd-mysql-ruby. i installed it using

sudo apt-get install libdbd-mysql-ruby

and:

irb(main):001:0> require "mysql" => true

the warning message vanished too, so i'd say mission accomplished on this one. many thanks for your help.