Yes, it does not work for the reasons I have explained numerous times.
_DOMAIN_ can not exist unless the _USERNAME_ is a full email address.
Its not.....
On 2014-01-10 06:02, Kevin A. McGrail wrote:
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
