Symptoms
-
Impossible to enable ModSecurity with the following error message:
PLESK_ERROR: Failed to install the ModSecurity rule set: Unable to find row with id 11 in domains table.
Unable to use the current ModSecurity rule set and to roll back to the previous version because they contain invalid rules. -
There is no domain with such ID:
C:> C:>plesk db “select * from domains where id=11”
C:>
Cause
Orphaned records in psa.IisAppPools
Resolution
-
Connect to the server via RDP
-
Check if there is an orphaned record:
MYSQL_WIN: mysql> select id from IisAppPools where ownerId=11;
+—–+
| id |
+—–+
| 188 |
+—–+ -
Remove the record:
MYSQL_WIN: mysql> delete from IisAppPools where ownerId=11;