How to clear the audit log?

General Beta 5.0
8

Yes, so audit log is stored in the database /etc/pihole/gravity.db, see, e.g.,

sqlite3 /etc/pihole/gravity.db "SELECT * FROM domain_audit;"

You can remove single domains (example: google.de) using

sudo sqlite3 /etc/pihole/gravity.db "DELETE FROM domain_audit WHERE domain = 'google.de';"

or purge the entire list without specifying a specific domain:

sudo sqlite3 /etc/pihole/gravity.db "DELETE FROM domain_audit;"
3 Likes