Symptoms
- Could not issue an SSL/TLS certificate for the domain with subdomain or domain aliases:
PLESK_ERROR: Domain alias not found by id=XXX
- Domain alias with mentioned id does not exist in domain_aliases table.
Cause
Product issue:
-
#EXTSSLIT-677 "Issue of an SSL/TLS certificate no longer fails with the “Domain alias not found by id=…” error if the corresponding certificate order had had an associated domain alias that was then deleted while the order was pending."
Fixed in:- SSL It! 1.3.0 10 April 2020
Resolution
Workaround
If update is not possible for some reason you may try the following
Until a fix becomes available, use the following workaround:
1. Connect to the server via SSH;
2. Find the guid from affected domain name (e.g example.com)
# plesk db "select guid from domains where name='beechwoodguesthouse.com';"
+--------------------------------------+
| guid |
+--------------------------------------+
| 47567c0c-8c73-4f5c-ac5c-603cb22fc55c |
+--------------------------------------+
3. Access sslit sqllite database:
# sqlite3 /usr/local/psa/var/modules/sslit/sslit.sqlite3
4. Update OrderAttribute table with value 'a:0:{}' which means no aliases to secure:
MYSQL_LIN: update OrderAttribute set value='a:0:{}' where orderId in(select id from Orders where domainGuid='47567c0c-8c73-4f5c-ac5c-603cb22fc55c' and status=0) and name='domainAliasesIdsToSign';
5. Cancel and remove all certificates request for the affected domain:
MYSQL_LIN: delete from OrderAttribute where orderId in(select id from Orders where domainGuid='47567c0c-8c73-4f5c-ac5c-603cb22fc55c' and status=0);
MYSQL_LIN: delete from Orders where domainGuid='47567c0c-8c73-4f5c-ac5c-603cb22fc55c' and status=0
6. Log into Plesk and reissue the certificate on Domains > example.com> SSL/TLS Certificate;
Comments
0 comments
Please sign in to leave a comment.