Cannot access phpmyadmin: Error: Failed to store CSRF token in session! Probably sessions are not working properly

Symptoms

• Unable to access phpMyAdmin after Plesk update to 18.0.30 or higher version:

  Error: Failed to store CSRF token in session! Probably sessions are not working properly

• The file /usr/local/psa/phpMyAdmin/config.plesk.php does not exist on the server:

  # ll /usr/local/psa/phpMyAdmin/config.plesk.php
  ls: cannot access /usr/local/psa/phpMyAdmin/config.plesk.php: No such file or directory

• Information about failed phpMyAdmin can be found in /var/log/plesk/install/autoinstaller3.log:

  rpm scriptlet: ***** upgrade problem report *****
  rpm scriptlet: ERROR while trying to execute SQL query, the query was: RENAME TABLE phpmyadmin_PiPsuNrJhtKG.pma_bookmark TO phpmyadmin.pma__bookmark

Cause

The phpMyAdmin database was corrupted before the upgrade and phpMyAdmin was not correctly updated.

Resolution

Re-install phpMyadmin using steps from How to reinstall phpMyAdmin in Plesk

Note: In case the reinstallation does not recreate the phpMyAdmin database, it is because of the component timestamp on /var/lib/plesk/components-configuration-state.db. Make sure to remove it:

# sed -i '/^phpmyadmin/d' /var/lib/plesk/components-configuration-state.db