Mysql gem warning on ubuntu

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.

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

my database.yml configuration:

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

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.

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

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

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.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs