From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1ITIzF-0001mx-J5 for garchives@archives.gentoo.org; Thu, 06 Sep 2007 15:09:42 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.14.0/8.14.0) with SMTP id l86F1XMp023458; Thu, 6 Sep 2007 15:01:33 GMT Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.188]) by robin.gentoo.org (8.14.0/8.14.0) with ESMTP id l86EudP5016410 for ; Thu, 6 Sep 2007 14:56:39 GMT Received: by nf-out-0910.google.com with SMTP id 30so162285nfu for ; Thu, 06 Sep 2007 07:56:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=CYiHYxhsa9r6qDcOtbyQw6GXuhZPI99Jb4CZs9+Ke1M=; b=qCOSTu7EUkhIvZ59/8jJuAVhWiL+rxEneQSD+A4YxXLzJkmoOr96d0zzyczN2w4WRyvEAOEK4hkhAr+OYGx1LimWJbSd9UnUQDGNNr9DNHlLadYUnJNor4/cDINPVk3chAS9EyT/Jf9EweIwQdvqf2i6ZXfk1wjEXJl9ZV0uTb4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=D42xMzWBhDSRNw+LhmP82mjM1/mvRAaWQ1AVfVuDYizT+j0/TwTgb7qnug66ri+sBLfNfX4lWrNWzJJs1u1/esuHBSGBQ6d4bWboC1WLZt8a6Xs7Pl+flg8Jrh1nbbknjWkx5rggqM5KMLgEUJnVKim8mMZr8iM5mcD+cZCNehQ= Received: by 10.86.99.9 with SMTP id w9mr656861fgb.1189090599062; Thu, 06 Sep 2007 07:56:39 -0700 (PDT) Received: by 10.86.3.5 with HTTP; Thu, 6 Sep 2007 07:56:39 -0700 (PDT) Message-ID: Date: Thu, 6 Sep 2007 15:56:39 +0100 From: "Stuart Howard" To: gentoo-user@lists.gentoo.org Subject: [gentoo-user] Dspam/sql problem Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Archives-Salt: c87c2650-984f-4e42-b2ff-8449b39ce3a4 X-Archives-Hash: e3a956dbe8e7fc032479bb8c16fe44f2 Hi all I am trying to setup dspam to work with postfix and have followed the guide from the wiki http://gentoo-wiki.com/HOWTO_Spam_Filtering_with_DSPAM_and_Postfix [I have excluded the web interface for now as the web server is open to the wild on 80 though may change mind] Now the problem is that no mails seem to get tagged as spam [other than innocent] and it has been running prehaps 3 days now with at least a couple of hundreds spam's going through it. A typical header looks like this X-DSPAM-Result: Innocent X-DSPAM-Processed: Tue Sep 4 12:34:37 2007 X-DSPAM-Confidence: 1.0000 X-DSPAM-Probability: 0.0023 X-DSPAM-Signature: 46dd42cd114763254172700 I have used a mysql backend and I think my problem is here ie. the database seems to be empty eg. mysql> show tables; +----------------------+ | Tables_in_dspam | +----------------------+ | dspam_preferences | | dspam_signature_data | | dspam_stats | | dspam_token_data | +----------------------+ 4 rows in set (0.00 sec) mysql> select * from dspam_signature_data; Empty set (0.00 sec) also genstu stuart # dspam_stats -H mail: TP True Positives: 0 TN True Negatives: 0 FP False Positives: 0 FN False Negatives: 0 SC Spam Corpusfed: 0 NC Nonspam Corpusfed: 0 TL Training Left: 2500 SHR Spam Hit Rate 100.00% HSR Ham Strike Rate: 100.00% OCA Overall Accuracy: 100.00% ################snip########### Can anyone suggest an approach to getting things moving here? thanks stu ps. I am using courier to serve up maildir via IMAP and once I get the above working I would like the tagged spam to be put into a sub folder called junk [ or similar] but one thing at a time. -- gentoo-user@gentoo.org mailing list