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

Dmitry Bystrov

1 year ago

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

0 Shares