Dspam/sql problem - ReadList.com

1 msg	New samba-3.0.25c broken?
1 msg	apache upgrade - default configuration not expl...
3 msg	Adding field to incoming email headers via proc...
1 msg	apache2 upgrade SSL and logging questions
2 msg	AMD/ATI to open source drviers?
3 msg	apache configuration woes
2 msg	Moving a file using Python and Cron
7 msg	Dead apache (cannot listen)
2 msg	OT - Accessing the Digital Cable DVR...
4 msg	portage update problem

Dspam/sql problem
\ Stuart Howard (6 Sep 2007)
. \ Dan Farrell (6 Sep 2007)
. . \ Neil Bothwick (6 Sep 2007)

6 msg	gpasswd
2 msg	Need help configuribng PORTAGE_ELOG_MAILURI
2 msg	udev and ethernet
5 msg	Qemu compilation fails
6 msg	ALSA / sound not working
4 msg	Extending a partition with LVM on it
11 msg	Sound doesn't work in Flash
3 msg	Webcam on Pavilion Dv1000
10 msg	Can't emerge X11

Subject:	Dspam/sql problem
Group:	Gentoo-user
From:	Stuart Howard
Date:	6 Sep 2007

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 mailing list