Unable to login to Plesk Control panel: get_admin_password() failed: Undefined index: PLESK_DEBUG_SQL

Refers to:

  • Plesk 10.4 for Linux
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux

Created:

2016-11-16 12:56:54 UTC

Modified:

2016-12-21 19:36:33 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to login to Plesk Control panel: get_admin_password() failed: Undefined index: PLESK_DEBUG_SQL

Symptoms

Login to Plesk fails with error:

ERROR: PleskFatalException
Unable to connect to database: get_admin_password() failed: file_get_contents() failed: Undefined index: PLESK_DEBUG_SQL

0: common_func.php3:153
psaerror(string 'Unable to connect to database: get_admin_password() failed: file_get_contents() failed: Undefined index: PLESK_DEBUG_SQL')
1: auth.php3:116

Cause

The ownership of the file /etc/psa/.psa.shadow is incorrect.

Resolution

  1. Check the Permission of the file:
    # ls -al /etc/psa/.psa.shadow
    -rw------- 1 root root 63 Oct 12 00:33 /etc/psa/.psa.shadow

Note : The ownership root:root is incorrect. The proper permissions should be given to psaadm user as below:

    # ls -la /etc/psa/.psa.shadow
-rw------- 1 psaadm psaadm 63 Feb 5 09:38 /etc/psa/.psa.shadow
  1. Change ownership to psaadm with command below:

    # chown psaadm:psaadm /etc/psa/.psa.shadow
  2. Restart the psa service

    /etc/init.d/psa stop
    /etc/init.d/psa start
  3. Also check if permissions on wrapper binary are correct:

    # chmod 4110 /usr/local/psa/admin/sbin/wrapper
    # chown root:psaadm /usr/local/psa/admin/sbin/wrapper
Have more questions? Submit a request
Please sign in to leave a comment.