Page 1 of 1

[SOLVED] Trim database

Posted: Fri Jul 28, 2017 9:17 pm
by paullanders
Dave, is there a way to trim the database? For example, discard all historical data older than 30 days?

Thanks!

Paul

Re: Trim database

Posted: Thu Aug 10, 2017 2:28 pm
by dave
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.

Re: Trim database

Posted: Wed Aug 30, 2017 3:34 pm
by paullanders
Worked great. Thanks, Dave :-)

Re: [SOLVED] Trim database

Posted: Wed Aug 30, 2017 4:48 pm
by dave
Excellent!