Urgent: Plesk Backup DB Problem. Need Help

[ThE-KinG]

Plesk backup gives that error.

An error occured during backup process:

DBI connect('host=localhost;database=psa;mysql_socket=/var/lib/mysql/mysql.sock','admin',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /usr/local/psa/lib/perl5/BU/DB.pm line 38

Unable to connect to mysql

System:
FreeBSD, mySQL 4.1.9
Plesk 7.5.3
Perl Lib 5.8.6

How can I fix this error? Thank you sooo much for your help.

 

[ThE-KinG]

Hey friends look here I need help

 

[mikk]

Have you recently updated the server mysql-client to 4.1.9?

if so have you updated the perl DBD items?


perl -MCPAN -e "force install DBD::mysql"

 

[hardweb]

You must add to my.cnf:

old-passwords

in the [mysqld] context and the application that tries to connect to the database will work.

 

[ThE-KinG]

Thank you friends for all replies.

Originally posted by mikk
Have you recently updated the server mysql-client to 4.1.9?

if so have you updated the perl DBD items?


perl -MCPAN -e "force install DBD::mysql"

I have done this. The result is:

CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
  Database was generated on Mon, 27 Jun 2005 16:58:29 GMT
DBD::mysql is up to date.

hardweb, I have tried to add old-passwords in my.cnf but the error is same and continue.

Many thanks and any other ideas?

 

[JROnline]

The problem seems to be coming from the location where the mysql.sock is located.

If you check the file:

/usr/local/psa/lib/perl5/BU/DB.pm

and search for the location of mysql.sock:

$socket_path='/tmp/mysql.sock'; # default path
return "$socket_path" if ( -e "$socket_path") ;
$socket_path='/var/lib/mysql/mysql.sock'; # default path
return "$socket_path" if ( -e "$socket_path") ;

If you comment out the first location, the backup works again.

 

[ThE-KinG]

Originally posted by JROnline
The problem seems to be coming from the location where the mysql.sock is located.

If you check the file:

/usr/local/psa/lib/perl5/BU/DB.pm

and search for the location of mysql.sock:

$socket_path='/tmp/mysql.sock'; # default path
return "$socket_path" if ( -e "$socket_path") ;
$socket_path='/var/lib/mysql/mysql.sock'; # default path
return "$socket_path" if ( -e "$socket_path") ;

If you comment out the first location, the backup works again.

Thanks I have done this but the error continue.

An error occured during backup process:

DBI connect('host=localhost;database=psa;mysql_socket=/var/lib/mysql/mysql.sock','admin',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /usr/local/psa/lib/perl5/BU/DB.pm line 38

Unable to connect to mysql

I have changed like this:

#$socket_path='/tmp/mysql.sock'; # default path
#return "$socket_path" if ( -e "$socket_path") ;
        $socket_path='/var/lib/mysql/mysql.sock';       # default path 
return "$socket_path" if ( -e "$socket_path") ;

 

[idle]

I got same problem. I tried to upgrade client but all attempts failed with different errors. When I tried to install from ports(mysql41-client,mysql50-client), it say "make: cannot open Makefile".
Any ideas?

FreeBSD5.3
mysql Distrib 4.0.16
Plesk 7.5.4

 

[Stucco]

Same error here any answer yet?

Attempt to connect to MySQL server ... DBI connect('host=localhost;database=psa;mysql_socket=/var/lib/mysql/mysql.sock','admin',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /usr/local/psa/lib/perl5/BU/DB.pm line 38

failed

Notice it is finding the correct mysql.sock location in the error, also I have old_passwords=1.

 

[jeremycohoe]

Old mysql version error

Hello,

I was having this problem and have figured out a solution. I hope it works for anyone else having this issue.
I had to go into Server > Change password and change the 'admin' user's password. I changed it to the same password it was before, but in doing so, I guess that fixed the error I was getting, which was:

Attempt to reconnect to MySQL server ... DBI connect('host=localhost;database=psa;mysql_socket=/tmp/mysql.sock','admin',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /usr/local/psa/lib/perl5/BU/DB.pm line 38

Unable to connect to PSA database.

Good luck,