The mySQL error was: Client does not support authentication

[Junior]

Hi!

OS: XP (yeah, I know...)
WebServer: Apache2
PHP version: 4.3.9
MySQL version: 4.1.7-nt

Problem:

This is what I get when I press "check and save" from the config page:

- Could not connect to database; check your settings.
The mySQL error was: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Am I just tired or is there anything that´s broken?

[tomsommer]

I think your MySQL server is broken, or lacking some auth modules - never seen that error before though

[Junior]

But how can this be, I just installed it?

I´ll try to reinstall it...

[garvinhicking]

It seems that the DLL for your PHP-MySQL module is using an outdated client API specification. You are advised to use mysqli instead, or downgrade your MySQL version to a 4.0 version.

Regards,
Garvin.

[Junior]

Thank you, I´ll try that!

[Junior]

I don´t know if that was the problem or not, but now I have it up and running, thanks!

It seems like that was not the only problem... if you enter a long name as the administrator name, you won´t be able to enter the admin page.

Try: 123456789 123456789123 as name (which just happens to be as long as my real name).

I think I found another problem with the database user as well, but I have to try it again.

[garvinhicking]

Yes, the database username is limited to 20 characters, and password to 32 characters...to be honest, since all the time Serendipity exists (about 2 years now) nobody ever used a longer name.

Regards,
Garvin.

[tomsommer]

The password is not limited to 32 chars, as it is md5 encoded and md5 is always 32 chars, nomatter what the password might be