Spamassassin 3.04 with SQL support. I'm trying to set up a global textbased or MYSQL based whitelist. I want to be able to support *wildcards* I am able to add specific addresses to the AWL using spamassassin --add-addr-to-whitelist but when I've used wildcards for some of our desired senders, they seemed to have been ignored.
I'd like to keep it simple with whitelist_from_rcvd [EMAIL PROTECTED] somedomain.com in the local.cf file. spamd is running with SPAMD_OPTS="-x -q -Q -H /var/lib/spamassassin/nobody --max-children 5" and exim is calling spamc with the user nobody. so I edited the table user_prefs in the mysql database, adding a record that says username nobody preference whitelist_from_rcvd value [EMAIL PROTECTED] somedomain.com I ran spamd with -D and it seems to have connected with the MYSQL server for user prefs as it certainly did for AWL entries and Bayes tokens, but the spam score on the mail message should certainly go down if the email address is really whitelisted. If I use the AWL it goes down to -50 when I use the --add-addr-to-whitelist flag. So I expect a good healthy minus quantity on a wildcard whitelisting but It never seems to happen. I recently migrated from a spamd config as follows. This one had no MYSQL server -u Debian-exim -x --virtual-config-dir /var/lib/spamassassin/%u --create-prefs --max-children 5 --helper-home-dir I put whitelist_from_rcvd in all kinds of files and they all seemed to be ignored, too. Is it a function of running spamd with -x? if so why did it never read local.cf? -Q is supposed to give you mysql user_prefs functionality with -x Any pointers?