# Mysql gem warning on ubuntu

**URL:** <https://www.ruby-forum.com/t/mysql-gem-warning-on-ubuntu/142148>\
**Category:** Rails\
**Created:** [July 3, 2008, 9:25pm UTC](https://www.ruby-forum.com/t/mysql-gem-warning-on-ubuntu/142148 "2008-07-03T21:25:30Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![ppjunty](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/aeb1de/32.png) [@ppjunty](https://www.ruby-forum.com/u/ppjunty)\
**Post date:** [July 3, 2008, 9:25pm UTC](https://www.ruby-forum.com/t/mysql-gem-warning-on-ubuntu/142148/1 "2008-07-03T21:25:30Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![ppjunty](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/aeb1de/32.png) [@ppjunty](https://www.ruby-forum.com/u/ppjunty)\
**Post date:** [July 4, 2008, 1:54am UTC](https://www.ruby-forum.com/t/mysql-gem-warning-on-ubuntu/142148/2 "2008-07-04T01:54:41Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ppjunty](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/aeb1de/32.png) [@ppjunty](https://www.ruby-forum.com/u/ppjunty)\
**Post date:** [July 3, 2008, 9:29pm UTC](https://www.ruby-forum.com/t/mysql-gem-warning-on-ubuntu/142148/3 "2008-07-03T21:29:00Z")

</div>

my database.yml configuration:

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

---

<div class="post-metadata">

**Author:** ![ppjunty](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/aeb1de/32.png) [@ppjunty](https://www.ruby-forum.com/u/ppjunty)\
**Post date:** [July 4, 2008, 4:06am UTC](https://www.ruby-forum.com/t/mysql-gem-warning-on-ubuntu/142148/4 "2008-07-04T04:06:15Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![ppjunty](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/aeb1de/32.png) [@ppjunty](https://www.ruby-forum.com/u/ppjunty)\
**Post date:** [July 4, 2008, 9:25am UTC](https://www.ruby-forum.com/t/mysql-gem-warning-on-ubuntu/142148/5 "2008-07-04T09:25:27Z")

</div>

On Jul 3, 8:25 pm, Pepe J. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
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

---

<div class="post-metadata">

**Author:** ![ppjunty](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/aeb1de/32.png) [@ppjunty](https://www.ruby-forum.com/u/ppjunty)\
**Post date:** [July 4, 2008, 8:30am UTC](https://www.ruby-forum.com/t/mysql-gem-warning-on-ubuntu/142148/6 "2008-07-04T08:30:07Z")

</div>

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](http://teapoci.blogspot.com)

---

<div class="post-metadata">

**Author:** ![ppjunty](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/aeb1de/32.png) [@ppjunty](https://www.ruby-forum.com/u/ppjunty)\
**Post date:** [July 4, 2008, 6:52pm UTC](https://www.ruby-forum.com/t/mysql-gem-warning-on-ubuntu/142148/7 "2008-07-04T18:52:52Z")

</div>

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.