On 1/10/2014 6:55 AM, Mark Chaney wrote:
I understand what the username entry does for spamd when it comes to
what user it runs at. Can you look a bit closer at my actual debug
output that I have been providing? You can clearly see that spamd is
trying to load SA preferences for user mchaney instead of
mcha...@example.com and thus why _DOMAIN_ in the sql query will always
be null. Doesnt this seem like this is the issue?
As noted, have you tried the known-working query setup using CONCAT?
user_scores_sql_custom_query SELECT preference, value FROM _TABLE_
WHERE username = _USERNAME_ OR username = '$GLOBAL' OR username =!
CONCAT('%',_DOMAIN_) ORDER BY username ASC
