SA 3.0 + MailScanner Bayes issue!

[Michele Neylon :: Blacknight Solutions]

Michael Freeman wrote:
> We are running Cpanel + MailScanner (Latest) Spamassasin.  Until last
> night, our SA was version 2.64. After latest nights Cpanel update we
> are now running SA3.0. We can always reply on wonderful Cpanel to
> mess with peoples installation but anyway. We seem to be having a
> Bayes issue now.  Everytime the Bayes db is queried; there is a
> noticeable error in the logs.     
> 
> 5.8.1/Mail/SpamAssassin/BayesStore/DBM.pm line 160.
> 
> Sep 22 17:34:06 srv05 spamd[15099]: processing message
> <17a04e01c4a0ed$e0845a00$a2d9ebd1 at allposters1> for plush:32050. 
> 
> Sep 22 17:34:06 srv05 spamd[15099]: bayes: bayes db version 2 is not
> able to be used, aborting! at
> /usr/lib/perl5/site_perl/5.8.1/Mail/SpamAssassin/BayesStore/DBM.pm
> line 160, <GEN53> line 132.   
> 
> Sep 22 17:34:08 srv05 spamd[15099]: Subroutine
> SARE_HTML_URI_DEFASP_uri_test redefined at
> /etc/mail/spamassassin/70_sare_html.cf, rule SARE_HTML_URI_DEFASP,
> line 5, <GEN53> line 132.   
> 
> Sep 22 17:34:08 srv05 spamd[15099]: Subroutine PORN_URL_SLUT_uri_test
> redefined at /usr/share/spamassassin/20_porn.cf, rule PORN_URL_SLUT,
> line 10, <GEN53> line 132.  
> 
> Sep 22 17:34:08 srv05 spamd[15099]: Subroutine
> SARE_HTML_URI_LHOST30_uri_test redefined at
> /etc/mail/spamassassin/70_sare_html.cf, rule SARE_HTML_URI_LHOST30,
> line 10, <GEN53> line 132.   
> 
> Sep 22 17:34:08 srv05 spamd[15099]: Subroutine USERPASS_uri_test
> redefined at /usr/share/spamassassin/20_uri_tests.cf, rule USERPASS,
> line 10, <GEN53> line 132.  
> 
> Sep 22 17:34:08 srv05 spamd[15099]: Subroutine __URI_PAYPAL_uri_test
> redefined at /etc/mail/spamassassin/70_sare_spoof.cf, rule
> __URI_PAYPAL, line 10, <GEN53> line 132.  
> 
> Sep 22 17:34:08 srv05 spamd[15099]: Subroutine
> SARE_HTML_URI_OPTPHP_uri_test redefined at
> /etc/mail/spamassassin/70_sare_html.cf, rule SARE_HTML_URI_OPTPHP,
> line 10, <GEN53> line 132.   
> 
> Sep 22 17:34:08 srv05 spamd[15099]: Subroutine
> MAILTO_TO_SPAM_ADDR_uri_test redefined at
> /usr/share/spamassassin/20_uri_tests.cf, rule MAILTO_TO_SPAM_ADDR,
> line 10, <GEN53> line 132.   
> 
> Sep 22 17:34:08 srv05 spamd[15099]: Failed to compile URI
> SpamAssassin tests, skipping:__(syntax error at
> /etc/mail/spamassassin/spamcop_uri.cf, rule AB_URI_RBL, line 1, near
> "eval:"_syntax error at /etc/mail/spamassassin/spamcop_uri.cf, rule
> WS_URI_RBL, line 1, near "eval:"_syntax error at
> /etc/mail/spamassassin/spamcop_uri.cf, rule WS_URI_RBL, line 8, near
> "}_    }"_)      
> 
> Sep 22 17:34:09 srv05 spamd[15099]: clean message (1.2/5.0) for
> plush:32050 in 4.6 seconds, 4886 bytes. 
> 
> Sep 22 17:34:09 srv05 spamd[15099]: result: .  1 -
> FORGED_RCVD_HELO,HTML_MESSAGE,MIME_HTML_ONLY
>
scantime=4.6,size=4886,mid=<17a04e01c4a0ed$e0845a00$a2d9ebd1 at allposters1>,au
tolearn=no
> 
> Does this mean I have to reinstall a new copy of the Bayes DB just
> because of the upgrade? If so, how do we refresh the db? 

SA3's Bayes format is NOT compatible with the older version's Bayes' DB. 
You need to convert the old DB before you upgrade. If you haven't, which is
your case, then you will need to remove all the bayes entries and start
again

You will also need to remove all the custom rulesets as they are either
included in SA3 or are not compatible.

This is all documented in the INSTALL and UPGRADE files 

Mr Michele Neylon
Blacknight Internet Solutions Ltd
Hosting, co-location & domains
http://www.blacknight.ie/
Tel. +353 59 9137101

------------------------ MailScanner list ------------------------
To unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
'leave mailscanner' in the body of the email.
Before posting, read the MAQ (http://www.mailscanner.biz/maq/) and
the archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).