Hi, I'm trying to set up safebrowsing on fedora32 and having a few problems. I've set up the Google API key and believe I had it running successfully for some time about three weeks ago, but now I'm unable to keep it running.
Updates using the "build" option fail with a "duplicate entry" error: sqlalchemy.exc.IntegrityError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (MySQLdb._exceptions.IntegrityError) (1062, "Duplicate entry '00093283-1' for key 'PRIMARY'") [SQL: INSERT INTO sbclient_v4_prefixes (prefix, reflist_id) VALUES (%s, %s)] [parameters: (b'00093283', 1)] (Background on this error at: http://sqlalche.me/e/13/gkpj) The database (mariadb) is on a remote remote machine that has a few databases on it with a few clients connecting but is generally idle. I also received the following error: sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (2006, 'MySQL server has gone away') [SQL: SELECT sbclient_v4_lists.id AS sbclient_v4_lists_id, sbclient_v4_lists.`threatType` AS `sbclient_v4_lists_threatType`, sbclient_v4_lists.`threatEntryType` AS `sbclient_v4_lists_threatEntryType`, sbclient_v4_lists.`platformType` AS `sbclient_v4_lists_platformType`, sbclient_v4_lists.last_update AS sbclient_v4_lists_last_update, sbclient_v4_lists.state AS sbclient_v4_lists_state FROM sbclient_v4_lists WHERE sbclient_v4_lists.id = %s] [parameters: (2,)] (Background on this error at: http://sqlalche.me/e/13/e3q8) I am running the following command: # ./clamsbsync.py --config /etc/clamd.d/safebrowsing.conf -v build # cat /etc/clamd.d/safebrowsing.conf <safebrowsing> # Google's apikey for the safebrowsing datafeed apikey = IzaSyBwvwjUgIQ5t...WVaM ## MySQL database parameters db_host = havoc.mycompany.com db_user = sbclient db_pw = password db_name = sbclient ## outputdir is where the update python makes its safebrowsing.gdb outputdir = /var/lib/clamav/ </safebrowsing> How can I troubleshoot this further? _______________________________________________ clamav-users mailing list clamav-users@lists.clamav.net https://lists.clamav.net/mailman/listinfo/clamav-users Help us build a comprehensive ClamAV guide: https://github.com/vrtadmin/clamav-faq http://www.clamav.net/contact.html#ml
