Step 3 of install process fails

sccole · Post by **sccole** » Tue Sep 28, 2004 6:51 pm

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

Ted · Post by **Ted** » Tue Sep 28, 2004 7:01 pm

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.

Ted · Post by **Ted** » Wed Sep 29, 2004 12:06 pm

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...

sccole · Post by **sccole** » Wed Sep 29, 2004 2:47 pm

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

Ted · Post by **Ted** » Wed Sep 29, 2004 3:08 pm

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.

sccole · Post by **sccole** » Wed Sep 29, 2004 5:34 pm

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

Ted · Post by **Ted** » Thu Sep 30, 2004 12:32 am

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.

sccole · Post by **sccole** » Thu Sep 30, 2004 2:22 pm

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!

Ted · Post by **Ted** » Thu Sep 30, 2004 2:27 pm

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!

Brondoman · Post by **Brondoman** » Mon Nov 22, 2004 4:05 pm

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

Brondoman · Post by **Brondoman** » Mon Nov 22, 2004 4:13 pm

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

Ted · Post by **Ted** » Mon Nov 22, 2004 5:18 pm

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

tylerf · Post by **tylerf** » Mon Jul 04, 2005 3:28 pm

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

Ted · Post by **Ted** » Mon Jul 04, 2005 3:58 pm

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?

CMS Made Simple Forums