What version of SA? When you built SA from a tarball you did "rpmbuild -tb Mail-SpamAssassin-3.2.1.tar.gz". You may want to rebuild SA from source and then do a rpm -Uvh to install.
Jonn -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, June 22, 2007 9:25 AM To: users@spamassassin.apache.org Subject: RE: Setup SA to use mysql DB Jonn R Taylor wrote: > Verify that you do not have 2 versions of perl installed and that part > of your SA install did not go in the wrong version. What OS and how did > you build SA? > > Jonn > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, June 22, 2007 8:22 AM > To: users@spamassassin.apache.org > Subject: RE: Setup SA to use mysql DB > > 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 > > > > > > > > > We use perl 5.8.3 and SLES9. As far as i can remember, SA was installed with an rpm that was built from tarball?