1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice

Urgent: Plesk Backup DB Problem. Need Help

Discussion in 'Plesk for Linux - 8.x and Older' started by ThE-KinG, Jul 31, 2005.

  1. ThE-KinG

    ThE-KinG Guest

    0
     
    Plesk backup gives that error.

    Code:
    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.
     
  2. ThE-KinG

    ThE-KinG Guest

    0
     
    Hey friends look here I need help :(
     
  3. mikk

    mikk Basic Pleskian

    23
    73%
    Joined:
    Jan 29, 2005
    Messages:
    83
    Likes Received:
    0
    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"
     
  4. hardweb

    hardweb Guest

    0
     
    You must add to my.cnf:

    old-passwords

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

    ThE-KinG Guest

    0
     
    Thank you friends for all replies.

    I have done this. The result is:

    Code:
    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?
     
  6. JROnline

    JROnline Guest

    0
     
    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.
     
  7. ThE-KinG

    ThE-KinG Guest

    0
     
    Thanks I have done this but the error continue.

    Code:
    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:

    Code:
    #$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") ;
    
     
  8. idle

    idle Guest

    0
     
    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
     
  9. Stucco

    Stucco Guest

    0
     
    Same error here any answer yet?

    Code:
    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.
     
  10. jeremycohoe

    jeremycohoe Guest

    0
     
    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,
     
Loading...