Articles in this section

See more

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

Avatar
Alex Davydov
Updated
Follow
kb: bug Ideal ABT: Group B Plesk Obsidian for Linux

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"

Comments

6 comments

Sort by Date Votes
  • Avatar
    Fabian Marsiglione

    Hello

    I not understand something here :

    update DatabaseServers set admin_password='********' where id = 1;
    Query OK, 1 row affected (0.10 sec)
    Rows matched: 1 Changed: 1 Warnings: 0

    What i must to put in "*****"  (any password i want?)

    Thanks
    Fabian

    1
    Comment actions Permalink
  • Avatar
    Francisco Roman Garcia Rodriguez

    Hi Fabian Marsiglione,

    There's no mistake in the command, and the "password" that has to be set is 8 asterisks

    0
    Comment actions Permalink
  • Avatar
    Yevgeny Mozgov 🇬🇷🍌🍄🗳️ (Edited )

    So what is the fix here?

    We have latest version but problems remains

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello Yevgeny Mozgov 🇬🇷🍌🍄🗳️

    What's the output on your server of this command?

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

    Does the workaround from this article work for you?

    0
    Comment actions Permalink
  • Avatar
    Сергей Засухин

    This error is still relevant in the latest version of plesk when using mariadb 10.3! how to solve?

    0
    Comment actions Permalink
  • Avatar
    Anton Maslov

    Сергей Засухин Hi! Workaround from article should help:

    1. Back up the Plesk database:

      # plesk db dump psa > psa.backup.sql

    2. 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"

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles