Per-User required_score

2008-01-07 Thread David.Sharpe

Hi,

I want to give users control of the required_score variable.  I am using
Postfix // SpamAssassin // amavis.  

I have read the document http://wiki.apache.org/spamassassin/UsingSQL and
have the tests working OKAY.  

executing SQL: SELECT preference, value FROM userpref WHERE username =
'[EMAIL PROTECTED]' OR username = '$GLOBAL' OR username =
CONCAT('%','testdomain.com') ORDER BY username ASC


I am however unsure as to how to get Postfix to pass SpamAssassin the
username.  Below is an exert of the spamd log which shows the problem :

executing SQL: SELECT preference, value FROM userpref WHERE username =
'nobody' OR username = '$GLOBAL' OR username = CONCAT('%',NULL) ORDER BY
username ASC

-- 
View this message in context: 
http://www.nabble.com/Per-User-required_score-tp14664875p14664875.html
Sent from the SpamAssassin - Users mailing list archive at Nabble.com.


Re: Per-User required_score

2008-01-07 Thread David.Sharpe

Within postfix/master.cf I have the following lines :

smtp  inet  n   -   -   -   -   smtpd
  -o content_filter=spamassassin


This pushes mail through the following lines :

spamassassin unix - n   n   -   -   pipe
user=nobody argv=/usr/bin/spamc -f -e
/usr/sbin/sendmail -oi -f ${sender} ${recipient}


Hope this is what you were after...
Thanks,
- David


mouss-2 wrote:
 
 David.Sharpe wrote:
 Hi, I want to give users control of the required_score variable. I am 
 using Postfix // SpamAssassin // amavis. I have read the document 
 http://wiki.apache.org/spamassassin/UsingSQL and have the tests 
 working OKAY. /executing SQL: SELECT preference, value FROM userpref 
 WHERE username = '[EMAIL PROTECTED]' OR username = '$GLOBAL' OR 
 username = CONCAT('%','testdomain.com') ORDER BY username ASC /I am 
 however unsure as to how to get Postfix to pass SpamAssassin the 
 username. Below is an exert of the spamd log which shows the problem : 
 /executing SQL: SELECT preference, value FROM userpref WHERE username 
 = 'nobody' OR username = '$GLOBAL' OR username = CONCAT('%',NULL) 
 ORDER BY username ASC /
 
 
 how do you run spamassassin?
 
 
 

-- 
View this message in context: 
http://www.nabble.com/Per-User-required_score-tp14664875p14668113.html
Sent from the SpamAssassin - Users mailing list archive at Nabble.com.