Applicable to:
- Plesk 12.0 for Windows
- Plesk 12.5 for Linux
- Plesk 12.5 for Windows
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.
-
# MYSQL_PWD=
cat /etc/psa/.psa.shadow
mysqldump -u admin psa > psadate +%F_%H.%M
.sql -
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 |
+----+-------------+--------------------+ -
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 |
+----+-------------+----------------------------------+ -
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'"
Comments
0 comments
Please sign in to leave a comment.