DBI doesn't seem to install correctly on CentOS

I tried installing with the old tarfile sequence using setup.rb, as I
couldn’t get gems to work and there is apparently no yum install on
CentOS. When I went through the sequence found on
http://www.kitebird.com/articles/ruby-dbi.html#TOC_3, and then tried the
simple.rb script, I got:

% ruby simple.rb
/usr/lib/ruby/site_ruby/1.8/dbi.rb:344:in ‘load_driver’: Could not load
driver (no such file to load – mysql) (DBI::InterfaceError)
from /usr/lib/ruby/site_ruby/1.8/dbi.rb:227:in ‘_get_full_driver’
from /usr/lib/ruby/site_ruby/1.8/dbi.rb:213:in ‘connect’
from simple.rb:9

I presume I’m using old instructions or incomplete ones. Does anyone
have a more recent set of instructions, or can someone fill in my gap?

Sincerely, Xeno

Try this to use DBI with MySQL:

ruby setup.rb config --with=dbi,dbd_mysql

Regards,
ch0wda

Joshua S. wrote:

Try this to use DBI with MySQL:

ruby setup.rb config --with=dbi,dbd_mysql

That is in fact what I did, followed by:

ruby setup.rb setup
ruby setup.rb install

and my results were what I described already. I apparently need to know
the driver I need to load, or perhaps the yum install sequence I need to
use, or perhaps I just need to reboot. However, your suggestions were
what I already did.

xc

On 4 Jan, 20:32, Joshua S. [email protected]
wrote:

couldn’t get gems to work and there is apparently no yum install on
from /usr/lib/ruby/site_ruby/1.8/dbi.rb:213:in ‘connect’
not on winning battles, but on preservation.
I’d examine why yum doesn’t work in centos, it should do. Somethings
wrong with the OS somewhere.
Ian

Xeno C. wrote:

Joshua S. wrote:

Try this to use DBI with MySQL:

ruby setup.rb config --with=dbi,dbd_mysql

I just tried rebooting also, and that doesn’t help.

xc

Xeno C. wrote:

Xeno C. wrote:

Joshua S. wrote:

Try this to use DBI with MySQL:

ruby setup.rb config --with=dbi,dbd_mysql

the file is:
cksum dbi-0.1.1.tar.gz
3411302326 155533 dbi-0.1.1.tar.gz

I also just made sure libdbi-driver is installed by yum, among others,
and that has made no difference.

[email protected] wrote:

On 4 Jan, 20:32, Joshua S. [email protected]
wrote:

I’d examine why yum doesn’t work in centos, it should do. Somethings
wrong with the OS somewhere.
Ian

Yum works just fine, it’s just that CentOS doesn’t have a package for
DBI, so you have to try and install from the tar.gz, and it won’t work
for me. Yum will work fine if you can send me a rpm that works in the
CentOS world.

xc

Xeno C. wrote:

Xeno C. wrote:

Joshua S. wrote:

Try this to use DBI with MySQL:

ruby setup.rb config --with=dbi,dbd_mysql

I have lost the thread at a place in /usr/lib/ruby/site_ruby/1.8/dbi.rb
on line 297 where the class script is trying to do the following
require:
require "DBD/Mysql/Mysql

It may be that everything on this install is called “mysql”, but I’ve
tried all of the conceiveable combinations in my connect call and they
all fail the same way.

Xeno C. wrote:

Xeno C. wrote:

Xeno C. wrote:

Joshua S. wrote:

Try this to use DBI with MySQL:

ruby setup.rb config --with=dbi,dbd_mysql

This appears to fail the same way on my Ubuntu system after I installed
libdbi-ruby. Symptoms seem the same. I can go into mysql shell from
Bash, but I cannot use DBI and I get the same “Unable to load driver
‘Mysql’” message. Perhaps people just don’t use Mysql anymore?

puts "Server version: " + row[0]
rescue DBI::DatabaseError => e
puts “An error occurred”
puts “Error code: #{e.err}”
puts “Error message: #{e.errstr}”
ensure

disconnect from server

dbh.disconnect if dbh
end

the failure is happening on the dbh = DBI.connect line.

I’m not sure if you need this or not because I’m just getting into
using DBI myself, but did you install the mysql drivers? In the
README file, it mentioned that the Mysql DBD relied upon them. To
quote:

MySQL
Depends on the mysql package from http://www.tmtm.org/mysql or
available
from the RAA.

Regards.
ch0wda

There should be a link on that page that says “English” which will
take you to the translation.

Joshua S. wrote:

I’m not sure if you need this or not because I’m just getting into using
DBI myself, but did you install the mysql drivers? In the README file,
it mentioned that the Mysql DBD relied upon them. To quote:

MySQL
Depends on the mysql package from http://www.tmtm.org/mysql or available
from the RAA.

I cannot read that website, which I see as Japanese. Perhaps you could
translate. I have installed mysql-server and the shell command “mysql”
starts and works from Bash. As I said elsewhere:

the file is:
cksum dbi-0.1.1.tar.gz
3411302326 155533 dbi-0.1.1.tar.gz

I also just made sure libdbi-driver is installed by yum, among others,
and that has made no difference.

The implication may be that there is another driver thingy I need to
install, but if so, the instructions for doing so are spectacularly
unclear and not the kind of testimony that brings employers clamoring at
your door. I thought lots of people used Mysql in Rails, but perhaps
the world has moved on and Ruby Mysql DBI is so badly atrophied that it
is no longer maintained…?

Joshua S. wrote:

There should be a link on that page that says “English” which will take
you to the translation.

Yes, but the section on installation which it refers to is in Japanese?
Perhaps if you know something is there, can you give me an exact link
to the English, or paste it here? I suspect you’re not doing this
intentionally, and do appreciate efforts to help. I see no ultimate
instruction in English on the missing drivers.

Xeno C. wrote:

Joshua S. wrote:

There should be a link on that page that says “English” which will take
you to the translation.

I appear to have this working now, although I have not fully tested it.
What I did was install the “Mysql” ruby interface, which perhaps either
brought in the drivers correctly, or for all I know is used wholesale by
the DBI interface. Whatever. I’ll start a new thread if I find
problems.

Thank you for efforts to help in this matter. I was a little cranky
Friday from a stomach ache, so please forgive me for not being in my
best verbally.

Sincerely, Xeno
xc