How to purge certs


#1

OS: ‪CentOS Linux 7.2.1511 (Core)‬
Plesk version: 12.5.30 Update #45 , last updated at Sept 1, 2016 04:01 PM

I had inconsistent results using several domains and subdomains so I decided to start fresh (one had a CSR, one didn’t. Then one had a CSR but nothing else. The company name also didn’t show up on the web page).

I’m unable to remove certs – or at least the final default cert. I tried to follow the instructions here: https://kb.plesk.com/en/119514 But it might as well be gibberish for all the good it did me, neither set of I or II instructions worked, and for that matter they are as clear as mud.

Uninstalling the extension didn’t remove the cert from plesk either. I even turned off SSL and still couldn’t remove it. Any ideas?

Here’s live data. Should I simply delete all the rows from each of the below tables, perhaps with the exception of the ip address table and then reinstall the extension? Or are there files I need to remove through the command line in addition to cleaning out the DataBase? Thank you in advance.

MariaDB [psa]> select id, name from certificates;
+—-+—————————————–+
| id | name |
+—-+—————————————–+
| 1 | creativemls.com self-signed certificate |
| 2 | |
| 6 | Lets Encrypt creativemls.com |
| 7 | Lets Encrypt wptraining.creativemls.com |
| 9 | dummy |
+—-+—————————————–+
5 rows in set (0.00 sec)

MariaDB [psa]> select d.id, d.name from domains d inner join hosting h on h.dom_id = d.id;
+—-+—————————-+
| id | name |
+—-+—————————-+
| 1 | creativemls.com |
| 2 | wptraining.creativemls.com |
+—-+—————————-+
2 rows in set (0.00 sec)

MariaDB [psa]> select d.id, d.name from domains d
-> ;
+—-+—————————-+
| id | name |
+—-+—————————-+
| 1 | creativemls.com |
| 2 | wptraining.creativemls.com |
+—-+—————————-+
2 rows in set (0.00 sec)

MariaDB [psa]> select h.dom_id, h.ssl, h.certificate_id, same_ssl from hosting h;
+——–+——-+—————-+———-+
| dom_id | ssl | certificate_id | same_ssl |
+——–+——-+—————-+———-+
| 1 | false | 6 | true |
| 2 | true | 7 | true |
+——–+——-+—————-+———-+
2 rows in set (0.00 sec)

MariaDB [psa]> select id, ssl_certificate_id, default_domain_id from IP_Addresses i;
+—-+——————–+——————-+
| id | ssl_certificate_id | default_domain_id |
+—-+——————–+——————-+
| 1 | 1 | 0 |
| 2 | 1 | 1 |
+—-+——————–+——————-+
2 rows in set (0.00 sec)


#2

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.