Unable to change webmail client: Cannot find hosting by domain ID

Created:

2016-11-16 13:00:21 UTC

Modified:

2017-04-24 12:00:37 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to change webmail client: Cannot find hosting by domain ID

Applicable to:

  • Plesk 10.4 for Windows
  • Plesk 11.0 for Windows
  • Plesk 12.0 for Linux

Symptoms

While configuring webmail or enabling it for domain, the following error appears:

Error: Set default component failed: defpackagemng failed: Execute websrvmng --add-webmail-site --webmail=horde failed with error code 1: Cannot find hosting by domain ID 404
at (PSADatabase::getDomainHosting line 455)
at updateWebMailLink(domain.tld)(WebServerManager::reconfigureWebMail line 2780)

Cause

Error message ' Cannot find hosting by domain ID ' means that Plesk database has broken link between 'domains' and 'hosting' tables.

Resolution

  1. Check if domain with mentioned ID has hosting or not:

    mysql> select id, name, htype from domains where id=404;
    +-----+--------------------+---------+

    | id | name | htype |
    +-----+--------------------+---------+

    | 404 | domain.tld | vrt_hst |
    +-----+--------------------+---------+

    mysql> select * from hosting where dom_id=404;
    Empty set (0.27 sec)
  2. As there is no hosting for domain in hosting table, update domains table, set hosting to none for this domain:

    mysql> update domains set htype='none' where id=404;
    Query OK, 1 row affected (0.01 sec)
    Rows matched: 1 Changed: 1 Warnings: 0
Have more questions? Submit a request
Please sign in to leave a comment.