Unable to open menus of different extensions on Plesk for Linux server: unable to open database file

Symptoms

• On a Plesk for Linux server, opening menus of different extensions fails:

PLESK_ERROR: 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

1. Connect to the server via SSH

2. 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