Spamassassin Per User

[Craig White]

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 at phoenixinternet.net'' to check if spamd is using my SQL rule
> set for gilbert.g at 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 at 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 at tobyhouse.com>