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