Other domains SSL certificates are accessible from another subscription

Created:

2016-12-18 06:50:28 UTC

Modified:

2017-08-08 13:28:30 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Other domains SSL certificates are accessible from another subscription

Applicable to:

  • Plesk for Linux

Symptoms

Domain have SSL certificates belonging to another subscription domains listed under Websites & Domains -> SSL Certificates

Cause

Database inconsistency.

Resolution

  1. Use the SQL query below to find a domain that has invalid repository id:

    mysql> select d.name as dom, c.name as cert, c.id as cert_id, r.rep_id from certificates c, domains d, Repository r where d.cert_rep_id = r.rep_id and r.component_id=c.id;

    +-------------------+---------------+---------+--------+
    | dom | cert | cert_id | rep_id |
    +-------------------+---------------+---------+--------+
    | example1.com | Certificate 0 | 15 | 2 |
    | example2.com | Certificate 1 | 16 | 3 |
    | example3.com | Certificate 1 | 16 | 3 |
    +-------------------+---------------+---------+--------+
  2. Reset repository id for affected domains:

    mysql> begin;
    mysql> update domains set cert_rep_id=0 where name='example3.com';
    mysql> commit;
Have more questions? Submit a request
Please sign in to leave a comment.