Plesk Pre-Upgrade Checker: A tool to identify business logic issues before upgrade or migration

Follow

Comments

5 comments

  • Avatar
    Sascha Schlüter

    This tool is a great option and exactly what i searched for, but i can´t run the pre-upgrade checker as i don´t know the 'plesk-db-admin-password'.
    Is there any syntax to use the encrypted password from /etc/psa/.psa.shadow in this command?

  • Avatar
    Ivan Postnikov

    Hello @Sascha,

    As I can see, you are using Plesk for Linux.

    For Linux, <plesk-db-admin-password> is the same as admin password to access Plesk UI.

  • Avatar
    Sascha Schlüter

    Thank you, Ivan, for your quick help.

    This was my first guess too, but unfortunately this does not work in my case. Using the same password, which does the job for user admin on servername.ext:8443  results in a message reading

    [FATAL_ERROR] [MYSQL ERROR] Given <password> is incorrect. Access denied for user 'admin'@'localhost' (using password: YES)

  • Avatar
    Sascha Schlüter

    Ah - i just found a workaround while reading other articles: the encrypted password from /etc/psa/.psa.shadow works when set in "" and with all (not only the first!) $-characters are escaped with a "\"(backslash)-chraracter!

    Thank you for providing help!

  • Avatar
    Alexandr Redikultsev

    Hi, @Sascha.

    Yes, you are right.

    Password for MySQL on plesk for Linux is hashed into /etc/psa/.psa.shadow, so the following command will get you into MySQL without the password:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin

Please sign in to leave a comment.

Have more questions? Submit a request