Problem with modsec.sqlite size

jlucho

• June 20, 2019 12:17

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

• 

  SS-Maddy

  • June 20, 2019 18:35

  /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.

  0
• 

  cPanelLauren

  • June 21, 2019 18:28

  Thanks for providing that advice @SS-Maddy @jlucho don't hesitate to let us know if you have any further questions or concerns.

  0
• 

  Islam Apon

  • August 12, 2024 08:35

  I faced the same issue with the modsecsqlite file, using 112 GB disk space on a server.

  I found that @SS-Maddy's command lines was overlaped. So here's the re-organized command lines if anyone else need it.

  /scripts/restartsrv_tailwatchd --stop 
  mv /var/cpanel/modsec/modsec.sqlite /var/cpanel/modsec/modsec.sqlite.old1 
  /scripts/setup_modsec_db 
  /scripts/restartsrv_tailwatchd --start

  1

Please sign in to leave a comment.