Webmail of a domain without hosting is not accessible: 404 not found

Symptoms

• Webmail of a domain without hosting is not accessible. The following error is shown in a browser:

  PLESK_INFO: 404 not found

• webmail.example.com points to the server main IP address 203.0.113.1 in Plesk > Domains > example.com > DNS Settings.

Cause

When a domain does not have hosting, its webmail is assigned to a server main IP address in Plesk database.

In the current situation, there is an inconsistency in the Plesk system database where a non-server IP address is set for a domain.

Resolution

1. Login to the server via SSH.

2. Execute the script below.

   Note: example.com in DOMAIN_NAME should be changed to the affected domain name.

   # export DOMAIN_NAME='example.com';

   # plesk db "select @ipid:=ipa.ipAddressId,@dom_id:=d.id from DomainServices ds, IpAddressesCollections ipa, domains d where ds.type='web' and ipa.ipCollectionId=ds.ipCollectionId and d.id=ds.dom_id and d.name='$DOMAIN_NAME'; update dom_param set val=@ipid where param='ip_addr_id' and dom_id=@dom_id;"

3. Recreate webmail web configuration by going to Domains > example.com > Mail Settings and pressing the OK button.