CMS Made Simple Forums

This is the message I get back from the install.php in step 3 if I uncomment the debug statement.

localhost Client does not support authentication protocol requested by server; consider upgrading MySQL client
Connection failed

Windows XP, Apache 2.0, MySql 4.1.5, PHP 4.3.9, CMS 0.6.3

Ok, this one seems to be related to mysql 4.1.+

Sounds like the interface library changed and (I suppose) the original mysql driver does not work anymore.

Let me do some research on adodb and how it is handling this issue and see if I can come up with a resolution.

I think I have this fixed in svn, but I really don't have a way to test it without trying to set that environment up. I'll see what I can do...

I can test a little if it wasn't too much change to the install.php. Can you post the changes here?

Well, the problem is that I had to copy another driver from the adodb library (used for database abstraction) which I also upgraded to the latest version. The install.php change it very minor, but there is the issue of getting the new driver.

Really, the best thing to do would be to grab the latest code from svn and try that, but that's up to you on wether you want to take the time to do it.

No experience with svn. I'll wait, I guess. Thanks for your help.

Ok, I setup mysql 4.1 and php 4.3.9 on windows xp. mysql driver doesn't work, and mysqli driver isn't installed into php.

It sounds like php binary installs don't have the mysqli driver installed and therefore, you're out of luck.

Do you have any other php apps working?

I personally would roll back to a 4.0.* release of mysql and all should be well.

Actually, this was my first experience with MySql and PHP. I'll go get 4.0 and try again. Sorry about the problems. Thanks again for the help!

It's more than ok. It's good to know what hangups exist and hopefully it helps other users as well.

Would be a lot worse if you just gave up and did pursue it, that's for sure.

Thanks!

It has to do with the new password hashing in MySQL 4.1+ (I had the same problem with Mambo on Windows XP).

http://dev.mysql.com/doc/mysql/en/Password_hashing.html

That's fix ya!

Bman

Here's the command to run in the above doc:

set password for 'cms_user'@'%' = old_password('cms_pass');


That'll fix step 3 for ya' !


Bman

Yeah, that's why we're doing the md5 sum on the php side now. Especially now that we support postgresql.

im having the exact same problem and i am a PHP / MYSQL ubernoob(i hadnt heard of them before)... im a summer student and was asked to find a nice CMS for updating a webpage. I think im a little in over my head, but ill give this a go anyways.

I get the error:   "Client does not support authentication protocol requested by server; consider upgrading MySQL client
Connection failed"

I tried to get MySQL 4.0 but i was confused on setting it up because it apparently doesnt have a nice friendly GUI. If you could tell me what i can do and where to do it I would greatly appreciate it.

Thanks

In the MySQL administration, hiding somewhere is an option for Old Passwords.  I don't have a windows box handy, so I can't look for the exact tab that it's on, but it's definatly there.  Turn that on, and then retype the password for the user.

Can anyone else provide a n00b friendly way of explaing that (or at least have a windows machine with 4.1 on it?