Jonn R Taylor wrote: > This is what I use and it has been working for the last 3 years. > > # MySQL Setup > use_razor2 1 > use_bayes_rules 1 > allow_user_rules 1 > use_auto_whitelist 1 > > user_scores_dsn DBI:mysql:spamassassin:127.0.0.1 > user_scores_sql_username xxxxx > user_scores_sql_password xxxxx > > bayes_store_module Mail::SpamAssassin::BayesStore::MySQL > bayes_sql_dsn DBI:mysql:spamassassin:127.0.0.1 > bayes_sql_username xxxxx > bayes_sql_password xxxxx > bayes_sql_override_username @GLOBAL > > auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList > user_awl_dsn DBI:mysql:spamassassin:127.0.0.1 > user_awl_sql_username xxxxx > user_awl_sql_password xxxxx > > > Jonn > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 21, 2007 2:23 PM > To: users@spamassassin.apache.org > Subject: Setup SA to use mysql DB > > OK, i have gotten a little further after searching some other email. > This is what i get when i run spamassassin --lint > [3069] warn: config: failed to parse line, skipping: bayes_store_dsn > DBI:mysql:sadb:Spamassassin > Can't locate Mail/Spamassassin/BayesStore/MySQL.pm in @INC (@INC > contains: lib /usr/lib/perl5/vendor_perl/5.8.3/i586-linux-thread-multi > /usr/lib/perl5/vendor_perl/5.8.3 > /usr/lib/perl5/5.8.3/i586-linux-thread-multi /usr/lib/perl5/5.8.3 > /usr/lib/perl5/site_perl/5.8.3/i586-linux-thread-multi > /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl > /usr/lib/perl5/vendor_perl) at (eval 2266) line 2. > This is what my local.cf looks like: > bayes_store_dsn DBI:mysql:sadb:Spamassassin*what does this > signify? Can someone break this line down? > bayes_sql_username <name>is this the user of the mysql DB? > bayes_sql_password >password>is this the password for the user > of the mysql DB? > bayes_sql_override_username vscan*is this suppose to be here? > bayes_store_module Mail::Spamassassin::BayesStore::MySQL > > >
OK, it seems i have the MySQL.pm missing. But when i search for that pm on the spamassassin apache site, no go. I do see the DBI pm and have installed that thinking it may have "taken the place of" mysql.pm but i still get the same error when running spamassassin --lint. You do need the mysql.pm, right? The doco seems a little sparse when it comes to getting this to work. Chris
begin:vcard n:Arnold;Chris fn:Arnold, Chris url:http://www.mytimewithgod.net version:2.1 email;internet:[EMAIL PROTECTED] end:vcard
