From: dc <lister@...>
Date: 2006-09-23T22:43:29+09:00
Subject: ruby and mysql

hello!

can someone explain to me the basic usage for the native mysql
bindings for ruby?

I'm on OSX and have installed the pure ruby drivers (mysql-2.7) using gem

however, i'm getting the following error on trying a simple connection.

Mysql::Error: Client does not support authentication protocol
requested by server; consider upgrading MySQL client

so, it looks like the pure ruby drivers are pretty old. maybe the
native ones are newer?

is there any difference in usage?

also, i guess there are generic DBI drivers - is this a more recommended route?
http://ruby-dbi.rubyforge.org/

since i also want to do some rails stuff, does rails assume mysql is
working, and/or need the naive libs for that working?

~/src/ruby-mysql-0.2.6 > sudo ruby ./test.rb localhost XXX  XXXPW
connect............../mysql.rb:453:in `read': Client does not support
authentication protocol requested by server; consider upgrading MySQL
client (Mysql::Error)
        from ./mysql.rb:130:in `real_connect'
        from ./mysql.rb:91:in `initialize'
        from ./mysql.rb:1085:in `new'
        from ./mysql.rb:1085:in `connect'
        from ./t/00connect.rb:1
        from ./test.rb:23:in `load'
        from ./test.rb:23
        from ./test.rb:19:in `each'
        from ./test.rb:19


thanks for any help!

/dc
-------------------------------------------
      David "DC" Collier
mailto:dc@pikkle.com
      +81 (0)80 6521 9559
      skype: callto://d3ntaku
-------------------------------------------
      Pikkle 株式会社
      http://www.pikkle.com
-------------------------------------------