I have been using Mysql for bayes storage for quite some time very
successfully for quite some time. After seeing a lot of spam coming
through since upgrading I though I had better check the scoring to
see what was going on. Here's what I found:
Jan 27 10:16:27 yoda spamd[30357]: Issuing rollback() for database
handle being DESTROY'd without explicit disconnect() at
/usr/lib/perl5/site_perl/5.8.8/Mail/SpamAssassin/Plugin/Bayes.pm line
1518, <GEN208> line 2.
I did some searching on the error but could not find anything related to SA.
Here are the lines in local.cf:
use_bayes 1
bayes_auto_learn 1
bayes_store_module Mail::SpamAssassin::BayesStore::MySQL
bayes_sql_dsn DBI:mysql:spam:localhost
bayes_sql_username spamd
bayes_sql_password ********
auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList
user_awl_dsn DBI:mysql:awl:localhost
user_awl_sql_username spamd
user_awl_sql_password *********
running a lint comes up clean - no warnings:
Jan 27 13:59:25.310 [29055] dbg: plugin:
Mail::SpamAssassin::Plugin::Bayes=HASH(0xaa80cc0) implements
'learner_new', priority 0
Jan 27 13:59:25.311 [29055] dbg: bayes: learner_new
self=Mail::SpamAssassin::Plugin::Bayes=HASH(0xaa80cc0),
bayes_store_module=Mail::SpamAssassin::BayesStore::MySQL
Jan 27 13:59:25.392 [29055] dbg: bayes: using username: ed
Jan 27 13:59:25.393 [29055] dbg: bayes: learner_new: got
store=Mail::SpamAssassin::BayesStore::MySQL=HASH(0xa769678)
Jan 27 13:59:25.394 [29055] dbg: plugin:
Mail::SpamAssassin::Plugin::Bayes=HASH(0xaa80cc0) implements
'learner_is_scan_available', priority 0
Jan 27 13:59:25.408 [29055] dbg: bayes: database connection established
Jan 27 13:59:25.410 [29055] dbg: bayes: found bayes db version 3
Jan 27 13:59:25.412 [29055] dbg: bayes: Using userid: 3
I went through the install docs again but can't find anything wrong
with my setup. Any suggestions as to where else to look?
Thanks!
Ed Kasky
~~~~~~~~~
Randomly Generated Quote (1159 of 1230):
When I woke up this morning my wife asked me,
"Did you sleep good?" I said, "No, I made a few mistakes."
--Steven Wright
