* Mark Martinec <mark.martinec...@ijs.si>: > amavisd.conf: > $log_level = 3; # or higher > $sa_debug = 'TxRep,auto-whitelist'; > > make sure syslogd is not filtering out debug level messages, > then reload amavisd and grep through the log: > > tail -f /var/log/amavisd-debug.log | egrep '(TxRep|auto-whitelist): '
Seems to be working ok now (on both nodes using the same DB): Jul 4 23:06:54 mail-cvk amavis[55022]: (55022-01) SA dbg: auto-whitelist: sql-based connected to DBI:mysql:spamassassin:141.42.1.208 Jul 4 23:06:54 mail-cvk amavis[55022]: (55022-01) SA dbg: auto-whitelist: sql-based using username: amavis Jul 4 23:06:54 mail-cvk amavis[55022]: (55022-01) SA dbg: auto-whitelist: sql-based get_addr_entry: no entries found for 4f5c7d11104e3ebaa9f74ace73ce2f76e0c83887@sa_generated|1467666413 Jul 4 23:06:54 mail-cvk aavis[55022]: (55022-01) SA dbg: auto-whitelist: sql-based 4f5c7d11104e3ebaa9f74ace73ce2f76e0c83887@sa_generated|1467666413 scores 0, count 0 Jul 4 23:06:54 mail-cvk amavis[55022]: (55022-01) SA dbg: TxRep: reputation: none, count: 0, weight: 1.0, delta: 0.000, MSG_ID: 4f5c7d11104e3ebaa9f74ace73ce2f76e0c83887@sa_generated Jul 4 23:06:54 mail-cvk amavis[55022]: (55022-01) SA dbg: TxRep: active, 4f5c7d11104e3ebaa9f74ace73ce2f76e0c83887@sa_generated pre-score: -3.393, autolearn score: -0.012, IP: 141.42.206.170, address: xxxxx.xang...@charite.de (unsigned) Jul 4 23:06:54 mail-cvk amavis[55022]: (55022-01) SA dbg: auto-whitelist: sql-based get_addr_entry: no entries found for xxxxx.xang...@charite.de|141.42 Jul 4 23:06:54 mail-cvk amavis[55022]: (55022-01) SA dbg: auto-whitelist: sql-based xxxxx.xang...@charite.de|141.42 scores 0, count 0 Jul 4 23:06:54 mail-cvk amavis[55022]: (55022-01) SA dbg: TxRep: reputation: none, count: 0, weight: 10.0, delta: 0.000, EMAIL_IP: xxxxx.xang...@charite.de Jul 4 23:06:54 mail-cvk amavis[55022]: (55022-01) SA dbg: auto-whitelist: sql-based add_score/insert score -0.012: amavis|xxxxx.xang...@charite.de|141.42|1|-0.012| .. and Jul 4 23:10:46 mail-cbf amavis[3042]: (03042-01) SA dbg: auto-whitelist: sql-based connected to DBI:mysql:spamassassin:localhost Jul 4 23:10:46 mail-cbf amavis[3042]: (03042-01) SA dbg: auto-whitelist: sql-based using username: amavis Jul 4 23:10:46 mail-cbf amavis[3042]: (03042-01) SA dbg: auto-whitelist: sql-based get_addr_entry: no entries found for 2703498fc375363e49c2a3b835ade3bc6b47c7d1@sa_generated|1467666644 Jul 4 23:10:46 mail-cbf amavis[3042]: (03042-01) SA dbg: auto-whitelist: sql-based 2703498fc375363e49c2a3b835ade3bc6b47c7d1@sa_generated|1467666644 scores 0, count 0 Jul 4 23:10:46 mail-cbf amavis[3042]: (03042-01) SA dbg: TxRep: reputation: none, count: 0, weight: 1.0, delta: 0.000, MSG_ID: 2703498fc375363e49c2a3b835ade3bc6b47c7d1@sa_generated Jul 4 23:10:46 mail-cbf amavis[3042]: (03042-01) SA dbg: TxRep: active, 2703498fc375363e49c2a3b835ade3bc6b47c7d1@sa_generated pre-score: -2.956, autolearn score: 0.793, IP: 141.42.206.171, address: yyy....@charite.de (unsigned) Jul 4 23:10:46 mail-cbf amavis[3042]: (03042-01) SA dbg: auto-whitelist: sql-based get_addr_entry: found 1 entries for yyy....@charite.de|141.42 Jul 4 23:10:46 mail-cbf amavis[3042]: (03042-01) SA dbg: auto-whitelist: sql-based yyy....@charite.de|141.42 scores 2.482, count 2 Jul 4 23:10:46 mail-cbf amavis[3042]: (03042-01) SA dbg: TxRep: reputation: 1.241, count: 2, weight: 10.0, delta: 0.299, EMAIL_IP: yyy....@charite.de Jul 4 23:10:46 mail-cbf amavis[3042]: (03042-01) SA dbg: auto-whitelist: sql-based add_score/insert amavis|yyy....@charite.de|141.42|1|0.793|: SQL error: Duplicate entry 'amavis-yyy....@charite.de--141.42' for key 'PRIMARY' ... -- Ralf Hildebrandt Charite Universitätsmedizin Berlin ralf.hildebra...@charite.de Campus Benjamin Franklin http://www.charite.de Hindenburgdamm 30, 12203 Berlin Geschäftsbereich IT, Abt. Netzwerk fon: +49-30-450.570.155
