[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

[Q} MySQL & Ruby

Nikos Polizotis

11/11/2004 2:45:00 PM

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

Stu

11/11/2004 4:33:00 PM

0

On Thu, 11 Nov 2004 23:45:11 +0900, Nikos Polizotis
<npolizotis@gmail.com> wrote:

>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....
3x3 Eyes Fanfiction Archive
http://www.mega-tok...

Nikos Polizotis

11/11/2004 4:43:00 PM

0

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

On Fri, 12 Nov 2004 01:33:33 +0900, Stu <ceaser@rome.net> wrote:
> On Thu, 11 Nov 2004 23:45:11 +0900, Nikos Polizotis
>
>
> <npolizotis@gmail.com> wrote:
>
> >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....
> 3x3 Eyes Fanfiction Archive
> http://www.mega-tok...
>
>

Nikos Polizotis

11/11/2004 6:04:00 PM

0

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


On Thu, 11 Nov 2004 18:43:16 +0200, Nikos Polizotis
<npolizotis@gmail.com> wrote:
> I was hoping for a native version of the driver
> but I 'll give it a try.
>
>
>
> On Fri, 12 Nov 2004 01:33:33 +0900, Stu <ceaser@rome.net> wrote:
> > On Thu, 11 Nov 2004 23:45:11 +0900, Nikos Polizotis
> >
> >
> > <npolizotis@gmail.com> wrote:
> >
> > >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....
> > 3x3 Eyes Fanfiction Archive
> > http://www.mega-tok...
> >
> >
>

Curt Hibbs

11/11/2004 6:21:00 PM

0

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: rails-bounces@lists.rubyonrails.org
[mailto:rails-bounces@lists.rubyonrails.org]On Behalf Of Jason Hoffman
Sent: Wednesday, November 10, 2004 6:47 PM
To: rails@lists.rubyonrails.org
Subject: Re: [Rails] MySQL Error


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


>> Your server is 4.1.7 and it's likely that your client is not. This
>> error is what happens if you upgraded your server from 4.1.6gamma to
>> 4.1.7, but then left the client at 4.1.6gamma or lesser. Or if you
>> have
>> a 4.1.7 server that you are trying to talk to remotely with an old
>> client.
>
> 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_c...

- - J