One other thing to point out. We ran all of the testing under the user nobody and in production we use the user filter.
So, when we switched over to pre-prod our bayes was blank because there were no entries for the user filter on the backend server. The fix was to modify the call to spamc to include -u nobody. Alternatively we could have done a bulk update of the db to change the user nobody to filter. Just something to think about... Gary Smith -----Original Message----- From: Michael Parker [mailto:[EMAIL PROTECTED] Sent: Monday, November 15, 2004 11:26 PM To: Rich West Cc: users@spamassassin.apache.org Subject: Re: SQL user config On Mon, Nov 15, 2004 at 11:52:55PM -0500, Rich West wrote: > > > >Now, on startup, it does mention that it was successful in getting a > >DB connection, but, aside from that, I have not seen any other > >activity relating to the database... Is there something that I have > >missed here? > > > >In the debug tests I have run with a clean message from an address in > >my whitelist (stored in the database), I see: > >debug: bayes: Database connection established > >debug: bayes: found bayes db version 3 > >debug: bayes: Using userid: 2 > >debug: Score set 3 chosen. > > > >But, it's like it is not using the database at all.... > > I think you've figured it out (ie -q or -Q) but I wanted to point out one thing. The debug above has nothing to do with User Prefs, it is for the bayes DB connection. Michael -- ApacheCon November 13-17 2004 http://www.apachecon.com/ See three SpamAssassin sessions & more Birds of a Feather Session: November 16th, 9-10pm
