Error in Webserver Configurations Troubleshooter: SSLCertificateFile: file does not exist or is empty

Symptoms

• The following error is seen in Tools & Settings > Webservers Configurations Troubleshooter:

  AH00526: Syntax error on line 50 of /etc/apache2/plesk.conf.d/vhosts/example.com.conf: SSLCertificateFile: file '/opt/psa/var/certificates/certXXXXXX' does not exist or is empty.

• The example.com domain is not present in Plesk
• Neither the /etc/apache2/plesk.conf.d/vhosts/example.com.conf nor /opt/psa/var/certificates/certXXXXXX file exist on the server:

  ls -la /etc/apache2/plesk.conf.d/vhosts/example.com.conf
  ls: cannot access '/etc/apache2/plesk.conf.d/vhosts/example.com.conf': No such file or directory
  # ls -la /opt/psa/var/certificates/certXXXXXX
  ls: cannot access '/opt/psa/var/certificates/certXXXXX': No such file or directory 

Cause

An orphaned record in Plesk database.

The domain in question was removed, but there is still a record in the Configurations table with this error message.

Resolution

Remove the orphaned record from the Plesk database via the following steps:

1. Connect to the server via SSH
2. Back up the Plesk database:

   # plesk db dump > backup.sql

3. Connect to the database:

   # plesk db

4. Identify the record with the "Error" status via the following query:

   SELECT * FROM Configurations WHERE status <> 'ok'G

   Otput example:

   *************************** 1. row ***************************
   id: 455
   name: server
   serviceNodeId: 1
   file:
   version: 15943938810.74156900
   objectType:
   objectId: NULL
   status: error
   active: false
   description: AH00526: Syntax error on line 50 of /etc/apache2/plesk.conf.d/vhosts/example.com.conf:
   SSLCertificateFile: file '/opt/psa/var/certificates/certXXXXXX' does not exist or is empty
   errorFile: NULL

   Note: The NULL value for objectId means that this error is not attached to any existing object in the database

5. Delete this record(s) (use record's id from the previous step):

   DELETE FROM Configurations WHERE id=455;