Articles in this section

MySQL Process List in Plesk does not work: Request failed with status code 500

kb: bug Plesk Obsidian for Linux ABT: Group B Ideal

Applicable to:

  • Plesk Obsidian for Linux

Symptoms

  • On a Plesk Obsidian for Linux server, the following error is shown in the menu Tools & Settings > Assistance and Troubleshooting > MySQL Process list (Beta):

    CONFIG_TEXT: Request failed with status code 500

    Click Install

  • The following error is found in the file /var/log/plesk/panel.log with Plesk debug mode enabled:

    CONFIG_TEXT: ERR [panel] SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES):

  • The value in the column admin_password of the table DatabaseServers from the Plesk database doesn't contain a valid value (8 asterisks):

    Note: If the value of the admin_password is valid, the following command will return 1

    # plesk db -Ne "select COUNT(admin_password) from DatabaseServers where id = 1 and admin_password = '********' "
    0

Cause

Issue is caused by bug with ID PPPM-11086, which is planned to be fixed in product future updates. 

 

Resolution

Apply the following workaround if the server was affected by this bug:

Workaround
  1. Connect to the server via SSH

  2. Back up the Plesk database:

    # plesk db dump psa > psa.backup.sql

  3. Configure the value of the  admin_password for the local MySQL server with 8 asterisks:

    # plesk db "update DatabaseServers set admin_password='********' where id = 1"

Was this article helpful?

Comments

1 comment
Date Votes

Please sign in to leave a comment.