I'm running amavisd-new with spamassassin and setup bayes and mysql earlier today. It seems to connect to the db fine with user vscan when running spamassassin -d. I ran sa-learn --spam/ham < spam.txt (full email headers too) a few times and those are the only entires in the db, the ones that I added, all other email is untouched. What's the deal? Here is my local.cf file... awl seems to work fine, but it scores mail funky sometimes.
# Enable the Bayes system use_bayes 1 bayes_store_module Mail::SpamAssassin::BayesStore::SQL bayes_sql_dsn DBI:mysql:bayes bayes_sql_username vscan bayes_sql_password vscan bayes_sql_override_username vscan # Enable awl auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList user_awl_dsn DBI:mysql:bayes user_awl_sql_username vscan user_awl_sql_password vscan -- View this message in context: http://www.nabble.com/mySQL-bayes-not-working-correctly-tf3896467.html#a11046183 Sent from the SpamAssassin - Users mailing list archive at Nabble.com.