Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Problem with modsec.sqlite size

Discussion in 'Security' started by jlucho, Jun 20, 2019.

  1. jlucho

    jlucho Well-Known Member

    Joined:
    Aug 5, 2006
    Messages:
    56
    Likes Received:
    1
    Trophy Points:
    158
    dear

    I have a problem with /var/cpanel/modsec/modsec.sqlite
    current size is 12Gb

    How can I clean or empty the contents of that file and not cause any problems in the operation of cPanel?

    also, view this report : - Removed -
    Likewise, how can I remove this option from "ModSecurity Tools> Hits List", how can you appreciate, it has more than 81 thousand pages
     
    #1 jlucho, Jun 20, 2019
    Last edited by a moderator: Jun 20, 2019
  2. SS-Maddy

    SS-Maddy Well-Known Member

    Joined:
    Mar 28, 2009
    Messages:
    122
    Likes Received:
    13
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    Code:
    /scripts/restartsrv_tailwatchd --stop
    mv /var/cpanel/modsec/modsec.sqlite /var/cpanel/modsec/modsec.sqlite.old1
    /scripts/setup_modsec_db
    /scripts/restartsrv_tailwatchd --start
    It would clear the database having the hit list and setup_modsec_db would create a clean empty one. Those 81000 pages would also be cleared by now.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,466
    Likes Received:
    505
    Trophy Points:
    263
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Thanks for providing that advice @SS-Maddy

    @jlucho don't hesitate to let us know if you have any further questions or concerns.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice