SQLite

Default installation of Web Safety stores monitoring data in SQLite database located in /opt/websafety/var/db/monitor.sqlite. This database is good enough to store browsing statistics for blocked items of a typical household for a month or so without consuming many system resources.

Sometimes it may be required to clear all previously collected monitoring information. To do this run the following command as root.

# create the sqlite database
python /opt/websafety/var/console/switch_db.py --db=sqlite

# generate the monitor.json in /opt/websafety/etc/ with new correct database settings
python /opt/websafety/var/console/sync_db.py

# reset owner (important!)
chown -R websafety:websafety /opt/websafety

Reboot your proxy box afterwards.