From: markus jais <info@...>
Date: 2001-07-02T05:12:57+09:00
Subject: [ruby-talk:17128] ruby-dbi problem with mysql

hi,

I installed Ruby dbi on my Red Hat 7.1 from source
(1.6.4)  and the mysql-rpms from the
RH cd.

I translated a short perl script to ruby:

--------
require "dbi"

dbh = DBI.connect("dbi:mysql:products", "markus", "passwd")
sql = "SELECT code , description FROM stock";
sth = dbh.prepare(sql)

res = Array.new
res = sth.execute

res.each { |elem|
        print elem, "\n"
}
------

I got the following error:

/usr/local/lib/ruby/1.6/dbi/dbi.rb:289:in `load_driver': Could not load
driver (No such file to load -- DBD/mysql/mysql) (DBI::InterfaceError)
        from /usr/local/lib/ruby/1.6/dbi/dbi.rb:252:in `connect'
        from ./dbi1.rb:5

I saw that the mysql directory unter DBD was written with
an uppercase "M" as well as Mysql.rb.
after renaming it to lowercase,  (DBD/mysql/mysql.rb )it seemed to work
but prodocuced another error:

/usr/local/lib/ruby/site_ruby/1.6/dbi/dbi.rb:289:in `load_driver': Could
not load driver (libmysqlclient.so.6: cannot load shared object file: No
such file or directory - /usr/local/lib/ruby/1.6/i686-linux/mysql.so)
(DBI::InterfaceError)
        from /usr/local/lib/ruby/site_ruby/1.6/dbi/dbi.rb:252:in
`connect'
        from ./dbi1.rb:5

after a
$ ln -s  libmysqlclient.so.10.0.0 libmysqlclient.so.6 
$ ldconfig
under /usr/lib/mysql

I got the following error:
/usr/local/lib/ruby/site_ruby/1.6/dbi/dbi.rb:282: [BUG] Segmentation
fault
ruby 1.6.4 (2001-06-04) [i686-linux]
Aborted (core dumped)

does anybody have an idea what went wrong????
I think the first error can is an error in the install script.

do anybody already know when the next version will be out??

regards
markus



-- 
Markus Jais
http://www.mjais.de
info@mjais.de
The road goes ever on and on - Bilbo Baggins