spamassassin-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ralf Hildebrandt <Ralf.Hildebra...@charite.de>
Subject Re: Problem with txrep database
Date Mon, 04 Jul 2016 21:12:51 GMT
* Mark Martinec <Mark.Martinec+sa@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.xangler@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.xangler@charite.de|141.42
Jul  4 23:06:54 mail-cvk amavis[55022]: (55022-01) SA dbg: auto-whitelist: sql-based xxxxx.xangler@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.xangler@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.xangler@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.xxx@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.xxx@charite.de|141.42
Jul  4 23:10:46 mail-cbf amavis[3042]: (03042-01) SA dbg: auto-whitelist: sql-based yyy.xxx@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.xxx@charite.de
Jul  4 23:10:46 mail-cbf amavis[3042]: (03042-01) SA dbg: auto-whitelist: sql-based add_score/insert
amavis|yyy.xxx@charite.de|141.42|1|0.793|: SQL error: Duplicate entry 'amavis-yyy.xxx@charite.de--141.42'
for key 'PRIMARY'
...

-- 
Ralf Hildebrandt                   Charite Universitätsmedizin Berlin
ralf.hildebrandt@charite.de        Campus Benjamin Franklin
http://www.charite.de              Hindenburgdamm 30, 12203 Berlin
Geschäftsbereich IT, Abt. Netzwerk fon: +49-30-450.570.155

Mime
View raw message