mysql 4.1.15 stopped working :/

[EvolutionCrazy]

php 4.3.2 redhat (updated 16/11/2005)
mysql 4.1.15 ART (updated 17/11/2005)

everything runs fin till some hours ago:
now every php script that try to access to mysql get this error:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in

instead plesk is working ok...

i suppose the problem is in the user table...

in fact in mysqld.log.1

i've found these errors (the time is exactly the same when the problem started):

051120 6:08:21 [Warning] Found invalid password for user: '***'; Ignoring user
051120 6:08:21 [Warning] Found invalid password for user: '***'; Ignoring user
051120 6:08:21 [Warning] Found invalid password for user: '***'; Ignoring user
051120 6:22:57 [Warning] Found invalid password for user: '***'; Ignoring user
051120 6:22:57 [Warning] Found invalid password for user: '***'; Ignoring user
051120 6:22:57 [Warning] Found invalid password for user: '***'; Ignoring user
051120 6:27:11 [Warning] Found invalid password for user: '***'; Ignoring user
051120 6:27:29 [Warning] Found invalid password for user: '***'; Ignoring user
051120 6:31:19 [Warning] Found invalid password for user: '***'; Ignoring user
051120 6:40:40 [Warning] Found invalid password for user: '***'; Ignoring user
051120 6:52:45 [Warning] Found invalid password for user: '***'; Ignoring user
051120 6:53:06 [Warning] Found invalid password for user: '***'; Ignoring user
051120 6:53:23 [Warning] Found invalid password for user: '***'; Ignoring user
051120 6:53:44 [Warning] Found invalid password for user: '***'; Ignoring user

all the users are "duplicated" except the user "admin" (the one with run with plesk)...

tonight (4am) i've run the weekly psadump... could the problem be caused by it?

already tried old-password and mysql-fix-privileges without any success...

plesk is running ok (the user admin doesn't appear to the errors above..)

[EvolutionCrazy]

ok...

i've fixed it..

dunno why... but tonight all the password were updated to the new password algorithm... :/

i've solved deleting all the database users and recreating them from plesk...

previously in my.cnf i didn't have

old-password

but it was working correctly :/

now i've added it...

i hope this problem will never happen again..

[darkgaro]

Thats funny the same thing just happened to me , One minute it was workign fine and then another I am getting.

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

Only thing I ran was the site backup.

[EvolutionCrazy]

Only thing I ran was the site backup.

:/

me too...

the last thing i've done was a complete backup with psadump...

uhm...

now i've added old-password in my.cnf...

let's see if the first time i'll do a backup (tomorrow night) it will mess up mysql again

[scott]

I think this is application related, I ran into this same problem while I was working on OSSIM. All the other apps worked with it fine, but one of them (phpgacl) wouldnt work unless I modified the DB to recreate that users password with the old_password() directive. I suspect that this might be resolved by using the mysqli architecture in php. The down side to doing that is that it will break php's compatibility with mysql3.

[EvolutionCrazy]

dunno if it was application related...

but i've noticed this when it stopped working:

Code: Select all

mysql> ;select * from useruser,password from user;
+------------------+-------------------------------------------+
| user             | password                                  |
+------------------+-------------------------------------------+
| admin            | 10ca5e690axxxxxx                          |
| horde            | 4b4536655bxxxxxx                          |
| hwtnet_nuke      | *65B4FBB2CE14FDF34C10744CC4D46176F6xxxxxx |
| hwtnet_phpstats  | *65B4FBB2CE14FDF34C10744CC4D46176F6xxxxxx |
| hwtnet_phpadsnew | *65B4FBB2CE14FDF34C10744CC4D46176F6xxxxxx |
| ips_ipb          | *D90FA141F031951A7B1FCAB5A0EEE04067xxxxxx |
| pma_RVofMG6SPUW7 | 7caad62047xxxxxx                          |
| horde            |                                           |
| berebene_sql     | *18ED90460331B8E9FC796D9FF923A720D3xxxxxx |
| customairguns    | *8DCD334E74566275A70D3379E96B11F538xxxxxx |
| daxady_gallery2  | *D4234FA745742461C7F689222EE521C351xxxxxx |

so i've deleted all the users from plesk interface, recreated them... and looked at mysql user table... and seen the all the passwords were changed to the "shorter" form...
at that point all my php appz restarted working...

however in my "my.cnf" there wasn't "old-password" command...
i suppose that during the psadump something weird happened and all the password were regenerated in the new format...

now i've "old-password" in my.cnf... and yesterday the psadump worked properly and all the php appz today are still working