RE: Spamassassin Per User

I have run "spamassassin -D --lint" before and seen nothing that could help
me. What should I be looking for?

Gilbert

-----Original Message-----
From: plug-discuss-bounces@lists.plug.phoenix.az.us
[mailto:plug-discuss-bounces@lists.plug.phoenix.az.us] On Behalf Of Craig
White
Sent: Wednesday, December 20, 2006 11:38 AM
To: Main PLUG discussion list
Subject: Re: Spamassassin Per User

try...

spamassassin -D --lint

Craig

On Wed, 2006-12-20 at 11:20 -0700, Gilbert T. Gutierrez, Jr. wrote:
> Can someone tell me what I am doing wrong? I don't believe spamassassin
is
> using the database. Details are below.
>
> Gilbert
>
> Server: Centos4.4
> Mail: QMAIL-TOASTER
>
> I want to use MySQL with the server to allow users the ability to
customize
> spamassassin.
> http://wiki.apache.org/spamassassin/UsingSQL
>
> I added the spamassassin commands I think necessary to the file
> /etc/mail/spamassassin/local.cf
>

>   user_scores_dsn                  DBI:mysql:spamassassin:127.0.0.1
>   user_scores_sql_password         ****
>   user_scores_sql_username         spamassassin
>   user_scores_sql_custom_query     SELECT preference, value FROM _TABLE_
> WHERE \
>                                    username = _USERNAME_ OR username =
> '$GLOBAL' \
>                                    OR username = CONCAT('%',_DOMAIN_)

ORDER
> BY username ASC
>
> the user spamassassin has only SELECT privileges
>
> I have added a -q to the spamd service in /var/qmail/supervise/spamd
> exec /usr/bin/spamd -q -x -u vpopmail -s stderr 2>&1
>
> I run the command "echo -e "From: user\nTo:user\Subject: Test\n\n" | spamc
> -u 'gilbert.g@phoenixinternet.net'' to check if spamd is using my SQL rule
> set for gilbert.g@phoenixinternet.net and the response reports a required
> score of 4.0 which is the same as what I have in the SQL database.
>

> X-Spam-Status: No, score=2.8 required=4.0
> tests=EMPTY_MESSAGE,MISSING_SUBJECT,
>         NO_RECEIVED,NO_RELAYS autolearn=no version=3.1.7

>
> When I send a test message from my yahoo account to that same user, the
> header reports a 5.0.
>
> X-Spam-Status: No, score=0.0 required=5.0 tests=HTML_MESSAGE
>
>
> ---
> [ This E-mail was scanned for viruses by Phoenix Internet ]
> [ Phoenix Internet http://www.phoenixinternet.net ]
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
--
Craig White <craig@tobyhouse.com>

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
---
[ This E-mail was scanned for viruses by Phoenix Internet ]
[ Phoenix Internet http://www.phoenixinternet.net ]


---
[ This E-mail was scanned for viruses by Phoenix Internet ]
[ Phoenix Internet http://www.phoenixinternet.net ]

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss