OSCommerce Product Manager

OSCommerce Product Manager for Windows
Tasklist

FS#144 - Error when authenticating with MySQL 4.1.x. and 5.x.x

Attached to Project: OSCommerce Product Manager
Opened by Mario A. Valdez-Ramirez (mvaldez) - Sunday, 16 January 2005, 15:02 GMT-6
Last edited by Mario A. Valdez-Ramirez (mvaldez) - Monday, 27 March 2006, 02:33 GMT-6
Task Type Bug Report
Category Backend / Core
Status Closed
Assigned To Mario A. Valdez-Ramirez (mvaldez)
Operating System All
Severity Medium
Priority Urgent
Reported Version any
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

An user reported in the forums when using MySQL 4.1.8:

SQL Error: client does not support authentication protocol requested by server; consider upgrading MySQL client.


It seems the server is using a new authentication method unsupported by the version of ZEOSLib we are using (6.0.12). We cannot use 6.1.2 or higher (yet) because they are in beta stage.

Solution for the user is to reset the password of the MySQL user to use an old password style, as described in the MySQL documentation:

Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');


Reference:
http://dev.mysql.com/doc/mysql/en/Old_client.html


Pending to upgrade to the latest ZEOSlib when available.
This task depends upon

Closed by  Mario A. Valdez-Ramirez (mvaldez)
Monday, 27 March 2006, 02:33 GMT-6
Reason for closing:  
Comment by Mario A. Valdez-Ramirez (mvaldez) - Sunday, 20 March 2005, 15:53 GMT-6


Today, Zeoslib 6.5.x is still in alpha.

Comment by Mario A. Valdez-Ramirez (mvaldez) - Saturday, 21 May 2005, 06:22 GMT-6

Today, Zeoslib 6.5.x is still in alpha... and it seems it will be like that for a while.
Comment by Mario A. Valdez-Ramirez (mvaldez) - Tuesday, 30 August 2005, 02:37 GMT-6
Today, Zeoslib 6.5.x is still in alpha.
Comment by Mario A. Valdez-Ramirez (mvaldez) - Wednesday, 07 September 2005, 19:27 GMT-6

This bug may become obsolete if bug #66 is implemented.

Comment by Mario A. Valdez-Ramirez (mvaldez) - Monday, 23 January 2006, 07:38 GMT-6

Chnaged title to include also MySQL 5.
Comment by Mario A. Valdez-Ramirez (mvaldez) - Monday, 23 January 2006, 07:40 GMT-6
Today, Zeoslib 6.5.x is still in alpha.
Comment by Mario A. Valdez-Ramirez (mvaldez) - Monday, 27 March 2006, 02:32 GMT-6

Ok, Bug #66 hass been implemented, so this bug is officially obsolete.

We will close it with "Will not fix".

As of today, we no longer use Zeoslib components.

Loading...