You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Apr 16, 2021. It is now read-only.
https://groups.google.com/d/topic/security-onion/qcDgy0Meh5M/discussion
As a band-aid, I added the following code to the beginning of the cleanup()
function in the sguil-db-purge script:
/usr/bin/mysql -u$DB_USER $PASSWORD_OPTION -BN -e "DELETE FROM history WHERE
timestamp < DATE_SUB(NOW(), INTERVAL 90);" -D $DATABASE
This should keep a rolling 90-day history and speed up any upgrades/maintenance.
Original comment by doug.bu...@gmail.com on 31 Oct 2013 at 2:45
Added the following:
/usr/bin/mysql -u$DB_USER $PASSWORD_OPTION -BN -e "DELETE FROM history WHERE timestamp < DATE_SUB(NOW(), INTERVAL $DAYSTOKEEP DAY);" -D $DATABASE
Original comment by doug.bu...@gmail.com on 9 Jun 2014 at 1:20
Original issue reported on code.google.com by
doug.bu...@gmail.com
on 31 Oct 2013 at 2:45The text was updated successfully, but these errors were encountered: