From: Xeno Campanoli <xcampanoli@...>
Date: 2008-01-05T08:04:42+09:00
Subject: Re: DBI doesn't seem to install correctly on CentOS

Xeno Campanoli wrote:
> Xeno Campanoli wrote:
>> Xeno Campanoli wrote:
>>> Joshua Schairbaum 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?


> #!/usr/bin/ruby -w
>    # simple.rb - simple MySQL script using Ruby DBI module
> 
>    require "dbi"
> 
> begin
>  # connect to the MySQL server
>  dbh = DBI.connect("DBI:Mysql:test:localhost", "testuser", "testpass")
>  # get server version string and display it
>  row = dbh.select_one("SELECT VERSION()")
>  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 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.
>> I just tried rebooting also, and that doesn't help.
>>
>> xc
>>
>>> 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
>>>
>>>> Regards,
>>>> ch0wda
>>>>
>>>> On Jan 4, 2008, at 3:19 PM, Xeno Campanoli wrote:
>>>>
>>>>> 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
>>>>>
>>>>> -- 
>>>>> The only sustainable organizing methods focus not on scale,
>>>>> but on good design of the functional unit,
>>>>> not on winning battles, but on preservation.
>>>>>
>>
> 
> 


-- 
The only sustainable organizing methods focus not on scale,
but on good design of the functional unit,
not on winning battles, but on preservation.