[gentoo-user] Dspam/sql problem

[gentoo-user] Dspam/sql problem

[Stuart Howard]

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

Re: [gentoo-user] Dspam/sql problem

[Dan Farrell]

On Thu, 6 Sep 2007 15:56:39 +0100
"Stuart Howard" <stuart.g.howard@gmail.com> wrote:

> 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.

is there any way to tell whether any messages are being passed through
DSPAM at all?  

it almost looks like it's not being used at all.  

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] Dspam/sql problem

[Neil Bothwick]

[-- Attachment #1: Type: text/plain, Size: 368 bytes --]

Hello Dan Farrell,

> is there any way to tell whether any messages are being passed through
> DSPAM at all?  

Dspam adds a signature, either to the end of the mail or the headers,
showing that it has been processed. Your mail had
X-DSPAM-Signature: 1000,46e0235a229912502612845


-- 
Neil Bothwick

"Bother," said Pooh, as the vice squad took his GIFS

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 189 bytes --]