Can someone tell me what I am doing wrong? I don't believe spamassassin is using the database. When I use the "spamc" utility I get a response saying that my threshold is 4.0 which is what I have in the database. When I send a mail to myself from an outside source, I get a threshold of 5.0. 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 mysql 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 '[EMAIL PROTECTED]'' to check if spamd is using my SQL rule set for [EMAIL PROTECTED] 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 --------------------------------------------------------------------- QmailToaster hosted by: VR Hosted <http://www.vr.org> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]