Gentoo Archives: gentoo-user

From: Stuart Howard <stuart.g.howard@×××××.com>
To: gentoo-user@l.g.o
Subject: [gentoo-user] Dspam/sql problem
Date: Thu, 06 Sep 2007 15:09:42
Message-Id: d5d1857a0709060756u4fe19205pfb650da273984590@mail.gmail.com
1 Hi all
2
3 I am trying to setup dspam to work with postfix and have followed the
4 guide from the wiki
5 http://gentoo-wiki.com/HOWTO_Spam_Filtering_with_DSPAM_and_Postfix
6
7 [I have excluded the web interface for now as the web server is open
8 to the wild on 80 though may change mind]
9
10 Now the problem is that no mails seem to get tagged as spam [other
11 than innocent] and it has been running prehaps 3 days now with at
12 least a couple of hundreds spam's going through it.
13
14 A typical header looks like this
15 X-DSPAM-Result: Innocent
16 X-DSPAM-Processed: Tue Sep 4 12:34:37 2007
17 X-DSPAM-Confidence: 1.0000
18 X-DSPAM-Probability: 0.0023
19 X-DSPAM-Signature: 46dd42cd114763254172700
20
21 I have used a mysql backend and I think my problem is here ie. the
22 database seems to be empty
23 eg.
24 mysql> show tables;
25 +----------------------+
26 | Tables_in_dspam |
27 +----------------------+
28 | dspam_preferences |
29 | dspam_signature_data |
30 | dspam_stats |
31 | dspam_token_data |
32 +----------------------+
33 4 rows in set (0.00 sec)
34
35 mysql> select * from dspam_signature_data;
36 Empty set (0.00 sec)
37
38 also
39 genstu stuart # dspam_stats -H
40 mail:
41 TP True Positives: 0
42 TN True Negatives: 0
43 FP False Positives: 0
44 FN False Negatives: 0
45 SC Spam Corpusfed: 0
46 NC Nonspam Corpusfed: 0
47 TL Training Left: 2500
48 SHR Spam Hit Rate 100.00%
49 HSR Ham Strike Rate: 100.00%
50 OCA Overall Accuracy: 100.00%
51 ################snip###########
52
53
54 Can anyone suggest an approach to getting things moving here?
55
56 thanks
57 stu
58
59
60 ps. I am using courier to serve up maildir via IMAP and once I get the
61 above working I would like the tagged spam to be put into a sub folder
62 called junk [ or similar] but one thing at a time.
63 --
64 gentoo-user@g.o mailing list

Replies

Subject Author
Re: [gentoo-user] Dspam/sql problem Dan Farrell <dan@×××××××××.cx>