Domains show Plesk default page or mail services misbehave: web service cannot operate: the IP address list with ID 101 is empty

Daniel Yordanov

Updated January 25, 2024 16:35

Plesk for Linux kb: technical

Applicable to:

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

There are no configuration files for the domains in /etc/httpd/conf/plesk.conf.d/vhosts/

Inconsistency in the Plesk database (psa) after manual IP removal that was not done via the Plesk graphical interface or the Plesk CLI commands.

Connect to the server via SSH
Create Plesk database backup
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