Symptoms
- Plesk Obsidian running on a Linux-based operating system
-
All domains show Plesk default page
- In case of multiple IP address on a single Plesk server, emails sent from domains on the Plesk server are not being sent from the correct IP address designated for the mail delivery service of the domain
-
Checking database for inconsistencies return an error:
# plesk repair db -n
Inconsistency in the table 'DomainServices' for the column
ipCollectionId: Web service cannot operate: the IP address list with
ID 101 is empty
Cause
Inconsistency in the Plesk database (psa) after manual IP removal that was not done via the Plesk graphical interface or the Plesk CLI commands.
Resolution
-
Connect to the server via SSH
-
Find the affecting domain using ID from error message:
# plesk db "SELECT ipCollectionId, name FROM DomainServices JOIN domains ON dom_id = domains.id WHERE ipCollectionId = 101"
+-----------------+----------------+
| ipCollectionId | name |
+-----------------+----------------+
| 101 | example.com |
+-----------------+----------------+ -
Find the IP address that should be used for the domain:
# grep listen /var/www/vhosts/system/example.com/conf/nginx.conf
listen 203.0.113.2:443 ssl http2;
listen 203.0.113.2:80; -
Find the ID of the IP address to be used:
# plesk db "SELECT id, ip_address FROM IP_Addresses WHERE ip_address = '203.0.113.2'"
+-----+--------------+
| id | ip_address |
+-------+------------+
| 1 | 203.0.113.2 |
+-----+--------------+ -
Insert a record for the IP address from step 3 using ID from the error message and step 5.:
# plesk db "insert into IpAddressesCollections values(101, 1)"
- Once all of the inconsistencies are resolved, initiate the reread operation for IP addresses assigned to your Plesk server by executing the following command:
# plesk bin ipmanage --reread
-
Repair broken web configuration files:
# plesk repair web -y
- Repair broken mail configuration files:
# plesk repair mail -y