[gentoo-user] Dspam/sql problem

["Stuart Howard" <stuart.g.howard@gmail.com>]

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