[SOLVED] Trim database

The forum for help and support with FreeNATS as well as any useful hints and tips
Post Reply
paullanders
Posts: 92
Joined: Thu Sep 04, 2008 9:48 pm

[SOLVED] Trim database

Post by paullanders » Fri Jul 28, 2017 9:17 pm

Dave, is there a way to trim the database? For example, discard all historical data older than 30 days?

Thanks!

Paul
Last edited by paullanders on Wed Aug 30, 2017 3:35 pm, edited 1 time in total.

dave
Site Admin
Posts: 260
Joined: Fri May 30, 2008 9:09 pm
Location: UK
Contact:

Re: Trim database

Post by dave » Thu Aug 10, 2017 2:28 pm

Hi Paul,

Sorry for the delay (notifications going into spam hole I think).

In short yes there is. Your setup should be running the cleanup script daily (or however it's configured) but often missed from installation: http://www.purplepixie.org/freenats/wik ... PHP_Source

When that's running it should delete the records older than the configured values set here: http://www.purplepixie.org/freenats/wik ... ain.syslog

Hopefully that all works. Ahem, obviously rigorously tested etc... Any issues just shout.

Kind regards,

Dave.

paullanders
Posts: 92
Joined: Thu Sep 04, 2008 9:48 pm

Re: Trim database

Post by paullanders » Wed Aug 30, 2017 3:34 pm

Worked great. Thanks, Dave :-)

dave
Site Admin
Posts: 260
Joined: Fri May 30, 2008 9:09 pm
Location: UK
Contact:

Re: [SOLVED] Trim database

Post by dave » Wed Aug 30, 2017 4:48 pm

Excellent!

Post Reply