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. #!/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). #!/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"
