What does the SQL entry look like?
I assume you used Dallas' setup under
"Global, Per-Domain, and Per-User Preferences via SQL"
On 01/10/2014 10:47 AM, Mark Chaney wrote:
So my I dont think I am getting this to work. I have _DOMAIN_ in my
query, but it doesnt appear to get assigned a value as the spamassasin
debug is showing a value of NULL when it performs the query. Any
suggestions? I am not really finding much information on how this value
gets populated. If I do something like:
echo -e "From: user\nTo:user\Subject: Test\n\n" | spamc -u 'example.com'
I get:
Jan 10 03:20:04.791 [28346] info: spamd: handle_user unable to find
user: 'example.com'
Jan 10 03:20:04.795 [28346] dbg: config: Conf::SQL: executing SQL:
SELECT 'required_hits' as preference, spam_score as value FROM domains
WHERE domain = NULL ORDER BY domain ASC
Jan 10 03:20:04.796 [28346] dbg: config: retrieving prefs for
example.com from SQL server
Jan 10 03:20:04.796 [28346] dbg: info: user has changed
It says it getting the preferences for the example.com, but I am not
sure how thats correct when the query has it set as NULL. Suggestions?
On 2014-01-06 08:48, Mark Chaney wrote:
LOL, my bad. I had googled for spamassassin preferences per domain,
but didnt use that exact text. I knew user preferences were available
via mysql, but I didnt see that exact doc. Thanks!
On 2014-01-06 08:35, Axb wrote:
On 01/06/2014 03:32 PM, Mark Chaney wrote:
Is it possible to set spamassassin preferences per domain instead of
per
user? If so, how can I go about doing this? If this could be pulled
from
a mysql table, even better.
Thanks,
Mark
http://lmgtfy.com/?q=spamassassin+mysql+preferences
