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:inreal_connect’
from ./mysql.rb:91:in initialize' from ./mysql.rb:1085:innew’
from ./mysql.rb:1085:in connect' from ./t/00connect.rb:1 from ./test.rb:23:inload’
from ./test.rb:23
from ./test.rb:19:in `each’
from ./test.rb:19

thanks for any help!

/dc

  David "DC" Collier

mailto:[email protected]
+81 (0)80 6521 9559
skype: callto://d3ntaku

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

dc wrote:

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 wrote:

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

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

On 23/09/06, David V. [email protected] wrote:

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-----

  David "DC" Collier

mailto:[email protected]
+81 (0)80 6521 9559
skype: callto://d3ntaku

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs