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? -----Original Message----- From: Henry F. Camacho Jr [mailto:[EMAIL PROTECTED] Sent: Sunday, February 12, 2006 7:44 PM To: Don O'Neil Cc: users@spamassassin.apache.org Subject: Re: Enabling per user rules in SQL db it isn't 3.1, I am pretty sure it is 3.0 HFC Don O'Neil wrote: >Which version of Spamassassin are you running? > >-----Original Message----- >From: Henry F. Camacho Jr [mailto:[EMAIL PROTECTED] >Sent: Sunday, February 12, 2006 3:11 PM >To: Don O'Neil >Subject: Re: Enabling per user rules in SQL db > >I am using -q -x on spamd. > >HFC > > >Don O'Neil wrote: > > > >>Spamd is being called through spamc in a | to the ifspamh wrapper.... >> >>http://www.gbnet.net/~jrg/qmail/ifspamh/ >> >>It's a wrapper that is called from the virtual sql users .qmail file. >> >>-----Original Message----- >>From: Henry F. Camacho Jr [mailto:[EMAIL PROTECTED] >>Sent: Sunday, February 12, 2006 3:00 PM >>To: Don O'Neil >>Cc: users@spamassassin.apache.org >>Subject: Re: Enabling per user rules in SQL db >> >>How is spamd getting called? spamass-milter? >> >>If so put the following in your sysconfig: "-u -e" >> >>HFC >> >> >> >> >> >>Don O'Neil wrote: >> >> >> >> >>