ruby and mysql

[dc]

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

 

[Robert Klemme]

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?

You can probably change security settings on the database as well.

robert

 

[David Vallner]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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

DBI is just a database abstraction library, it still depends on the
vendor-specific clients.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFFT5gy6MhrS8astoRArfkAJ0Qu6r701PjDwokSNykIgQ8apTGlQCeOIFV
kz2YM1eUFGtMV/VzsTBn30Q=
=vHrO
-----END PGP SIGNATURE-----

 

[dc]

OK got things to work. after lots of google hiccups, this article
solved things regarding recompiling latest ruby/mysql drivers.

i think the main issue is that if you have the gem libs installed,
they somehow get used first, instead of the native drivers?

http://tonyarnold.com/articles/2005/08/11/mysql-bindings-for-ruby-under-mac-os-x-tiger

for what its worth, cocoaMysql beta version is also needed to connect...

this was unfortunately a lot more painful than setting up on windows...

/dc

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


DBI is just a database abstraction library, it still depends on the
vendor-specific clients.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFFT5gy6MhrS8astoRArfkAJ0Qu6r701PjDwokSNykIgQ8apTGlQCeOIFV
kz2YM1eUFGtMV/VzsTBn30Q=
=vHrO
-----END PGP SIGNATURE-----

--