Unable to delete "default certificate"

[Olga_Mataev]

Hi,

My default certificate expired recently. I created a new certificate "default certificate 2".

I used this certificate for "Secure the Panel"
I went to "Tools and Settings" -> "IP addresses" and made this certificate the default for all the IPs.
On the page "Tools and Settings" -> "SSL certificates", it says Used: 0 next to "default certificate".
But when I try to delete it, it tells me: "Error: Unable to remove certificates: one or several certificates are assigned to the IP addresses/domains."

Could you please tell me what I missed? Is there anywhere I can check where this certificate is still used?

 

[IgorG]

This looks like a known problem. Have you checked KB - http://kb.odin.com/en/119514?

 

[Olga_Mataev]

I did see that article in the KB.

It says:
In order to remove the certificate, it should be detached from the domain first:

Since this is the default server certificate, which domain does it mean? Can I get a list of domains using the certificate from the database?

 

[Olga_Mataev]

I figured it out!

I went into the psa database in MySQL.

select id, name from certificates;

This told me that "default certificate" has id 2.
Then I checked the following:

select dom_id from hosting where certificate_id=2;
Empty Set

select certificate_id from subdomains where certificate_id=2;
Empty Set

select ssl_certificate_id from IP_Addresses where ssl_certificate_id=2;
One result! Bingo! It looks like I missed one of the IPs before (there are 19 on the server, so it's very possible).

I went back to the control panel, changed the default certificate for this IP and tried to delete the SSL certificate again. It worked!