Ok... I changed the field in the DB from '[EMAIL PROTECTED]' to shcu0014 (the 'owner' of this email account) and the SQL rules work...
So, now my question is how do I make it work for JUST '[EMAIL PROTECTED]' and not everything @whtech.com that runs under user shcu0014? I want per user settings, not per domain. Although per domain is nice too! Don -----Original Message----- From: Don O'Neil [mailto:[EMAIL PROTECTED] Sent: Sunday, February 12, 2006 8:38 PM To: 'Daryl C. W. O'Shea' Cc: users@spamassassin.apache.org Subject: RE: Enabling per user rules in SQL db 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 the case. 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? Thanks! -----Original Message----- 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
