Page 1 of 1

The mySQL error was: Client does not support authentication

Posted: Thu Nov 04, 2004 11:22 pm
by 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? :)

Posted: Fri Nov 05, 2004 12:09 am
by tomsommer
I think your MySQL server is broken, or lacking some auth modules - never seen that error before though

Posted: Fri Nov 05, 2004 8:36 am
by Junior
But how can this be, I just installed it?

I´ll try to reinstall it...

Posted: Fri Nov 05, 2004 11:55 am
by 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.

Posted: Fri Nov 05, 2004 12:21 pm
by Junior
Thank you, I´ll try that!

Next problem

Posted: Fri Nov 05, 2004 2:37 pm
by 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.

Re: Next problem

Posted: Fri Nov 05, 2004 6:45 pm
by 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.

Posted: Fri Nov 05, 2004 11:07 pm
by 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