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

Updated March 31, 2023 10:38

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

Applicable to:

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

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

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

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

Workaround

Connect to the server via SSH
Back up the Plesk database:

# plesk db dump psa > psa.backup.sql
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"