Applicable to:
- Plesk Multi Server
- Plesk for Linux
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:
-
Connect to the server using SSH.
-
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
-
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 |
+-----+--------------------------------------+
-
-
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 |
+-----+--------------------------------------+
-
-
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
-
-
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.
-
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
-
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.
Comments
0 comments
Please sign in to leave a comment.