Symptoms
-
On a Plesk for Linux server with MariadDB 10.11, creating a backup in Plesk fails:
Unable to back up applications packages.
Error: ODBC error #28000: [ma-3.1.20]Access denied for user 'apsc'@'127.0.0.1' (using password: YES)
-
Using the utility
plesk repair dbdoes not help. -
No corruption of the Plesk database
apscis found using manual methods. -
Attempt to access domain in Plesk may result into:
TypeError: Cannot read properties of null (reading 'id')
Cause
Plesk bug PPPM-14535, which has been fixed with the release of Plesk Obsidian 18.0.64.
Resolution
Update Plesk to the latest version. If the update can't be installed for some reason, apply the workaround above:
Workaround
-
Connect to the Plesk server using SSH.
-
Open the MariaDB configuration file with an editor:
-
On RHEL/CentOS/AlmaLinux/Rocky Linux/CloudLinux:
/etc/my.cnf -
On Ubuntu and Debian:
/etc/mysql/my.cnfor/etc/mysql/mariadb.conf.d/50-server.cnf
-
-
Remove or comment out (by preceding the line with an
#) the parameterskip-name-resolveorskip_name_resolveand save the file. -
Restart MariaDB:
# service mariadb restart