Unable to login Plesk: Unable to find service node for web service on domain

Created:

2016-12-18 06:44:21 UTC

Modified:

2017-08-08 13:28:07 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to login Plesk: Unable to find service node for web service on domain

Applicable to:

  • Plesk 12.5 for Windows

Symptoms

  1. Unable to log into Plesk under reseller account.

  2. Unable to access subscription example.com which belongs to reseller.

    The following error is shown:

    Internal error: Unable to find service node for web service on domain with id=218

    Message Unable to find service node for web service on domain with id=218
    File PhDomain.php
    Line 1038
    Type PleskDBException
  3. In psa.domains table hosting type of the domain example.com is set as virtual hosting:

    mysql> select id, name, htype from domains where id=218;
    +-----+-------------+---------+
    | id | name | htype |
    +-----+-------------+---------+
    | 218 | example.com | vrt_hst |
    +-----+-------------+---------+
  4. In psa.hosting or in psa.subscriptions tables records related to this domain are missing:

    mysql> select * from hosting where dom_id=218;
    Empty set (0.00 sec)
    mysql> select * from Subscriptions where object_id=218;
    Empty set (0.00 sec)
  5. Website does not exist in IIS and in %plesk_vhosts% directory.

Cause

Database inconsistency.

Resolution

  1. Set hosting type of the domain to none and back to vrt_hst :

    mysql> update domains set htype='none' where id=218;
    mysql> update domains set htype='vrt_hst' where id=218;

    Try to delete the domain once again

  2. If step #1 did not help, delete DNS records from Plesk database:

    mysql> delete from domains where id=218;
    mysql> delete from dns_zone where name='example.com';
    mysql> delete from dns_recs where displayHost like '%example.com%';
Have more questions? Submit a request
Please sign in to leave a comment.