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

dc wrote:

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

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.

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 Vallner <david@vallner.net> wrote:

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

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