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