[Q} MySQL & Ruby

[Nikos Polizotis]

Hi,

Has anybody got any clues how to make the mysql bindings work with MySQL 4.1.7?

I tried the .so created by Justin( thanks by the way)
and it causes ruby to crash. I compiled it myself with VC 6 but to no avail.
( WinXP ,ruby 1.8.2 (one-click installer) ,MySql 4.1.7)

Thanks

 

[Stu]

Hi,

Has anybody got any clues how to make the mysql bindings work with MySQL 4.1.7?

I tried the .so created by Justin( thanks by the way)
and it causes ruby to crash. I compiled it myself with VC 6 but to no avail.
( WinXP ,ruby 1.8.2 (one-click installer) ,MySql 4.1.7)

Thanks

have you looked at the mysql ruby package that doesnt require
any .so's or binaries...

ruby-mysql-0.2.5.tar.gz

works fine on my winxp + mysql

-- Dark Fiber --
[FAQ] Write Your Own Operating System
http://www.mega-tokyo.com/osfaq2
3x3 Eyes Fanfiction Archive
http://www.mega-tokyo.com/pai

 

[Nikos Polizotis]

I was hoping for a native version of the driver
but I 'll give it a try.

Hi,

Has anybody got any clues how to make the mysql bindings work with MySQL 4.1.7?

I tried the .so created by Justin( thanks by the way)
and it causes ruby to crash. I compiled it myself with VC 6 but to no avail.
( WinXP ,ruby 1.8.2 (one-click installer) ,MySql 4.1.7)

Thanks

have you looked at the mysql ruby package that doesnt require
any .so's or binaries...

ruby-mysql-0.2.5.tar.gz

works fine on my winxp + mysql

-- Dark Fiber --
[FAQ] Write Your Own Operating System
http://www.mega-tokyo.com/osfaq2
3x3 Eyes Fanfiction Archive
http://www.mega-tokyo.com/pai

 

[Nikos Polizotis]

Unfortunately neither driver works for Mysql 4.1.7 .

I get a " Client does not support authentication protocol requested by
server; consider upgrading MySQL client (Mysql::Error)" message when
trying to connect as root to localhost with a password (mysql variable
old_passwords is turned on as well).

Any clues?
Thanks

I was hoping for a native version of the driver
but I 'll give it a try.

Hi,

Has anybody got any clues how to make the mysql bindings work with MySQL 4.1.7?

I tried the .so created by Justin( thanks by the way)
and it causes ruby to crash. I compiled it myself with VC 6 but to no avail.
( WinXP ,ruby 1.8.2 (one-click installer) ,MySql 4.1.7)

Thanks

have you looked at the mysql ruby package that doesnt require
any .so's or binaries...

ruby-mysql-0.2.5.tar.gz

works fine on my winxp + mysql

-- Dark Fiber --
[FAQ] Write Your Own Operating System
http://www.mega-tokyo.com/osfaq2
3x3 Eyes Fanfiction Archive
http://www.mega-tokyo.com/pai

 

[Curt Hibbs]

Nikos Polizotis wrote:> Sent: Thursday, November 11, 2004 12:04 PM

Unfortunately neither driver works for Mysql 4.1.7 .

I get a " Client does not support authentication protocol requested by
server; consider upgrading MySQL client (Mysql::Error)" message when
trying to connect as root to localhost with a password (mysql variable
old_passwords is turned on as well).

Any clues?

I just got over this one yesterday (thanks to the help on the Rails ML).

The short answer is that starting with 4.1.7 MySQL changed the way it hashes
passwords, so clients (like what is included in Rails) need to be updated to
use the new hash as well.

I reinstalled 4.1.7 without a root password and left the Rails database
config password blank. That worked for me.

Below is the response I got from Jason with a link to more info in the MySQL
site (which include numerous work-arounds).

Curt


-----Original Message-----
From: (e-mail address removed)
[mailto:[email protected]]On Behalf Of Jason Hoffman
Sent: Wednesday, November 10, 2004 6:47 PM
To: (e-mail address removed)
Subject: Re: [Rails] MySQL Error


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

That makes come sense as I just installed a new version of MySQL.

So they really changed the authentication protocol in 4.1.7?

Yes in 4.1.x, you can read about the "Client does not support
authentication protocol" error here
http://dev.mysql.com/doc/mysql/en/Old_client.html

- - J