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

Follow

Comments

7 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?

    0
    Comment actions Permalink
  • 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.

    0
    Comment actions Permalink
  • 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)

    0
    Comment actions Permalink
  • 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!

    0
    Comment actions Permalink
  • 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

    0
    Comment actions Permalink
  • Avatar
    Claudio

    Sascha, use backticks around the cat command:

    /opt/plesk/php/5.6/bin/php -d safe_mode=Off panel_preupgrade_checker.php `cat /etc/psa/.psa.shadow`

    Documentation should be updated.

    0
    Comment actions Permalink
  • Avatar
    Julian Bonpland Mignaquy

    @Claudio the documentation has been updated. Thanks for bringing that up to our attention!

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request