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 in set for a domain.

Resolution

1. Login to the server via SSH.

2. Access Plesk database using the command:

# plesk db

3. Find the id of the domain with a broken webmail:

MYSQL_LIN: mysql> select id from domains where name='example.com';
+----+
| id |
+----+
| 19 |
+----+
1 row in set (0.00 sec)

4. Check what IP address the domain is assigned to:

MYSQL_LIN: mysql> select * from dom_param where dom_id=19 and param='ip_addr_id';
+--------+------------+-----+
| dom_id | param      | val |
+--------+------------+-----+
| 19     | ip_addr_id | 2   |
+--------+------------+-----+
1 row in set (0.00 sec)

5. Find the id of the IP address from domain DNS settings:

MYSQL_LIN: mysql> select id,ip_address from IP_Addresses;
+----+------------+
| id | ip_address |
+----+------------+
| 1 | 203.0.113.1 |
| 2 | 203.0.113.2 |
+----+------------+
2 rows in set (0.00 sec)

6. Change the IP address id for the domain in the dom_param table:

MYSQL_LIN: mysql> update dom_param set val=1 where dom_id=19 and param='ip_addr_id';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

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