Symptoms
- Unable to open Domains > example.com page with error:
TypeError: Cannot read properties of null (reading 'id')
- Domain has APS application installed
- The following error can be found in
/var/log/plesk/panel.log:ERR [panel] ODBC error #28000: [ma-3.1.20]Plugin caching_sha2_password could not be loaded: /usr/lib/mariadb/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
# ERR [panel] ODBC error #28000: [unixODBC][ma-3.1.20]Access denied for user 'apsc'@'127.0.0.1' (using password: YES)
Cause
Product issue:
-
#PPPM-14574 "The domain card is now opened if the server MySQL/MariaDB configuration is modified and an APS application is installed."
Fixed in:- Plesk Obsidian 18.0.64 17 September 2024 (Linux)
Resolution
Please consider updating your server:
Workaround
Update the Plesk to 18.0.64 version.
If an update is not possible, refer to the workaround:
1. Connect to the server via SSH
2. Open the following configuration file with the editor:
- RHEL-based (CentOS, AlmaLinux, etc.):
/etc/my.cnf
- Debian-based (Ubuntu, Debian):
/etc/mysql/my.cnf
3. Comment out the lines containing:
#skip_name_resolve
#skip_networking
OR:
#skip-name-resolve
#skip-networking
4. Restart MariaDB:
# systemctl restart mariadb
with