Alan, I have installed DBD::mysql and it still doesn't work. The install file says that DBD::mSQL is required and the options that I specified when we installed it was for mysql (as the mSQL diver is covers it as well).
It's funny though that AWL is logging to the DB. Also, something to note, is that in production we are running 3.0.1 and this is 3.0.2. Maybe it's not required and the code is just broken. Unfortunately my older dev environment is down otherwise I would try upgrading the 3.0.2 to see if it has the same problems. Here is the specific error: Apr 12 17:22:44 pxtoakdev04 spamd[3378]: Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/site_perl/5.8.5/Mail/SpamAssassin/BayesStore/SQL.pm line 157, <GEN2> line 2. Apr 12 17:22:44 pxtoakdev04 spamd[3378]: Use of uninitialized value in numeric ne (!=) at /usr/lib/perl5/site_perl/5.8.5/Mail/SpamAssassin/BayesStore/SQL.pm line 159, <GEN2> line 2. Apr 12 17:22:44 pxtoakdev04 spamd[3378]: Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/site_perl/5.8.5/Mail/SpamAssassin/BayesStore/SQL.pm line 160, <GEN2> line 2. Apr 12 17:22:44 pxtoakdev04 spamd[3378]: bayes: Database version is different than we understand (3), aborting! at /usr/lib/perl5/site_perl/5.8.5/Mail/SpamAssassin/BayesStore/SQL.pm line 160, <GEN2> line 2. Local.cf auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList user_awl_dsn DBI:mysql:spamassassin:10.0.0.41 user_awl_sql_username spamassassinuser user_awl_sql_password spamassassinpass bayes_store_module Mail::SpamAssassin::BayesStore::SQL bayes_sql_dsn DBI:mysql:spamassassin:10.0.0.41 bayes_sql_username spamassassinuser bayes_sql_password spamassassinpass > -----Original Message----- > From: alan premselaar [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 12, 2005 6:12 PM > To: Gary W. Smith > Cc: [EMAIL PROTECTED] > Subject: Re: SQL install with mSQL driver > > > Gary, > > I'm not a database expert by any means, but I've done a bit with the > DBI and MySQL. My understanding is that DBD::mSQL is an interface to a > different SQL server than MySQL, although I don't remember which one off > the top of my head. > > If you're using MySQL, you want to use the DBD::mysql module. I'd be > surprised if DBD::mSQL worked at all with MySQL. > > hope this helps. > > Alan