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
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
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.com/osfaq2
3x3 Eyes Fanfiction Archive
http://www.mega-tokyo.com/pai
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.com/osfaq2
> 3x3 Eyes Fanfiction Archive
> http://www.mega-tokyo.com/pai
>
>
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_client.html
- - J