Package: mysql-common-4.1
Version: 4.1.11a-4

Hello,


although Debian Sarge includes mysql 4.1 as an alternative package to
4.0, the client applications of Debian are linked to the old library.

However, mysql 4.1 uses a new auth protocol and a different style of
storing passwords. Old mysql user entries will still work, but when
creating a new mysql user entry with 4.1, old clients will fail to
connect with the error message that the "Client does not support
authentication protocol requested by server; consider upgrading MySQL
client".

http://dev.mysql.com/doc/mysql/en/old-client.html

As an example, this happens when using Sarge's php4-mysql with Sarge's
mysql 4.1.

Please advise all client application package managers on Debian to link
to the 4.1 compatible libraries instead to 4.0. This should include
libapache-mod-auth-mysql, libdbd-mysql-perl, php4-mysql and others.

Otherwise, users will be bitten by this behavious whenever they create a
new user.


Thanks,

Hanno

P.S.: Btw., a quickfix to this issue is to use old_password() instead of
password() when creating a new mysql user in 4.1 if older clients want
to connect to the server. That's what I do at the moment.


-- 
Hanno Müller, Dipl.-Inform.

epublica GmbH
http://www.epublica.de
Tel. +49 (0)40/4109879-4

Open Business Club - Mitglied werden: http://www.openbc.com/go/invanon/2



-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to