Robert Bartlett writes:
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
Try out this to find the right value for bayes_sql_override_username.
SELECT id, username, spam_count, ham_count, token_count FROM bayes_vars;
- dhawal
-----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.
