Ok I confused myself. Im sorry for being an idiot. I get it now. Everytime an email comes in it tries to access it as the user, since bayes is being feed to just the root account it doesn't see anything for the users in bayes. With the override I force it to use the root account for all emails coming in. Boy am I stupid.
Thanks Robert -----Original Message----- From: Robert Bartlett [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 1:52 PM To: users@spamassassin.apache.org Subject: RE: rules better than bayes? Sorry for the confusion, I do use a site wide bayes database, I thought the information I sent below was the site wide information the system uses to access the bayes database. Thanks Robert -----Original Message----- From: Matt Kettler [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 1:47 PM To: Robert Bartlett Cc: users@spamassassin.apache.org Subject: Re: rules better than bayes? Robert Bartlett wrote: > This is what I have in my local.cf file: > > bayes_store_module Mail::SpamAssassin::BayesStore::SQL > bayes_sql_dsn DBI:mysql:**************:localhost:3306 > bayes_sql_username ************ > bayes_sql_password ************ > > Obviously I hid the data that I didn't want to show with *. When I run > sa-learn it trains into the mysql database just fine, I assume SA > connects to it just fine because of that. That's all the database login information. That doesn't mean you have a single sitewide bayes database. Again, I suggest looking at the bayes_sql_override_username option.