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
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Plesk 8.1.0 and MySQL 4.1

Discussion in 'Plesk for Linux - 8.x and Older' started by w0ei, Dec 3, 2006.

  1. w0ei

    w0ei New Pleskian

    22
    23%
    Joined:
    Dec 3, 2006
    Messages:
    8
    Likes Received:
    0
    Hi,

    i almost finished upgrading from 8.0.1 to 8.1.0 but there is one tiny very annoying thing not working. And that is updating the old Plesk database. When installing the 8.1.0 rpm I get this error message:
    The log file is:
    I tried EVERYTHING:
    - multiple passwords for admin account (setup, the plesk password, empty password, all these things but then with OLD_PASSWORD, etc.)
    - recreate /etc/psa/.psa.shadow
    but nothing seems to be working..
    - skip-grant-tables in /etc/my.cnf

    If only I could see WHICH password the setup is using to connect to MySQL..

    MySQL log says:
    Any ideas?
     
  2. studioxyz

    studioxyz Guest

    0
     
    Resolved?

    Did you get this issue resolved? I am dealing with exactly the same thing. I just ran updater, and now the admin is down. MySQL works, but the psa install always chokes when it gets to the part it tests the MySQL server.

    Thanks for the help.
     
  3. w0ei

    w0ei New Pleskian

    22
    23%
    Joined:
    Dec 3, 2006
    Messages:
    8
    Likes Received:
    0
    Re: Resolved?

    Actually no. It was on a VPS server and after consulting the issue with the hoster, we decided to reinstall. But that also failed, there seemed to be an error in Virtuozzo.. My hoster needed a full week to fix the error.. So I hope you don't have exactly the same problem.. :p
     
  4. misleem

    misleem Guest

    0
     
    Hi;
    try to do the following to retrieve the 'admin' password :

    cat /etc/psa/.psa.shadow

    i had the same problem !!
     
  5. studioxyz

    studioxyz Guest

    0
     
    I fixed it!

    /etc/psa/.psa.shadow contains the correct password, however the problem did involve an authentication error when the installer script attempted to connect to mysql.

    For convenience I use /root/.my.cnf to save the password for "root". This way I don't have to type my password when using mysql from the command line. The psa installer performs the mysql installation using the user "admin" and sets the environment variable MYSQL_PWD for connecting to the mysql server. Since MYSQL_PWD is less secure than .my.cnf, mysql favors the password in .my.cnf. But I have the password for "root" set to something different than the password for "admin". Obviously this led to authentication failures when the psa installer tried to connect to mysql.

    If the passwords for admin and root were the same, or /root/my.cnf didn't exist, the problem would not have occurred. At least it's fixed now.

    Thanks for the help!
     
Loading...