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

1. Connect to the server using SSH.

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


3. Get available certificates list:

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

4. Create psa database backup and assign Default Certificate (id=1 in this case) to the IP address (id=3 in this case):

# plesk db "update psa.IP_Addresses set ssl_certificate_id=1 where id=3"