At 03:37 PM Wednesday, 1/27/2010, Mark Martinec wrote -=>
On Wednesday January 27 2010 23:28:46 Ed Kasky wrote:
> 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.
> bayes_store_module Mail::SpamAssassin::BayesStore::MySQL
> auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList
> running a lint comes up clean - no warnings
> I went through the install docs again but can't find anything wrong
> with my setup. Any suggestions as to where else to look?
Assuming your database tables are of the type TYPE=InnoDB
(as documented in ./sql/README.bayes) there does not appear to be
anything unusual about your setup. I'm running a setup just like
that (under amavisd and SpamAssassin 3.3.0, and bayes works
fine with MySQL 5.1.42 .
I suggest trying to reproduce the problem with a command-line
spamassassin (with debugging enabled), and if that is not successful,
turn on full debugging with spamd, then on hitting a problem
examine back if there are any previous telltale signs leading
to the problem.
After running spamd with -D switch, emails processed still generate
just the one message:
Jan 27 17:36:49 yoda spamd[8719]: spamd: connection from localhost
[127.0.0.1] at port 42825
Jan 27 17:36:49 yoda spamd[8719]: 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, <GEN13> line 2.
Running a message through command line I see the following:
Jan 27 17:38:26.328 [8928] dbg: bayes: learner_new
self=Mail::SpamAssassin::Plugin::Bayes=HASH(0xbbc8cc0),
bayes_store_module=Mail::SpamAssassin::BayesStore::MySQL
Jan 27 17:38:26.369 [8928] dbg: bayes: using username: ed
Jan 27 17:38:26.370 [8928] dbg: bayes: learner_new: got
store=Mail::SpamAssassin::BayesStore::MySQL=HASH(0xb8b1678)
Jan 27 17:38:26.371 [8928] dbg: plugin:
Mail::SpamAssassin::Plugin::Bayes=HASH(0xbbc8cc0) implements
'learner_is_scan_available', priority 0
Jan 27 17:38:26.381 [8928] dbg: bayes: database connection established
Jan 27 17:38:26.384 [8928] dbg: bayes: found bayes db version 3
Jan 27 17:38:26.385 [8928] dbg: bayes: Using userid: 3
I'm stumped...
...........................................................................
Randomly Generated Quote (1155 of 1582):
Several excuses are always less convincing than one.
-Aldous Huxley, novelist (1894-1963)