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
(text/plain)