Articles in this section

See more

ModSecurity rule-set activation/update fails in Plesk: Unable to find row with id X in domains table

Avatar
Kuzma Ivanov
Updated
Follow
Plesk for Windows Plesk for Linux kb: technical ABT: Group B

Applicable to:

  • Plesk for Linux
  • Plesk for Windows

Symptoms

When activating or updating ModSecurity rule-set in Plesk at Tools & Settings > Web Application Firewall (ModSecurity), the operation fails with:

PLESK_ERROR: Unable to find row with id X in domains table.

Cause

Inconsistency in the Plesk database: orphaned records exist in the psa.IisAppPools table.

Resolution

 

For Plesk on Linux

 

  1. Connect to the Plesk server via SSH.

  2. Create a Plesk database dump:

    # plesk db dump psa > /root/psa_dump.sql

  3. Repair the Plesk database:

    # plesk repair db -y

  4. Log in to Plesk.

  5. Go to Tools & Settings > Web Application Firewall (ModSecurity), and click OK to update/activate the rule-set.

    Note: If the error message is still shown, select another rule-set and apply the changes. Then switch back to previous rule-set.

 

For Plesk on Windows Server

 

  1. Connect to the Plesk server via RDP.

  2. Start a command prompt as an Administrator.

  3. Create a Plesk database dump:

    C:\> plesk db dump psa > C:\psa_dump.sql

  4. Repair the Plesk database:

    C:\> plesk repair db -y

  5. Open the Plesk database in MySQL:

    C:\> plesk db

  6. Remove the orphaned entries:

    MYSQL_WIN: DELETE i, ia FROM IisAppPools i LEFT JOIN IisAppPoolDomains ia ON i.id = ia.poolId LEFT JOIN domains d ON d.id = ia.domainId WHERE d.name IS NULL AND i.id != 1;

  7. Log in to Plesk.

  8. Go to Tools & Settings > Web Application Firewall (ModSecurity), and click OK to update/activate the rule-set.

    Note: If the error message is still shown, select another rule-set and apply the changes. Then switch back to previous rule-set.

 

Comments

3 comments

Sort by Date Votes
  • Avatar
    Lpeters

    Still getting the same error.

    0
    Comment actions Permalink
  • Avatar
    Artyom Baranov

    Hi!

    I'd like to investigate this issue deeper, so I will create a ticket for you.

     

    0
    Comment actions Permalink
  • Avatar
    G.V Reddy (Edited )

    We had same issue.

    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.

    Below solution worked for me,

    Check whether the domain exists in the server with the same ID.

    mysql> select * from domains where id=916;
    Empty set (0.00 sec)

    Check whether the Application pool entry exists in 'IisAppPools' for that particular domain id.

    mysql> select id from IisAppPools where ownerId=916;
    +-----+
    | id |
    +-----+
    | 188 |
    +-----+
    1 row in set (0.00 sec)

    Remove record:

    mysql> delete from IisAppPools where ownerId=916;
    Query OK, 1 row affected (0.03 sec)

    Enable mod_security again.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles