RE: revDatabase
Hi,
MySQL 4.1 was my first encounter with the database. The original
complaint is due to 16 vs 41 byte passwords.
Since Revolution is the only client application I have, and since it
only support old passwords, my solution was to add "old-passwords" in
the [mysqld] section of the my.cnf file. You can update the grant tables
to use old passwords with:
SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
It worked for me.
-- Harvey
--
___
use-revolution mailing list
use-revolution@lists.runrev.com
http://lists.runrev.com/mailman/listinfo/use-revolution
Re: revDatabase
> It could be new vs old passwords. that's what it is, but my question is more "does runrev have a updated database library that can be used with v2.0?" is there anything in the database library used in 2.5 that makes it incompatiable with 2.0/2.1 ? anyways, to sort out my problems i just went to a lower version of mysql that is supported by rev 2.0 ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: revDatabase
I think you need to upgrade the grant tables: http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html I did what they say there when I upgraded to MySQL 4.1 and had no problems connecting with Rev. Sarah On 04/03/2005, at 1:32 AM, [EMAIL PROTECTED] wrote: i'm trying to use the revDatabase library features and am connecting to a MySQL database, but am getting the error "Client does not support authentication protocol requested by server; consider upgrading MySQL client".. what MySQL says about this error is: "MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. If you upgrade the server to 4.1, attempts to connect to it with an older client may fail with the following message:" i'm using: RunRev 2.0.3 Mac OS X 10.3.8 MySQL 4.1.10-standard is there a newer version of the library that connects to the MySQL server properly? ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: revDatabase
Can't help with those questions, Sean. Dan On Mar 3, 2005, at 3:35 PM, [EMAIL PROTECTED] wrote: so runrev 2.5 uses the updated mysql protocol.. does 2.5's revDatabase library work with 2.0/ 2.1 ? if so, where on the support website can one download it? I can report that on OS X 10.3.8 with Rev 2.5 and the same MySQL as you're running, connections work just fine. ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: revDatabase
so runrev 2.5 uses the updated mysql protocol.. does 2.5's revDatabase library work with 2.0/ 2.1 ? if so, where on the support website can one download it? > I can report that on OS X 10.3.8 with Rev 2.5 and the same MySQL as > you're running, connections work just fine. ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: revDatabase
It could be new vs old passwords. 4.1 uses a new password encryption routine. It is possible however to create / set the mysql database to accept an old style password for an account Keith - Original Message - From: "Dan Shafer" <[EMAIL PROTECTED]> To: "How to use Revolution" Sent: Friday, March 04, 2005 8:46 AM Subject: Re: revDatabase > I can report that on OS X 10.3.8 with Rev 2.5 and the same MySQL as > you're running, connections work just fine. > > Dan > > On Mar 3, 2005, at 7:33 AM, [EMAIL PROTECTED] wrote: > > > i'm trying to use the revDatabase library features and am connecting > > to a MySQL database, but > > am getting the error "Client does not support authentication protocol > > requested by server; > > consider upgrading MySQL client".. > > > > what MySQL says about this error is: > > "MySQL 4.1 and up uses an authentication protocol based on a password > > hashing algorithm > > that is incompatible with that used by older clients. If you upgrade > > the server to 4.1, attempts > > to connect to it with an older client may fail with the following > > message:" > > > > i'm using: > > RunRev 2.0.3 > > Mac OS X 10.3.8 > > MySQL 4.1.10-standard > > > > is there a newer version of the library that connects to the MySQL > > server properly? > > > > > > ___ > > use-revolution mailing list > > use-revolution@lists.runrev.com > > http://lists.runrev.com/mailman/listinfo/use-revolution > > > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: revDatabase
I can report that on OS X 10.3.8 with Rev 2.5 and the same MySQL as you're running, connections work just fine. Dan On Mar 3, 2005, at 7:33 AM, [EMAIL PROTECTED] wrote: i'm trying to use the revDatabase library features and am connecting to a MySQL database, but am getting the error "Client does not support authentication protocol requested by server; consider upgrading MySQL client".. what MySQL says about this error is: "MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. If you upgrade the server to 4.1, attempts to connect to it with an older client may fail with the following message:" i'm using: RunRev 2.0.3 Mac OS X 10.3.8 MySQL 4.1.10-standard is there a newer version of the library that connects to the MySQL server properly? ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
