[prev in list] [next in list] [prev in thread] [next in thread] 

List:       spamassassin-users
Subject:    Re: Problem with txrep database
From:       Ralf Hildebrandt <Ralf.Hildebrandt () charite ! de>
Date:       2016-07-04 21:12:51
Message-ID: 20160704211251.GD18984 () charite ! de
[Download RAW message or body]

* 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


[prev in list] [next in list] [prev in thread] [next in thread]