Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 2C9B4200B30 for ; Mon, 4 Jul 2016 23:13:01 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 2B4C5160A65; Mon, 4 Jul 2016 21:13:01 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 71C02160A34 for ; Mon, 4 Jul 2016 23:13:00 +0200 (CEST) Received: (qmail 74606 invoked by uid 500); 4 Jul 2016 21:12:57 -0000 Mailing-List: contact users-help@spamassassin.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Delivered-To: mailing list users@spamassassin.apache.org Received: (qmail 74122 invoked by uid 99); 4 Jul 2016 21:12:56 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Jul 2016 21:12:56 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 49DA31A5D1F for ; Mon, 4 Jul 2016 21:12:56 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -3.577 X-Spam-Level: X-Spam-Status: No, score=-3.577 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, KAM_LOTSOFHASH=0.25, RCVD_IN_DNSWL_MED=-2.3, RP_MATCHES_RCVD=-1.426, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=charite.de Received: from mx2-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id 7wezCP2LD_xh for ; Mon, 4 Jul 2016 21:12:54 +0000 (UTC) Received: from mail-cbf-ext.charite.de (mail-cbf-ext.charite.de [193.175.73.208]) by mx2-lw-us.apache.org (ASF Mail Server at mx2-lw-us.apache.org) with ESMTPS id 9821F5F47B for ; Mon, 4 Jul 2016 21:12:53 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by mail-cbf.charite.de (Postfix) with ESMTP id 3rk09031s8z20lMt for ; Mon, 4 Jul 2016 23:12:52 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=charite.de; h= user-agent:in-reply-to:content-transfer-encoding :content-disposition:content-type:content-type:mime-version :references:message-id:subject:subject:from:from:date:date :received:received; s=default; t=1467666771; x=1469481172; bh=H9 np9g+QrDsIDZ8ZDKSHSQcCFqCM9IwkggX1RFFdk4Y=; b=rFlFBKTJmVVokGAfFm sNL3J3WPYbY8zbaxjqmVQh4VgRkuXsZmKc6ycmbVHdZyN1TIbbSiCxEK4mX6fwJO FpsZK2SZBiQxAq5KcEzjvhL7v2fAEwqPfJ1kjQM9Rbgp2Oi58DyIwO9JdXfdqZcf B03CtBT7YV1ByqipY7eoOJVe8= Received: from postamt.charite.de (postamt.charite.de [141.42.206.36]) (using TLSv1 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by mail-cbf.charite.de (Postfix) with ESMTPS for ; Mon, 4 Jul 2016 23:12:51 +0200 (CEST) Received: by postamt.charite.de (Postfix, from userid 7945) id 3rk08z3D7vz2r0b; Mon, 4 Jul 2016 23:12:51 +0200 (CEST) Date: Mon, 4 Jul 2016 23:12:51 +0200 From: Ralf Hildebrandt To: users@spamassassin.apache.org Subject: Re: Problem with txrep database Message-ID: <20160704211251.GD18984@charite.de> References: <20160704091642.GI22320@charite.de> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.23 (2014-03-12) archived-at: Mon, 04 Jul 2016 21:13:01 -0000 * Mark Martinec : > 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