- Plesk Obsidian for Linux
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.logwith Plesk debug mode enabled:
CONFIG_TEXT: ERR [panel] SQLSTATE[HY000]  Access denied for user 'admin'@'localhost' (using password: YES):
The value in the column
admin_passwordof the table
DatabaseServersfrom the Plesk database doesn't contain a valid value (8 asterisks):
Note: If the value of the
admin_passwordis valid, the following command will return
# plesk db -Ne "select COUNT(admin_password) from DatabaseServers where id = 1 and admin_password = '********' "
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:
Connect to the server via SSH
Back up the Plesk database:
# plesk db dump psa > psa.backup.sql
Configure the value of the
admin_passwordfor the local MySQL server with 8 asterisks:
# plesk db "update DatabaseServers set admin_password='********' where id = 1"