Spamassassin

Force spamassassin to scan messages from localhost, when using qmail-scanner: service smtp {

       socket_type     = stream
       protocol        = tcp
       wait            = no
       disable         = no
       user            = root
       instances       = UNLIMITED
       env             = QS_SPAMASSASSIN="on"
       server          = /var/qmail/bin/tcp-env
       server_args     = /usr/sbin/rblsmtpd -r sbl-xbl.spamhaus.org /var/qmail/bin/relaylock /var/qmail/bin/qmail-smtpd /var/qmail/bin/smtp_auth /var/qmail/bin/true /var/qmail/bin/cmd5checkpw /var/qmail/bin/true

}

Mysql settings for whitelisting:

this doesnt work
INSERT INTO userpref (username,preference,value) VALUES ('%tsginc.com','whitelist_from','developmentex.com');
INSERT INTO userpref (username,preference,value) VALUES ('%tsginc.com','whitelist_from','@developmentex.com');
INSERT INTO userpref (username,preference,value) VALUES ('%tsginc.com','whitelist_from','%@developmentex.com');

This works
INSERT INTO userpref (username,preference,value) VALUES ('%tsginc.com','whitelist_from','*developmentex.com');
INSERT INTO userpref (username,preference,value) VALUES ('%tsginc.com','whitelist_from','*@developmentex.com');