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. Robert -----Original Message----- From: Matt Kettler [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 1:32 PM To: Robert Bartlett Cc: users@spamassassin.apache.org Subject: Re: rules better than bayes? Robert Bartlett wrote: > Interesting, I did that just to see how mine were doing and the BAYES > one returned 0? Does that mean bayes is not being used? I have been > feeding emails to bayes and in debug mode it shows bayes being used. I > am using bayes in a mysql. Just weird that its showing 0. > That sounds a lot like you're training bayes into mysql, but when mail comes in and gets scanned, it's either not using SQL, or it's not using the same table. Usually this is a problem with username, where your training is occurring as "root" but your scanning is occurring as "nobody". You might want to try using the bayes_sql_override_username option, to force a single site-wide bayes database, instead of having one per userid executing SA. (note: that's per userid EXECUTING SA.. not per email recipient.)
