Hi Doug, I'd try downgrading your DBD-MySQL driver to version 2.1028 and see if that solves the problem.
I've had identical problems with the project that I work on (mailwatch.sourceforge.net) which adds MySQL logging and reporting to MailScanner - the DBD-MySQL >2.9 seems to cause things to go awry and I'm not good enough at Perl to work out exactly why this is, but 2.1028 fixes the problem in all cases for me. Kind regards, Steve. > -----Original Message----- > From: Doug Eubanks [mailto:[EMAIL PROTECTED] > Sent: 02 March 2004 17:07 > To: [EMAIL PROTECTED] > Subject: BayesSQL Errors > > > Hi everyone! > > I seem to have a strange problem.... > > I am using SpamAssassin 2.70-CVS (Yesterday's build) with a > BayesSQL Store. SA-Learn works when I > populated the BayesTables or when I do a rebuild, without > errors. However, I am seeing > "autolearn=unavailable" in the headers of my messages. There > are over 1000 SPAMs and 1000 NON-SPAMS in > the table. This is what is showing up in my SpamAssassin log. > > Mar 2 11:57:26 wilsonco spamd[19479]: debug: Learning Ham > Mar 2 11:57:26 wilsonco spamd[19479]: debug: uri tests: Done uriRE > Mar 2 11:57:26 wilsonco spamd[19479]: DBD::mysql::st execute > failed: MySQL server has gone away at > /usr/lib/perl5/site_perl/5.8.0/Mail/SpamAssassin/BayesStoreSQL > .pm line 982. > Mar 2 11:57:26 wilsonco spamd[19479]: debug: bayes: > _get_db_version: SQL Error: MySQL server has gone > away > Mar 2 11:57:26 wilsonco spamd[19479]: debug: bayes: found > bayes db version 0 > Mar 2 11:57:26 wilsonco spamd[19479]: debug: bayes: Database > version 0 is different than we understand > (2), aborting! > > I am using the latest DBD::mysql perl module, I thought that > could be the problem. I know it is > checking the Bayes table because I see Bayes rules appearing > in the header. The only thing NOT working > is the autolearn. > > The MySQL server is working great, but autolearn isn't. > Permissions, connectivity, etc have been > verified. > > Here is my Bayes section of my SpamAssassin local.cf, no > password is required for the username used, we > used host checking.... > > bayes_store_module Mail::SpamAssassin::BayesStoreSQL > bayes_sql_username XXXX > bayes_sql_dsn DBI:mysql:SABayes:XXXXXXXXX > bayes_auto_learn 1 > bayes_auto_learn_threshold_nonspam 0.5 > bayes_auto_learn_threshold_spam 5.0 > bayes_ignore_header 1 > > > Any ideas? > > Thanks, > Doug Eubanks > [EMAIL PROTECTED] > > > Post Hoc, Ergo Propter Hoc > > *** DISCLAIMER *** > This e-mail and any attachments thereto may contain > information, which is confidential and/or protected > by intellectual property rights and are intended for the sole > use of the recipient(s) named above. Any > use of the information contained herein (including, but not > limited to, total or partial reproduction, > communication or distribution in any form) by persons other > than the designated recipient(s) is > prohibited. If you have received this e-mail in error, please > notify the sender either by telephone or > by e-mail and delete the material from any computer. Thank > you for your cooperation. > -- This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender and delete the message from your mailbox. This footnote also confirms that this email message has been swept by MailScanner (www.mailscanner.info) for the presence of computer viruses.
