MySQL-Datenbank LogoDB neu aufbauen
Version 1.7 von Michael Ecer am 2022/03/23 13:26
logosrv
/etc/init.d/ldcatalogd stop
ldserver stop
ldwebfilter --expire-surflog 0
ldwebfilter --update-surflog
cat /etc/logodb.secret
mmysql drop database logodb;
dpkg-reconfigure ld-mysql-logodb
reset_logodb_password {logodb.secret}
import_workstations
ldserver start
/etc/init.d/ldcatalogd start
Optional:
---------
Vorher Webfilter-Listen/-Kategorien sichern
while read line; do ldwebfilter -b "$line"; done < /root/webfilter_blacklist.list
while read line; do ldwebfilter -w "$line"; done < /root/webfilter_whitelist.list
while read line; do ldwebfilter -e "$line"; done < /root/webfilter_categories_B.list
while read line; do ldwebfilter -E "$line"; done < /root/webfilter_categories_W.list
ldwebfilter -l
ldwebfilter -c
ldwebfilter --find-surflog-entries user=admin