[BUG] Plesk Multi Server task error: Unable to find certificate Domain example.com

Symptoms

• In the Tasks section the following errors may be seen:

  PLESK_INFO: Webspace does not exist

  or

  PLESK_INFO: Unable to find certificate Domain example.com

• Affected additional domains are not clickable in Domains section. These domains are edited from the Plesk user interface in the Subscriptions that they belong to only.

• A certificate is installed for the domain.

• The following error can be found in /usr/local/psa/admin/panel.log:

  CONFIG_TEXT: ERR [extension/plesk-multi-server] Task run failed with message 'Unable to find certificate Domain example.com'

• It is also possible that additional domains are missing on a Management Node, however, are present on a Service Node.

Cause

Corrupted mapping, that is caused by the Plesk bug #EXTPMS-1355 which will be fixed in one of the future Plesk updates.

Resolution

Restore mapping for these additional domains using the following way:

1. Connect to the server using SSH.

2. Make the backup of sqlite database:

   # cp /usr/local/psa/var/modules/plesk-multi-server/plesk-multi-server.sqlite3 /usr/local/psa/var/modules/plesk-multi-server/support-backup-<date>-plesk-multi-server.sqlite3

3. Find out id of the domain, of the subscriptions domain belongs to and guid of the Subscription on the Master Node:

   • Log in to psa database:

     # plesk db

   • Find out id of the domain, id of the subscription and guid:

     MYSQL_LIN: mysql> select if(webspace_id=0,id,webspace_id) as id, guid from domains where name="example.com";
     +-----+--------------------------------------+
     | id  | guid                                 |
     +-----+--------------------------------------+
     | 328 | c68171eb-6751-4004-83d4-7345a57fc494 |
     +-----+--------------------------------------+

4. Find out id and guid of this domain on the Service Node as well:

   • Log in to psa database on the Service Node:

     # plesk db

   • Find out id of the domain and guid:

     MYSQL_LIN: mysql> select if(webspace_id=0,id,webspace_id) as id, guid from domains where name="example.com";
     
     +-----+--------------------------------------+
     | id  | guid                                 |
     +-----+--------------------------------------+
     | 42  | d4f9d595-1add-471d-8b4f-fc7fcceb9d07 |
     +-----+--------------------------------------+ 

5. Using id from the 3rd step it is required to look for id of the subscription in the sqlite "subscriptions" table and id of the Service Node.

   • Log in to the sqlite database:

     # sqlite3 /usr/local/psa/var/modules/plesk-multi-server/plesk-multi-server.sqlite3

   • Find id of the subdcription:

     MYSQL_LIN: sqlite> .headers on
     sqlite> .mode line
     sqlite> select id, slaveNodeId from subscriptions where masterId=328;
     id = 26
     slaveNodeId = 2

6. When all required details are collected, mapping may be restored with the following command:

   MYSQL_LIN: sqlite> insert into sites (slaveNodeId, slaveId, slaveGuid, masterId, masterGuid, subscriptionId, name) values (2, 42, 'd4f9d595-1add-471d-8b4f-fc7fcceb9d07', 328, 'c68171eb-6751-4004-83d4-7345a57fc494', 26, "example.com");

   Where:

   slaveNodeId and subscriptionId - slaveNodeId and id of the subscription from "subscriptions" table (step 5);
   masterId and masterGuid - id and guid from the Master Node (step 3);
   slaveId and slaveGuid - id and guid from the Service Node (step 4);
   name - deomain's name.

   Note: Consider changing the values in the 7th step's command with the appropriate one, that suit values from the database.

7. Update the status of the previously Failed (status=4) task to Complete (status=3):

   # sqlite3 /usr/local/psa/var/modules/plesk-multi-server/plesk-multi-server.sqlite3
   update tasks set status=3 where id=110180;

   Note: id value can be found in the Tasks section

8. If the domain also had Webspace does not exist error, fix it with the same way it is described in the 1st step, but change ID to the latest failed task with the Webspace does not exist error instead.