Plesk updates fails: FATAL ERROR: Upgrade failed

Created:

2016-11-16 13:16:55 UTC

Modified:

2017-04-24 11:03:23 UTC

2

Was this article helpful?


Have more questions?

Submit a request

Plesk updates fails: FATAL ERROR: Upgrade failed

Applicable to:

  • Plesk for Windows
  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows

Symptoms

Plesk update fails with errors like:

Execute C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\bin\\mysql_upgrade.exe --force --host=127.0.0.1 --port=8306 --user=psa_root --password=************ failed[1]: Looking for 'mysql.exe' as: C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\bin\\mysql.exe
Looking for 'mysqlcheck.exe' as: C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\bin\\mysqlcheck.exe
FATAL ERROR: Upgrade failed

or

MSI: Error! Critical action 'Upgrade data of MySQL Server...' failed:
Command "C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin\\mysqlmng_adm.exe" --up
grade-server-data --initial-ver=5.5 --target-ver=5.5.41 failed with code 1.
Output:
Stop service...
Removing InnoDB log files...
Start service...
Upgrading all databases...
Can't decrypt data
Failed to install 'C:\\ParallelsInstaller\\parallels\\PANEL-WIN_12.0.18\\dist-msi-Mi
crosoft-2003-i386\\mysql-admin.msi': Fatal error during installation. (Error code
1603)

ERROR: The installation of the package 'mysql' failed with code 1603. (upgrade:
upgrading Parallels Panel SQL server...)

Plesk is not accessible:

Unable to read Control Panel configuration file

Cause

Incorrect password for psa_root user in MySQL.

Resolution

  1. Create a dump of psa database using the following article KB #213904125

  2. Disable "Enchanced security mode":

    "%plesk_bin%\\dbclient" --direct-sql --sql="update psa.misc set val='false' where param='secure_passwords'"
  3. Generate new password

    "%plesk_bin%\\mysqlmng_adm.exe" --inject-root
  4. Run the upgrade again.

    If steps above was not helped, proceed further:

    "%plesk_bin%\\mysqlmng_adm.exe" --change-password --new-password
  5. Start the update once again and get the newly generated password from the error message.

  6. Update the password for psa_root user in user table of mysql database with the password taken from Step 4 :

    "%plesk_bin%\\dbclient" --direct-sql --sql="UPDATE mysql.user SET Password = password('**************') where user = 'psa_root'"
  7. Enable "Enchanced security mode" via Plesk GUI.

Have more questions? Submit a request
Please sign in to leave a comment.