Re: Enabling per user rules in SQL db

[Henry F. Camacho Jr]

Don:




HFC


Don O'Neil wrote:

SpamC does not look at the to: address. I just solved this problem in a thread earlier. Since I am using sendmail, I used the spamass-milter, and that has the ability to look at the to address and send it directly to spamd. If you want to have the userprefs loaded based on the to: address, spamass-milter is able to do this.

Even if I use the -v (vpopmail) option? How else can the pref's come from a
username if there is no username assigned in the /etc/password? I thought
that was why there was the -v and -q options to begin with.

I've tried using -v with -u daemon, but that didn't help.

Doesn't spamc look at who the email is delivered to? And then take the prefs
based on that address?

I guess I'm not following what the point of the options are if this isn't

Can I pass the username to spamc in the form of [EMAIL PROTECTED], even if
this doesn't exist in the /etc/password file for spamc to grab the config
for? If so, how?


-----Original Message-----

the case. Thanks! From: Daryl C. W. O'Shea [mailto:[EMAIL PROTECTED] Sent: Sunday, February 12, 2006 8:20 PM

To: Don O'Neil
Cc: users@spamassassin.apache.org
Subject: Re: Enabling per user rules in SQL db

Don O'Neil wrote:

Looks like the problem is the username interpretation....

Feb 12 19:53:44 bigbird spamd[85410]: config: Conf::SQL: executing SQL:
select p

reference, value from userpref where username = 'shcu0003' or username = '@GLOBAL' order by username asc Feb 12 19:53:44 bigbird spamd[85410]: config: retrieving prefs for shcu0003 from SQL server Feb 12 19:53:44 bigbird spamd[85410]: info: user has changed Shouldn't it be checking the actual delivery address, such as '[EMAIL PROTECTED]' rather than the user ID? There are many email accounts associated with that userID (the ID is that for the domain account). I was under the impression that that was they way it worked, and the GUI's expect that too. Maybe I'm missing something in the config?

The username used is either the user spamc is run by or the username
supplied to spamc with the -u parameter.  spamc can't just guess what
username to use, as you've suggested.

Daryl

smime.p7s
Description: S/MIME Cryptographic Signature