Mysql gem warning on ubuntu

Rails
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

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

3

my database.yml configuration:

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

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 B. wrote:

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

5

On Jul 3, 8:25 pm, Pepe J. [email protected]
wrote:

  1. Cancel installation> 3

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

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

Fred

6

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

7

Rails T., 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.