Expire records from the dba log automatically?

[kgc]

By policy we do not maintain logs older than 2 weeks. Can anyone share an example of how to expire records from the dba by age? (Or at all?)

Thanks!

[kgc]

Should anyone else want to do it, this should work provided you have a gnu-ish date.

Code: Select all

#!/bin/bash

DATE=`date --date "-14 days" +%s`;

/usr/local/openvpn_as/bin/sqlite3 /usr/local/openvpn_as/etc/db/log.db "delete from log where timestamp < $DATE"

[oibaf]

2021 update :

• use system sqlite3 (no longer included in openvpn-as package, at least on Debian);
• do a VACUMM to free DB space (otherwise no file size reduction).

Code: Select all

#!/bin/bash

DATE=`date --date "-14 days" +%s`;

/usr/bin/sqlite3 /usr/local/openvpn_as/etc/db/log.db "delete from log where timestamp < $DATE"
/usr/bin/sqlite3 /usr/local/openvpn_as/etc/db/log.db "VACUUM"