Running on freebsd 6.0
Having problems getting 3.1.1 to work with mysql based bayes.
Please see the sa-learn -D --sync result
mail-av1# sa-learn -D --sync
[25988] dbg: logger: adding facilities: all
[25988] dbg: logger: logging level is DBG
[25988] dbg: generic: SpamAssassin version 3.1.1
[25988] dbg: config: score set 0 chosen.
[25988] dbg: util: running in taint mode? yes
[25988] dbg: util: taint mode: deleting unsafe environment variables,
resetting PATH
[25988] dbg: util: PATH included '/sbin', keeping
[25988] dbg: util: PATH included '/bin', keeping
[25988] dbg: util: PATH included '/usr/sbin', keeping
[25988] dbg: util: PATH included '/usr/bin', keeping
[25988] dbg: util: PATH included '/usr/games', keeping
[25988] dbg: util: PATH included '/usr/local/sbin', keeping
[25988] dbg: util: PATH included '/usr/local/bin', keeping
[25988] dbg: util: PATH included '/usr/X11R6/bin', which doesn't exist,
dropping
[25988] dbg: util: PATH included '/root/bin', which doesn't exist, dropping
[25988] dbg: util: final PATH set to:
/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr/local/bin
[25988] dbg: dns: is Net::DNS::Resolver available? yes
[25988] dbg: dns: Net::DNS version: 0.55
[25988] dbg: config: using "/usr/local/etc/mail/spamassassin" for site rules
pre files
[25988] dbg: config: read file /usr/local/etc/mail/spamassassin/init.pre
[25988] dbg: config: read file /usr/local/etc/mail/spamassassin/v310.pre
[25988] dbg: config: using "/usr/local/share/spamassassin" for sys rules pre
files
[25988] dbg: config: using "/usr/local/share/spamassassin" for default rules
dir
[25988] dbg: config: read file /usr/local/share/spamassassin/10_misc.cf
[25988] dbg: config: read file
/usr/local/share/spamassassin/20_advance_fee.cf
[25988] dbg: config: read file
/usr/local/share/spamassassin/20_anti_ratware.cf
[25988] dbg: config: read file
/usr/local/share/spamassassin/20_body_tests.cf
[25988] dbg: config: read file
/usr/local/share/spamassassin/20_compensate.cf
[25988] dbg: config: read file
/usr/local/share/spamassassin/20_dnsbl_tests.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/20_drugs.cf
[25988] dbg: config: read file
/usr/local/share/spamassassin/20_fake_helo_tests.cf
[25988] dbg: config: read file
/usr/local/share/spamassassin/20_head_tests.cf
[25988] dbg: config: read file
/usr/local/share/spamassassin/20_html_tests.cf
[25988] dbg: config: read file
/usr/local/share/spamassassin/20_meta_tests.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/20_net_tests.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/20_phrases.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/20_porn.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/20_ratware.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/20_uri_tests.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/23_bayes.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/25_accessdb.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/25_antivirus.cf
[25988] dbg: config: read file
/usr/local/share/spamassassin/25_body_tests_es.cf
[25988] dbg: config: read file
/usr/local/share/spamassassin/25_body_tests_pl.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/25_dcc.cf
[25988] dbg: config: read file
/usr/local/share/spamassassin/25_domainkeys.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/25_hashcash.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/25_pyzor.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/25_razor2.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/25_replace.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/25_spf.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/25_textcat.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/25_uribl.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/30_text_de.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/30_text_fr.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/30_text_it.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/30_text_nl.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/30_text_pl.cf
[25988] dbg: config: read file
/usr/local/share/spamassassin/30_text_pt_br.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/50_scores.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/60_awl.cf
[25988] dbg: config: read file /usr/local/share/spamassassin/60_whitelist.cf
[25988] dbg: config: read file
/usr/local/share/spamassassin/60_whitelist_spf.cf
[25988] dbg: config: read file
/usr/local/share/spamassassin/60_whitelist_subject.cf
[25988] dbg: config: using "/usr/local/etc/mail/spamassassin" for site rules
dir
[25988] dbg: config: read file /usr/local/etc/mail/spamassassin/local.cf
[25988] dbg: config: using "/root/.spamassassin/user_prefs" for user prefs
file
[25988] dbg: config: read file /root/.spamassassin/user_prefs
[25988] dbg: plugin: loading Mail::SpamAssassin::Plugin::URIDNSBL from @INC
[25988] dbg: plugin: registered
Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x8a1f874)
[25988] dbg: plugin: loading Mail::SpamAssassin::Plugin::Hashcash from @INC
[25988] dbg: plugin: registered
Mail::SpamAssassin::Plugin::Hashcash=HASH(0x8aa45b0)
[25988] dbg: plugin: loading Mail::SpamAssassin::Plugin::Pyzor from @INC
[25988] dbg: pyzor: network tests on, attempting Pyzor
[25988] dbg: plugin: registered
Mail::SpamAssassin::Plugin::Pyzor=HASH(0x8a31ad8)
[25988] dbg: plugin: loading Mail::SpamAssassin::Plugin::SpamCop from @INC
[25988] dbg: reporter: network tests on, attempting SpamCop
[25988] dbg: plugin: registered
Mail::SpamAssassin::Plugin::SpamCop=HASH(0x8c5abc4)
[25988] dbg: plugin: loading Mail::SpamAssassin::Plugin::AWL from @INC
[25988] dbg: plugin: registered
Mail::SpamAssassin::Plugin::AWL=HASH(0x8c74728)
[25988] dbg: plugin: loading Mail::SpamAssassin::Plugin::AutoLearnThreshold
from @INC
[25988] dbg: plugin: registered
Mail::SpamAssassin::Plugin::AutoLearnThreshold=HASH(0x8c7e728)
[25988] dbg: plugin: loading Mail::SpamAssassin::Plugin::WhiteListSubject
from @INC
[25988] dbg: plugin: registered
Mail::SpamAssassin::Plugin::WhiteListSubject=HASH(0x8c88164)
[25988] dbg: plugin: loading Mail::SpamAssassin::Plugin::MIMEHeader from
@INC
[25988] dbg: plugin: registered
Mail::SpamAssassin::Plugin::MIMEHeader=HASH(0x8db7db0)
[25988] dbg: plugin: loading Mail::SpamAssassin::Plugin::ReplaceTags from
@INC
[25988] dbg: plugin: registered
Mail::SpamAssassin::Plugin::ReplaceTags=HASH(0x8dc7e04)
[25988] dbg: config: adding redirector regex:
/^http:\/\/chkpt\.zdnet\.com\/chkpt\/\w+\/(.*)$/i
[25988] dbg: config: adding redirector regex:
/^http:\/\/www(?:\d+)?\.nate\.com\/r\/\w+\/(.*)$/i
[25988] dbg: config: adding redirector regex:
/^http:\/\/.+\.gov\/(?:.*\/)?externalLink\.jhtml\?.*url=(.*?)(?:&.*)?$/i
[25988] dbg: config: adding redirector regex:
/^http:\/\/redir\.internet\.com\/.+?\/.+?\/(.*)$/i
[25988] dbg: config: adding redirector regex:
/^http:\/\/(?:.*?\.)?adtech\.de\/.*(?:;|\|)link=(.*?)(?:;|$)/i
[25988] dbg: config: adding redirector regex:
m'^http.*?/redirect\.php\?.*(?<=[?&])goto=(.*?)(?:$|[&\#])'i
[25988] dbg: config: adding redirector regex:
m'^https?:/*(?:[^/]+\.)?emf\d\.com/r\.cfm.*?&r=(.*)'i
[25988] dbg: config: adding redirector regex:
m'/(?:index.php)?\?.*(?<=[?&])URL=(.*?)(?:$|[&\#])'i
[25988] dbg: config: adding redirector regex:
m'^http:/*(?:\w+\.)?google(?:\.\w{2,3}){1,2}/url\?.*?(?<=[?&])q=(.*?)(?:$|[&
\#])'i
[25988] dbg: config: adding redirector regex:
m'^http:/*(?:\w+\.)?google(?:\.\w{2,3}){1,2}/search\?.*?(?<=[?&])q=[^&]*?(?<
=%20|..[=+\s])site:(.*?)(?:$|%20|[\s+&\#])'i
[25988] dbg: config: adding redirector regex:
m'^http:/*(?:\w+\.)?google(?:\.\w{2,3}){1,2}/search\?.*?(?<=[?&])q=[^&]*?(?<
=%20|..[=+\s])(?:"|%22)(.*?)(?:$|%22|["\s+&\#])'i
[25988] dbg: config: adding redirector regex:
m'^http:/*(?:\w+\.)?google(?:\.\w{2,3}){1,2}/translate\?.*?(?<=[?&])u=(.*?)(
?:$|[&\#])'i
[25988] dbg: plugin: loading Mail::SpamAssassin::Plugin::DBI from
/usr/local/etc/mail/spamassassin/DBI.pm
[25988] dbg: plugin: registered
Mail::SpamAssassin::Plugin::DBI=HASH(0x8e5a088)
[25988] dbg: plugin: Mail::SpamAssassin::Plugin::ReplaceTags=HASH(0x8dc7e04)
implements 'finish_parsing_end'
[25988] dbg: replacetags: replacing tags
[25988] dbg: replacetags: done replacing tags
[25988] dbg: bayes: using username: root
[25988] dbg: dbiplugin: Creating uncached database handle to
'spamass:mail-db2_spamass_XjSVFjLa_AutoCommit=0_PrintError=0_Username=spamas
s'
[25988] dbg: bayes: database connection established
Use of uninitialized value in concatenation (.) or string at
/usr/local/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/BayesStore/SQL.pm
line 132.
[25988] dbg: bayes: found bayes db version
Use of uninitialized value in numeric ne (!=) at
/usr/local/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/BayesStore/SQL.pm
line 134.
Use of uninitialized value in concatenation (.) or string at
/usr/local/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/BayesStore/SQL.pm
line 135.
bayes: database version is different than we understand (3), aborting! at
/usr/local/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/BayesStore/SQL.pm
line 135.
[25988] dbg: config: score set 1 chosen.
[25988] dbg: learn: initializing learner
[25988] dbg: bayes: bayes journal sync starting
[25988] dbg: bayes: bayes journal sync completed
[25988] dbg: bayes: expiry starting
[25988] dbg: dbiplugin: Creating uncached database handle to
'spamass:mail-db2_spamass_XjSVFjLa_AutoCommit=0_PrintError=0_Username=spamas
s'
[25988] dbg: bayes: database connection established
Use of uninitialized value in concatenation (.) or string at
/usr/local/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/BayesStore/SQL.pm
line 179.
[25988] dbg: bayes: found bayes db version
Use of uninitialized value in numeric ne (!=) at
/usr/local/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/BayesStore/SQL.pm
line 181.
Use of uninitialized value in concatenation (.) or string at
/usr/local/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/BayesStore/SQL.pm
line 182.
bayes: database version is different than we understand (3), aborting! at
/usr/local/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/BayesStore/SQL.pm
line 182.
[25988] dbg: bayes: expiry completed
I will continue to check my setup. I have not encounter this problem
before.
Thanks.
