# Unable to load mysql driver (Ubuntu 8.04)

**URL:** <https://www.ruby-forum.com/t/unable-to-load-mysql-driver-ubuntu-8-04/146069>\
**Category:** Ruby\
**Created:** [August 17, 2008, 7:13am UTC](https://www.ruby-forum.com/t/unable-to-load-mysql-driver-ubuntu-8-04/146069 "2008-08-17T07:13:02Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![supasta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ebca7d/32.png) [@supasta](https://www.ruby-forum.com/u/supasta)\
**Post date:** [August 17, 2008, 7:13am UTC](https://www.ruby-forum.com/t/unable-to-load-mysql-driver-ubuntu-8-04/146069/1 "2008-08-17T07:13:02Z")

</div>

Hi,

When I try to run a script that requires “dbi” I get the following  
error:

/usr/local/lib/ruby/site\_ruby/1.8/dbi.rb:352:in `load_driver': Unable to load driver 'Mysql' (DBI::InterfaceError) from /usr/local/lib/ruby/1.8/monitor.rb:242:in`synchronize’  
from /usr/local/lib/ruby/site\_ruby/1.8/dbi.rb:282:in `load_driver' from /usr/local/lib/ruby/site_ruby/1.8/dbi.rb:233:in`\_get\_full\_driver’  
from /usr/local/lib/ruby/site\_ruby/1.8/dbi.rb:219:in `connect’

The Mysql server is working fine and my Rails apps can even access it.

The script itself has previously worked on other installations.

I do have gem mysql-2.7 installed.

ruby 1.8.7 (2008-08-11 patchlevel 72) [x86\_64-linux]

Any help tracking the source of this problem down would be greatly  
appreciated.

---

<div class="post-metadata">

**Author:** ![supasta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ebca7d/32.png) [@supasta](https://www.ruby-forum.com/u/supasta)\
**Post date:** [August 17, 2008, 7:48am UTC](https://www.ruby-forum.com/t/unable-to-load-mysql-driver-ubuntu-8-04/146069/2 "2008-08-17T07:48:49Z")

</div>

On Sunday 17 August 2008 00:09:54 Chris W. wrote:

> /usr/local/lib/ruby/site\_ruby/1.8/dbi.rb:352:in `load\_driver’: Unable to  
> load driver ‘Mysql’ (DBI::InterfaceError)  
> […]  
> The Mysql server is working fine and my Rails apps can even access it.

That doesn’t mean there’s Ruby support for MySQL installed.

I would guess that you need to install the mysql gem, and possibly more  
DBI-specific bindings for it.

---

<div class="post-metadata">

**Author:** ![supasta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ebca7d/32.png) [@supasta](https://www.ruby-forum.com/u/supasta)\
**Post date:** [August 17, 2008, 7:30pm UTC](https://www.ruby-forum.com/t/unable-to-load-mysql-driver-ubuntu-8-04/146069/3 "2008-08-17T19:30:50Z")

</div>

David M. wrote:

> That doesn’t mean there’s Ruby support for MySQL installed.
> 
> I would guess that you need to install the mysql gem, and possibly more  
> DBI-specific bindings for it.

Thanks for the reply, but as I said I did install the mysql gem already.  
I’ve uninstalled and reinstalled it multiple times both using gem and  
from source.

I also have installed libdbd-mysql-ruby1.8 from the repository. Also the  
mysql dev library is installed.

Ruby was installed from source instead of apt if that makes a  
difference.

---

<div class="post-metadata">

**Author:** ![supasta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ebca7d/32.png) [@supasta](https://www.ruby-forum.com/u/supasta)\
**Post date:** [August 17, 2008, 7:39pm UTC](https://www.ruby-forum.com/t/unable-to-load-mysql-driver-ubuntu-8-04/146069/4 "2008-08-17T19:39:29Z")

</div>

On Sunday 17 August 2008 12:27:42 Chris W. wrote:

> Thanks for the reply, but as I said I did install the mysql gem already.  
> I’ve uninstalled and reinstalled it multiple times both using gem and  
> from source.

Ah, sorry. Do you have rubygems require’d?

That’s all I’ve got…

---

<div class="post-metadata">

**Author:** ![supasta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ebca7d/32.png) [@supasta](https://www.ruby-forum.com/u/supasta)\
**Post date:** [September 4, 2008, 10:56pm UTC](https://www.ruby-forum.com/t/unable-to-load-mysql-driver-ubuntu-8-04/146069/5 "2008-09-04T22:56:54Z")

</div>

Just ran into same problem, here is the fix:

require ‘rubygems’  
gem ‘dbi’  
require ‘dbi’ # =\> Now the gems version gets loaded.

There is another dbi.rb that acts different than the one from gems:

/usr/lib/ruby/1.8/dbi.rb vs.  
/usr/lib/ruby/gems/1.8/gems/dbi-0.4.0/lib/dbi.rb

---

<div class="post-metadata">

**Author:** ![supasta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ebca7d/32.png) [@supasta](https://www.ruby-forum.com/u/supasta)\
**Post date:** [August 17, 2008, 9:43pm UTC](https://www.ruby-forum.com/t/unable-to-load-mysql-driver-ubuntu-8-04/146069/6 "2008-08-17T21:43:56Z")

</div>

David M. wrote:

> On Sunday 17 August 2008 12:27:42 Chris W. wrote:
> 
> > Thanks for the reply, but as I said I did install the mysql gem already.  
> > I’ve uninstalled and reinstalled it multiple times both using gem and  
> > from source.
> 
> Ah, sorry. Do you have rubygems require’d?
> 
> That’s all I’ve got…

Unfortunately that didn’t work either. I finally had to uninstall Ruby  
and install the older version in the repository with apt.
