Question:Plesk is not accessible: Unable to find service node for web service on domain with id=xxx
Symptoms
- When trying to log into Plesk or when trying to open a domain in dashboard, Plesk shows the following error:
Internal error: Unable to find service node for web service on domain with id=111
- The command "plesk repair db" reports the following error message:
#plesk repair db -n
Inconsistency in the table 'domains' for the column id: No rows in the table 'DomainServices' with type = 'web', dom_id = 111 ........ [ERROR]
Cause
Inconsistency in the Plesk database.
Resolution
Note: Steps below are the same for both Linux and Windows.
1.Connect to the Plesk server via SSH/RDP.
2.Create a dump of the Plesk database.
3.Connect to the Plesk database with the command (On Windows Server use a command prompt):
#plesk db
4.Find the domain's "ip_address_id" using dom_id value from the error message (for example dom_id = 111):
mysql> select dom_id,param,val from dom_param where param='ip_addr_id' and dom_id=111;
+--------+------------+------+
| dom_id | param | val |
+--------+------------+------+
| 111 | ip_addr_id | 1 |
+--------+------------+------+
5.Find the "id" with the type "mail" in DomainServices:
mysql> select * from DomainServices where dom_id=111;
+------+--------+------+--------+---------------+----------------+
| id | dom_id | type | status | parameters_id | ipCollectionId |
+------+--------+------+--------+---------------+----------------+
| 25 | 111 | mail | 0 | 639 | 25 |
+------+--------+------+--------+---------------+----------------+6.Find "id" of the IP address assigned to the domain:
mysql> select * from IpAddressesCollections where ipCollectionId=25;
+----------------+-------------+
| ipCollectionId | ipAddressId |
+----------------+-------------+
| 25 | 1 |
+----------------+-------------+7.Find the next free value for the "id" field in the DomainServices table:
mysql> select max(id)+1 from DomainServices;
-------+
| max(id)+1 |
+----------
+-----+
| 1447 |
+-----------+8.Create the missing records using id from step 7 (in this example id=1447) and ipCollectionId as 1 + the value from step 6 (in this example ipCollectionId=26 [25+1]):
- In the DomainServices table:
mysql> insert into DomainServices (id, dom_id, type, status, parameters_id, ipCollectionId) values ('1447', '111', 'web', '0', '0', '26');- In the IpAddressesCollections table:
mysql> insert into IpAddressesCollections (ipCollectionId, ipAddressId) values ('26', '1');
- In the IpCollections table:
mysql> insert into IpCollections (id) values ('26');