Hi,
We have our blacklist/whitelist stored in MySQL, has always worked fine, but
I've got an issue where an email that is stored in whitelist_from (SQL) is not
applied
Running spamassassin -D < message 2>output.txt and I noticed this:
dbg: spf: def_spf_whitelist_from: already checked spf and didn't get pass,
skipping whitelist check
This mail is coming from u...@hotmail.com, and I verified Hotmail's SPF for the
incoming IP and its all good
My SQL query in local.cf looks like this:
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 database contains this:
mysql> select * from userpref WHERE value = "u...@hotmail.com";
+--------+------------+----------------+------------------+
| prefid | username | preference | value |
+--------+------------+----------------+------------------+
| 3485 | %domain.ca | whitelist_from | u...@hotmail.com |
+--------+------------+----------------+------------------+
1 row in set (0.00 sec)
u...@hotmail.com has no USER_IN_WHITELIST applied while it should...
Any hints?
Thanks!
