Outlook top post. -----Original Message----- From: Nigel Frankcom [mailto:[EMAIL PROTECTED] Sent: Friday, June 22, 2007 10:18 AM To: SpamAssassin Subject: Re: Setup SA to use mysql DB
S'cuse the top post but.... If you're going to the trouble of tarball --> RPM, why not just do yum install spamassassin? KR Nigel On Fri, 22 Jun 2007 10:11:14 -0500, "Jonn R Taylor" <[EMAIL PROTECTED]> wrote: >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? > >
