Symptoms
- On a Plesk for Linux server, opening menus of different extensions fails:
500 Zend_Db_Adapter_Exception
SQLSTATE[HY000] [14] unable to open database file (Abstract.php:144)
Cause
Incorrect ownership for extensions' directories under /usr/local/psa/var/modules/ that differs from psaadm:psaadm:
# ls -al /usr/local/psa/var/modules/
total 100
drwxr-xr-x 25 psaadm root 4096 Nov 1 18:21 .
drwxr-xr-x 15 psaadm psaadm 4096 Dec 15 13:31 ..
drwxr-xr-x 4 root psaadm 4096 Aug 4 02:44 advisor
...
drwxr-xr-x 2 root psaadm 4096 Aug 4 02:44 domain-connect
drwxr-xr-x 2 root psaadm 4096 Aug 4 02:44 galileo
...
drwxr-xr-x 5 root psaadm 4096 Dec 5 17:23 letsencrypt
drwxr-xr-x 2 root psaadm 4096 Aug 4 02:44 log-browser
...
drwxr-xr-x 3 root psaadm 4096 Aug 4 02:44 nodejs
drwxr-xr-x 2 root psaadm 4096 Aug 4 02:44 notifier
...
drwxr-xr-x 2 root psaadm 4096 Aug 4 02:44 platform360
drwxr-xr-x 2 root psaadm 4096 Aug 4 02:44 repair-kit
drwxr-xr-x 2 root psaadm 4096 Aug 4 02:44 rest-api
...
drwxr-xr-x 3 root psaadm 4096 Aug 4 02:44 ssh-terminal
drwxr-xr-x 5 root psaadm 4096 Dec 6 17:23 sslit
drwxr-xr-x 2 root psaadm 4096 Aug 4 02:44 symantec
Resolution
-
Connect to the server via SSH
-
Set the correct permissions for the directory of each affected extension. For example, Let's Encrypt:
# chown -R psaadm:psaadm /usr/local/psa/var/modules/letsencrypt