Applicable to:
- Plesk for Linux
- Plesk for Windows
Symptoms
-
Plesk shows the following error after login:
PLESK_ERROR: Internal error: Domain Service Web not exists: domain=sub.example.com, id=41
Domain Service Web not exists: domain=sub.example.com, id=41
File DSWeb.php
Line 76
Type PleskFatalException -
The following errors may be shown in the
/var/log/plesk/panel.logfile:CONFIG_TEXT:[2015-11-23 22:23:48] ERR [panel] Failed to search for WordPress instances on subscription example.com: Domain with id=270 was not found
[2015-11-23 22:23:52] ERR [panel] Attempt to change status of non-configured mail service. [domain_id = 270]
[2015-11-23 22:23:52] ERR [panel] Unable to load object of type PhDomain with id=270: Turn off domain failed: Unable to find service node for web service on domain with id=270
[2015-11-23 22:23:52] ERR [panel] Some of the subscriptions selected were not suspended.<br>Unable to load object of type PhDomain with id=270: Turn off domain failed: Unable to find service node for web service on domain with id=270
[2015-11-23 22:23:59] ERR [panel] No data.
[2015-11-23 22:24:09] ERR [panel] Failed to search for WordPress instances on subscription example.com: Resource with UID 'bd314c87-865a-46e6-b694-342e71899445' not found.
Cause
The domain mentioned in the error messages has been deleted, but PSA database still contains an entry for this domain.
Plesk database was not properly upgraded. The ' psa.DomainServices ' table has no records of the "web" type.
Resolution
Note: This article may require additional administrative knowledge to apply. If any help required, contact server’s administrator or hosting support.
Warning: Please check that the domain physically exists before making changes. If it does, back up all the domain content from the corresponding directories /var/www/vhosts/<domain> and /var/qmail/mailnames/<domain> (in case of Linux) or from C:\Inetpub\vhosts and %plesk_dir\MailEnable\postoffices% (in case of Windows).
There are several possible scenarios:
-
Connect to the server via SSH (Plesk for Linux) or RDP (Plesk for Windows)
-
Remove the domain mentioned in the error from the PSA database and recreate it from scratch, for example:
MYSQL_LIN: mysql> DELETE FROM domains WHERE id='41';
Query OK, 1 row affected (0.04 sec)
-
Ensure that there are no orphaned records in the databases as follows:
-
create databases backups:
MYSQL_LIN: MYSQL_PWD=
cat /etc/psa/.psa.shadowmysqldump --skip-extended-insert --complete-insert -u admin psa > /root/psadate +%F_%H-%M.sqlMYSQL_LIN: MYSQL_PWD=
cat /etc/psa/.psa.shadowmysqldump --skip-extended-insert --complete-insert -u admin apsc > /root/apscdate +%F_%H-%M.sql# ls -lt /root/ | head -n3
total 31112
-rw-r--r-- 1 root root 224955 Nov 23 22:45 apsc2015-11-23_22-45.sql
-rw-r--r-- 1 root root 14023153 Nov 23 22:44 psa2015-11-23_22-44.sql -
Search for the values mentioned in the error messages, for example:
# grep 'bd314c87-865a-46e6-b694-342e71899445' /root/apsc2015-11-23_22-45.sql
grep 'bd314c87-865a-46e6-b694-342e71899445' /root/psa2015-11-23_22-44.sql
grep 'example' /root/apsc2015-11-23_22-45.sql# grep 'example' /root/psa2015-11-23_22-44.sql | grep -v -E 'log_components|exp_event'
INSERT INTOConfigurations(id,name,serviceNodeId,file,version,objectType,objectId,status,active,description,errorFile) VALUES (115,'nginxDomainWebmail',1,'/etc/nginx/plesk.conf.d/webmails/example.com_webmail.conf','14240541100.61180300','nginxDomain',28,'ok','true',NULL,'');
INSERT INTOConfigurations(id,name,serviceNodeId,file,version,objectType,objectId,status,active,description,errorFile) VALUES (117,'nginxDomainVhost',1,'/var/www/vhosts/system/example.com/conf/nginx.conf','14307435570.48796000','nginxDomain',28,'ok','true',NULL,'');
INSERT INTOConfigurations(id,name,serviceNodeId,file,version,objectType,objectId,status,active,description,errorFile) VALUES (896,'domainVhost',1,'/var/www/vhosts/system/example.com/conf/httpd.conf','14483138520.02185500','domain',270,'error','true','Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhost.php, error = Template_Exception: No data.\
-
-
Remove found orphaned records. For example:
MYSQL_LIN: MYSQL_PWD=
cat /etc/psa/.psa.shadowmysql -u admin psa -e "DELETE FROM Configurations WHERE id IN (115,117,896)"
MYSQL_PWD=cat /etc/psa/.psa.shadowmysql -u admin psa -e "DELETE FROM dns_zone WHERE id=272"
MYSQL_PWD=cat /etc/psa/.psa.shadowmysql -u admin psa -e "DELETE FROM hosting WHERE dom_id=270"
-
Connect to the server via SSH (Plesk for Linux) or RDP (Plesk for Windows)
-
Change
htypeof incorrectly removed domain to none:MYSQL_LIN: mysql> update domains set htype='none' where id=41;
-
Domain will become visible in Plesk interface with "No hosting".
-
Remove the domain through Plesk interface in Domains > select example.com > Click Remove
-
Connect to the server via SSH (Plesk for Linux) or RDP (Plesk for Windows)
-
Add the missing entries to the PSA database with MySQL query.
First, check that there is an entry in 'DomainServices' for this domain:
MYSQL_LIN: mysql> select * from DomainServices where dom_id = 41;
+-----+--------+------+--------+---------------+----------------+
| id | dom_id | type | status | parameters_id | ipCollectionId |
+-----+--------+------+--------+---------------+----------------+
| 322 | 41 | mail | 16 | 585 | 322 |
+-----+--------+------+--------+---------------+----------------+
1 row in set (0.00 sec)-
Add a similar "web"-type entry, and add related records to 'IpAddressesCollections'
MYSQL_LIN: mysql> begin;
mysql> select @dom_id := <missing_domain_id>;
mysql> select @ip := (select dr.val from dns_recs dr, domains d where d.id = @dom_id and dr.dns_zone_id = d.dns_zone_id and dr.type = 'A' and dr.host = concat(d.name,'.'));
mysql> select @ip_id := (select id from IP_Addresses where ip_address = @ip);
mysql> INSERT INTO IpCollections VALUES (NULL);
mysql> SELECT @ip_collection_id := LAST_INSERT_ID();
mysql> insert into IpAddressesCollections (ipCollectionId, ipAddressId) values (@ip_collection_id, @ip_id);
mysql> insert into DomainServices (dom_id, type, status, parameters_id, ipCollectionId) values (@dom_id, 'web' , 0, 0, @ip_collection_id);
mysql> commit;
-
Comments
0 comments
Please sign in to leave a comment.