Create Web hosting fails: Unable to get SSL certificate by ID

Symptoms

Attempt to create domain/subscription or add web hosting using 203.0.113.2 IP address fails with an error:

PLESK_ERROR: Unable to get SSL certificate by ID: 0

Cause

Database inconsistency.

Resolution

Note: This article may require additional administrative knowledge to apply. If any help required, contact server’s administrator or hosting support.

1. Connect to the server using SSH / RDP.

2. Create Plesk database backup:

   # MYSQL_PWD=cat /etc/psa/.psa.shadow mysqldump -u admin psa > psadate +%F_%H.%M.sql

3. Find SSL certificate id from IP Addresses

   # plesk db "select id,ip_address,ssl_certificate_id from IP_Addresses where ip_address='203.0.113.2'"
   +----+-------------+--------------------+
   | id | ip_address  | ssl_certificate_id |
   +----+-------------+--------------------+
   | 3  | 203.0.113.2 | 0                  |
   +----+-------------+--------------------+

4. Get available certificates list:

   # plesk db "select id,cert_file,ca_file,name from certificates"
   +----+-------------+----------------------------------+
   | id | cert_file   | name                             |
   +----+-------------+----------------------------------+
   | 1  | certDRhvzhe | default certificate              |
   | 2  |             |Backup sign certificate           |
   +----+-------------+----------------------------------+

5. Assign Default Certificate (id=1 in this case) to the IP address:

   # plesk db "update psa.IP_Addresses set ssl_certificate_id=1 where ip_address='203.0.113.2'"