master.cf:
spamassassin unix - n n - - pipe
user=nobody argv=/usr/local/bin/spamc -U /tmp/spamd.sock -f -e
/usr/local/sbin/sendmail -oi -f ${sender} ${recipient}I'm running spamd on the system:
/usr/local/bin/spamd -d -q -x -u nobody --socketpath=/tmp/spamd.sock -D
I'm using a mysql database for user preferences:
/etc/mail/spamassassin/local.cf
user_scores_dsn DBI:mysql:spamassassin:<hostname> user_scores_sql_username <username> user_scores_sql_password <password> user_scores_sql_table userpref
The SQL documentation says:
Alternatively,you can use the entire recipient's email address, e.g. "[EMAIL PROTECTED]", and use the full varchar(100).
How do I get it to load the userpref's from mysql using the recipients email address?? It works for @GLOBAL settings and if I put the settings in there under user "nobody" so I know its not a mysql connection or configuration option. I have tried passing the -u 'email' to spamc but it doesn't work... I says:
May 9 14:24:05 hostname spamd[70691]: logmsg: clean message (-2.2/10.0) for '<email>':100 in 3.6 seconds, 1953 bytes.
But it still didn't load the user preferences from the mysql table with the corresponding <email>. I am able to get it to work using procmail as it obviously runs as the user. I have tried using "allow_user_rules" set to 1 as well with no luck.
Is there something I'm doing wrong or is this not possible? Sorry if this is already explained some where and I just can't find it...
-- James L Moser [EMAIL PROTECTED] PowWeb Hosting http://www.powweb.com
/(bb|[^b]{2})/, that is the Question.mysql>SELECT * FROM user WHERE clue > 0;
Empty set (0.03 sec)
Health is merely the slowest possible rate at which one can die... Health nuts are going to feel stupid someday, lying in hospitals dying of nothing...
begin:vcard fn:James Moser n:Moser;James org:PowWeb INC;Internet Technology adr:;;1645 S La Cienaga #7;Los Angeles;CA;90035;US email;internet:[EMAIL PROTECTED] title:CTO x-mozilla-html:FALSE url:http://www.powweb.com version:2.1 end:vcard
