You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@spamassassin.apache.org by Mike Loiterman <mi...@ascendency.net> on 2005/11/02 02:25:36 UTC
Bayes mysql db error
FreeBSD vesion 5.4
SA version 3.1.0_3
Perl version 5.8.7
I keep getting these errors when spamd tries to work with the mysql db I
setup:
[2615] dbg: bayes: database connection established
[2615] dbg: bayes: found bayes db version 3
[2615] dbg: bayes: unable to initialize database for root user, aborting!
[2615] dbg: bayes: not scoring message, returning undef
[2615] dbg: bayes: opportunistic call attempt failed, DB not readable
I've checked that the db name, user, host, and password are correct about
1000 times. The db exists, can be logged into, the tables are there and it
seems completely functional, expcept for this error. For now, I'm using
root, so there shouldn't be any problems.
------------------------------
Mike Loiterman
grantADLER
Tel: 630-302-4944
Fax: 773-442-0992
Email: mike@ascendency.net
PGP Key: 0xD1B9D18E
Re: Bayes mysql db error
Posted by Daniel Canas <dc...@intnet.co.cr>.
On Nov 2, 2005, at 3:25 PM, Matthew S. Cramer wrote:
> On Wed, Nov 02, 2005 at 01:23:54PM -0600, Mike Loiterman wrote:
>
>> spamassassin -D --lint > debug.txt 2>&1
>>
>> [22511] dbg: bayes: database connection established
>> [22511] dbg: bayes: found bayes db version 3
>> [22511] dbg: bayes: unable to initialize database for root user,
>> aborting!
>> [22511] dbg: bayes: not scoring message, returning undef
>> [22511] dbg: bayes: opportunistic call attempt failed, DB not
>> readable
>
> Have you tried running sa-learn with a piece of mail? I run sitewide
> bayes (not per-user) in MySQL and after setting up the access and
> making the tables, my lint was failing like your's above.
>
> Doing an sa-learn to populate the tables with some data first allowed
> the lint to work without any bayes errors.
>
>
I had the exact same problem with sitewide bayes and running sa-learn
and feeding it mail also fixed the problem...
Good thing for archives, it saved me a ton of time.
Re: Bayes mysql db error
Posted by "Matthew S. Cramer" <ms...@armstrong.com>.
On Wed, Nov 02, 2005 at 01:23:54PM -0600, Mike Loiterman wrote:
> spamassassin -D --lint > debug.txt 2>&1
>
> [22511] dbg: bayes: database connection established
> [22511] dbg: bayes: found bayes db version 3
> [22511] dbg: bayes: unable to initialize database for root user, aborting!
> [22511] dbg: bayes: not scoring message, returning undef
> [22511] dbg: bayes: opportunistic call attempt failed, DB not readable
Have you tried running sa-learn with a piece of mail? I run sitewide
bayes (not per-user) in MySQL and after setting up the access and
making the tables, my lint was failing like your's above.
Doing an sa-learn to populate the tables with some data first allowed
the lint to work without any bayes errors.
Matt
--
Matthew S. Cramer <ms...@armstrong.com> Office: 717-396-5032
Project Manager, Planning and Service Management Fax: 717-396-5590
Armstrong World Industries, Inc. Cell: 717-917-7099
Re: Bayes mysql db error
Posted by Tim Rosmus <tr...@nwnexus.net>.
On Wed, 2 Nov 2005, jdow wrote:
|# On Mittwoch, 2. November 2005 15:25 Mike Loiterman wrote:
|# > 8:24:50 root@eisenhower: /home/mike]# spamassassin -D --lint >
|# > debug.txt 2>&1
|# > Ambiguous output redirect.
|#
|# Arhm - is that a Unix box? I can't imagine where that error comes from. Try
|#
It comes from attempting to use "2>&1" with csh or tcsh as the users shell.
To redirect STDERR to STDOUT under these shells, use ">&" or "|&" only.
|# spamassassin -D --lint 2>&1|cat >debug.txt
|# or
|# spamassassin -D --lint 2>&1|mail mike
|# (this last line to receive it as mail)
|#
spamassassin -D --lint >& debug.txt
or
spamassassin -D --lint |& mail mike
--
Tim Rosmus <tr...@nwnexus.net>
Postmaster / USENET / DNS
Northwest Nexus Inc. / NetOS Inc.
Re: Bayes mysql db error
Posted by jdow <jd...@earthlink.net>.
From: "Michael Monnerie" <m....@zmi.at>
On Mittwoch, 2. November 2005 15:25 Mike Loiterman wrote:
> 8:24:50 root@eisenhower: /home/mike]# spamassassin -D --lint >
> debug.txt 2>&1
> Ambiguous output redirect.
Arhm - is that a Unix box? I can't imagine where that error comes from.
Try
spamassassin -D --lint 2>&1|cat >debug.txt
or
spamassassin -D --lint 2>&1|mail mike
(this last line to receive it as mail)
mfg zmi
<< If it is a 'ix box and it is running bash the format he tried should
<< have worked. It may not work with other shells or if some bash using
<< 'ix box has modified bash so that this syntax does not work.
<< That is to say, "His way works here." (And it is what is recommended
<< in the bash documentation.
{^_^}
Re: Bayes mysql db error
Posted by Larry Starr <la...@fullcompass.com>.
On Wednesday 02 November 2005 12:02, Rick Cooper wrote:
> > -----Original Message-----
> > From: Michael Monnerie [mailto:m.monnerie@zmi.at]
> > Sent: Wednesday, November 02, 2005 12:07 PM
> > To: users@spamassassin.apache.org
> > Subject: Re: Bayes mysql db error
> >
> > On Mittwoch, 2. November 2005 15:25 Mike Loiterman wrote:
> > > 8:24:50 root@eisenhower: /home/mike]# spamassassin -D --lint >
> > > debug.txt 2>&1
> > > Ambiguous output redirect.
> >
> > Arhm - is that a Unix box? I can't imagine where that error comes from.
> > Try
> >
> > spamassassin -D --lint 2>&1|cat >debug.txt
> > or
> > spamassassin -D --lint 2>&1|mail mike
> > (this last line to receive it as mail)
>
> That is a Unix box I am sure, the ambiguity is because he is redirecting
> incorrectly. He has:
> spamassassin -D --lint > debug.txt 2>&1
>
> and debug.txt doesn't produce output to redirect stderr to stdin. He should
> use
> spamassassin -D --lint &> debug.txt
>
> one would think
>
> Rick
That depends on the Shell that he is using, the second recommendation "&>" is
correct for Csh and it's derrivatives, the first format "> file 2>&1" is
correct for Bourne Shell and it's derrivatives.
--
Larry G. Starr - larrys@fullcompass.com or starrl@globaldialog.com
Software Engineer: Full Compass Systems LTD.
Phone: 608-831-7330 x 1347 FAX: 608-831-6330
===================================================================
There are only three sports: bullfighting, mountaineering and motor
racing, all the rest are merely games! - Ernest Hemmingway
RE: Bayes mysql db error
Posted by Rick Cooper <rc...@dwford.com>.
> -----Original Message-----
> From: Michael Monnerie [mailto:m.monnerie@zmi.at]
> Sent: Wednesday, November 02, 2005 12:07 PM
> To: users@spamassassin.apache.org
> Subject: Re: Bayes mysql db error
>
>
> On Mittwoch, 2. November 2005 15:25 Mike Loiterman wrote:
> > 8:24:50 root@eisenhower: /home/mike]# spamassassin -D --lint >
> > debug.txt 2>&1
> > Ambiguous output redirect.
>
> Arhm - is that a Unix box? I can't imagine where that error comes from.
> Try
>
> spamassassin -D --lint 2>&1|cat >debug.txt
> or
> spamassassin -D --lint 2>&1|mail mike
> (this last line to receive it as mail)
>
That is a Unix box I am sure, the ambiguity is because he is redirecting
incorrectly. He has:
spamassassin -D --lint > debug.txt 2>&1
and debug.txt doesn't produce output to redirect stderr to stdin. He should
use
spamassassin -D --lint &> debug.txt
one would think
Rick
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Re: Bayes mysql db error
Posted by Michael Monnerie <m....@zmi.at>.
On Mittwoch, 2. November 2005 15:25 Mike Loiterman wrote:
> 8:24:50 root@eisenhower: /home/mike]# spamassassin -D --lint >
> debug.txt 2>&1
> Ambiguous output redirect.
Arhm - is that a Unix box? I can't imagine where that error comes from.
Try
spamassassin -D --lint 2>&1|cat >debug.txt
or
spamassassin -D --lint 2>&1|mail mike
(this last line to receive it as mail)
mfg zmi
--
// Michael Monnerie, Ing.BSc --- it-management Michael Monnerie
// http://zmi.at Tel: 0660/4156531 Linux 2.6.11
// PGP Key: "lynx -source http://zmi.at/zmi2.asc | gpg --import"
// Fingerprint: EB93 ED8A 1DCD BB6C F952 F7F4 3911 B933 7054 5879
// Keyserver: www.keyserver.net Key-ID: 0x70545879
RE: Bayes mysql db error
Posted by Mike Loiterman <mi...@ascendency.net>.
Michael Parker <ma...@pobox.com> wrote:
> Mike Loiterman wrote:
>
>> Mysql 4.1.15
>>
>> DBD 3.0002
>> DBI 1.48
>>
>> I can't get the --lint output into a file....but it doesn't say much
>> else besides what I've listed above.
>>
>>
>>
> Ahh yes, but it puts it in context which your other cut-and-paste does
> not, for instance I believe that the error is harmless.
>
> spamassassin -D --lint > debug.txt 2>&1
>
> Also, and sa-learn -u root --dump magic
>
> Which Bayes Storage engine are you using?
>
> Michael
8:24:50 root@eisenhower: /home/mike]# spamassassin -D --lint > debug.txt
2>&1
Ambiguous output redirect.
8:22:54 root@eisenhower: /home/mike/mailsort]# sa-learn -u root --dump magic
ERROR: Bayes dump returned an error, please re-run with -D for more
information
I'm using mysql...if that's what you mean wrt to a storage engine.
------------------------------
Mike Loiterman
grantADLER
Tel: 630-302-4944
Fax: 773-442-0992
Email: mike@ascendency.net
PGP Key: 0xD1B9D18E
RE: Bayes mysql db error
Posted by Mike Loiterman <mi...@ascendency.net>.
Michael Parker <ma...@pobox.com> wrote:
> Mike Loiterman wrote:
>
>> Mysql 4.1.15
>>
>> DBD 3.0002
>> DBI 1.48
>>
>> I can't get the --lint output into a file....but it doesn't say much
>> else besides what I've listed above.
>>
>>
>>
> Ahh yes, but it puts it in context which your other cut-and-paste does
> not, for instance I believe that the error is harmless.
>
> spamassassin -D --lint > debug.txt 2>&1
>
> Also, and sa-learn -u root --dump magic
>
> Which Bayes Storage engine are you using?
>
> Michael
Grrrr...pesky tcsh shell...switching back to bash for good:
spamassassin -D --lint > debug.txt 2>&1
[22511] dbg: logger: adding facilities: all
[22511] dbg: logger: logging level is DBG
[22511] dbg: generic: SpamAssassin version 3.1.0
[22511] dbg: config: score set 0 chosen.
[22511] dbg: util: running in taint mode? yes
[22511] dbg: util: taint mode: deleting unsafe environment variables,
resetting PATH
[22511] dbg: util: PATH included '/sbin', keeping
[22511] dbg: util: PATH included '/usr/sbin', keeping
[22511] dbg: util: PATH included '/bin', keeping
[22511] dbg: util: PATH included '/usr/bin', keeping
[22511] dbg: util: PATH included '/usr/local/sbin', keeping
[22511] dbg: util: PATH included '/usr/local/bin', keeping
[22511] dbg: util: PATH included '/usr/X11R6/bin', keeping
[22511] dbg: util: final PATH set to:
/sbin:/usr/sbin:/bin:/usr/bin:/usr/local/sbin:/usr/local/bin:/usr/X11R6/bin
[22511] dbg: dns: is Net::DNS::Resolver available? yes
[22511] dbg: dns: Net::DNS version: 0.53
[22511] dbg: dns: name server: 192.168.1.1, family: 2, ipv6: 0
[22511] dbg: diag: perl platform: 5.008007 freebsd
[22511] dbg: diag: module installed: Digest::SHA1, version 2.10
[22511] dbg: diag: module installed: MIME::Base64, version 3.05
[22511] dbg: diag: module installed: HTML::Parser, version 3.45
[22511] dbg: diag: module installed: DB_File, version 1.811
[22511] dbg: diag: module installed: Net::DNS, version 0.53
[22511] dbg: diag: module installed: Net::SMTP, version 2.29
[22511] dbg: diag: module installed: Mail::SPF::Query, version 1.997
[22511] dbg: diag: module not installed: IP::Country::Fast ('require'
failed)
[22511] dbg: diag: module installed: Razor2::Client::Agent, version 2.77
[22511] dbg: diag: module not installed: Net::Ident ('require' failed)
[22511] dbg: diag: module not installed: IO::Socket::INET6 ('require'
failed)
[22511] dbg: diag: module installed: IO::Socket::SSL, version 0.97
[22511] dbg: diag: module installed: Time::HiRes, version 1.66
[22511] dbg: diag: module installed: DBI, version 1.48
[22511] dbg: diag: module installed: Getopt::Long, version 2.34
[22511] dbg: diag: module not installed: LWP::UserAgent ('require' failed)
[22511] dbg: diag: module not installed: HTTP::Date ('require' failed)
[22511] dbg: diag: module not installed: Archive::Tar ('require' failed)
[22511] dbg: diag: module not installed: IO::Zlib ('require' failed)
[22511] dbg: ignore: using a test message to lint rules
[22511] dbg: config: using "/usr/local/etc/mail/spamassassin" for site rules
pre files
[22511] dbg: config: read file /usr/local/etc/mail/spamassassin/init.pre
[22511] dbg: config: read file /usr/local/etc/mail/spamassassin/v310.pre
[22511] dbg: config: using "/usr/local/share/spamassassin" for sys rules pre
files
[22511] dbg: config: using "/usr/local/share/spamassassin" for default rules
dir
[22511] dbg: config: read file /usr/local/share/spamassassin/10_misc.cf
[22511] dbg: config: read file
/usr/local/share/spamassassin/20_advance_fee.cf
[22511] dbg: config: read file
/usr/local/share/spamassassin/20_anti_ratware.cf
[22511] dbg: config: read file
/usr/local/share/spamassassin/20_body_tests.cf
[22511] dbg: config: read file
/usr/local/share/spamassassin/20_compensate.cf
[22511] dbg: config: read file
/usr/local/share/spamassassin/20_dnsbl_tests.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/20_drugs.cf
[22511] dbg: config: read file
/usr/local/share/spamassassin/20_fake_helo_tests.cf
[22511] dbg: config: read file
/usr/local/share/spamassassin/20_head_tests.cf
[22511] dbg: config: read file
/usr/local/share/spamassassin/20_html_tests.cf
[22511] dbg: config: read file
/usr/local/share/spamassassin/20_meta_tests.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/20_net_tests.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/20_phrases.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/20_porn.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/20_ratware.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/20_uri_tests.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/23_bayes.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/25_accessdb.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/25_antivirus.cf
[22511] dbg: config: read file
/usr/local/share/spamassassin/25_body_tests_es.cf
[22511] dbg: config: read file
/usr/local/share/spamassassin/25_body_tests_pl.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/25_dcc.cf
[22511] dbg: config: read file
/usr/local/share/spamassassin/25_domainkeys.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/25_hashcash.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/25_pyzor.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/25_razor2.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/25_replace.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/25_spf.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/25_textcat.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/25_uribl.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/30_text_de.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/30_text_fr.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/30_text_it.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/30_text_nl.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/30_text_pl.cf
[22511] dbg: config: read file
/usr/local/share/spamassassin/30_text_pt_br.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/50_scores.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/60_awl.cf
[22511] dbg: config: read file /usr/local/share/spamassassin/60_whitelist.cf
[22511] dbg: config: read file
/usr/local/share/spamassassin/60_whitelist_spf.cf
[22511] dbg: config: read file
/usr/local/share/spamassassin/60_whitelist_subject.cf
[22511] dbg: config: using "/usr/local/etc/mail/spamassassin" for site rules
dir
[22511] dbg: config: read file /usr/local/etc/mail/spamassassin/local.cf
[22511] dbg: config: read file /usr/local/etc/mail/spamassassin/my_rules.cf
[22511] dbg: config: using "/root/.spamassassin" for user state dir
[22511] dbg: config: using "/root/.spamassassin/user_prefs" for user prefs
file
[22511] dbg: config: read file /root/.spamassassin/user_prefs
[22511] dbg: plugin: loading Mail::SpamAssassin::Plugin::URIDNSBL from @INC
[22511] dbg: plugin: registered
Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x8e256c8)
[22511] dbg: plugin: loading Mail::SpamAssassin::Plugin::Hashcash from @INC
[22511] dbg: plugin: registered
Mail::SpamAssassin::Plugin::Hashcash=HASH(0x8e29404)
[22511] dbg: plugin: loading Mail::SpamAssassin::Plugin::SPF from @INC
[22511] dbg: plugin: registered
Mail::SpamAssassin::Plugin::SPF=HASH(0x8e5258c)
[22511] dbg: plugin: loading Mail::SpamAssassin::Plugin::Pyzor from @INC
[22511] dbg: pyzor: network tests on, attempting Pyzor
[22511] dbg: plugin: registered
Mail::SpamAssassin::Plugin::Pyzor=HASH(0x8e673a0)
[22511] dbg: plugin: loading Mail::SpamAssassin::Plugin::Razor2 from @INC
[22511] dbg: razor2: razor2 is available, version 2.77
[22511] dbg: plugin: registered
Mail::SpamAssassin::Plugin::Razor2=HASH(0x8e9391c)
[22511] dbg: plugin: loading Mail::SpamAssassin::Plugin::SpamCop from @INC
[22511] dbg: reporter: network tests on, attempting SpamCop
[22511] dbg: plugin: registered
Mail::SpamAssassin::Plugin::SpamCop=HASH(0x9028a8c)
[22511] dbg: plugin: loading Mail::SpamAssassin::Plugin::AWL from @INC
[22511] dbg: plugin: registered
Mail::SpamAssassin::Plugin::AWL=HASH(0x9043df0)
[22511] dbg: plugin: loading Mail::SpamAssassin::Plugin::AutoLearnThreshold
from @INC
[22511] dbg: plugin: registered
Mail::SpamAssassin::Plugin::AutoLearnThreshold=HASH(0x9052df0)
[22511] dbg: plugin: loading Mail::SpamAssassin::Plugin::WhiteListSubject
from @INC
[22511] dbg: plugin: registered
Mail::SpamAssassin::Plugin::WhiteListSubject=HASH(0x9061014)
[22511] dbg: plugin: loading Mail::SpamAssassin::Plugin::MIMEHeader from
@INC
[22511] dbg: plugin: registered
Mail::SpamAssassin::Plugin::MIMEHeader=HASH(0x906dc60)
[22511] dbg: plugin: loading Mail::SpamAssassin::Plugin::ReplaceTags from
@INC
[22511] dbg: plugin: registered
Mail::SpamAssassin::Plugin::ReplaceTags=HASH(0x907849c)
[22511] dbg: config: adding redirector regex:
/^http:\/\/chkpt\.zdnet\.com\/chkpt\/\w+\/(.*)$/i
[22511] dbg: config: adding redirector regex:
/^http:\/\/www(?:\d+)?\.nate\.com\/r\/\w+\/(.*)$/i
[22511] dbg: config: adding redirector regex:
/^http:\/\/.+\.gov\/(?:.*\/)?externalLink\.jhtml\?.*url=(.*?)(?:&.*)?$/i
[22511] dbg: config: adding redirector regex:
/^http:\/\/redir\.internet\.com\/.+?\/.+?\/(.*)$/i
[22511] dbg: config: adding redirector regex:
/^http:\/\/(?:.*?\.)?adtech\.de\/.*(?:;|\|)link=(.*?)(?:;|$)/i
[22511] dbg: config: adding redirector regex:
m'^http.*?/redirect\.php\?.*(?<=[?&])goto=(.*?)(?:$|[&\#])'i
[22511] dbg: config: adding redirector regex:
m'^https?:/*(?:[^/]+\.)?emf\d\.com/r\.cfm.*?&r=(.*)'i
[22511] dbg: plugin: Mail::SpamAssassin::Plugin::ReplaceTags=HASH(0x907849c)
implements 'finish_parsing_end'
[22511] dbg: replacetags: replacing tags
[22511] dbg: replacetags: done replacing tags
[22511] dbg: bayes: using username: root
[22511] dbg: bayes: database connection established
[22511] dbg: bayes: found bayes db version 3
[22511] dbg: bayes: unable to initialize database for root user, aborting!
[22511] dbg: config: score set 1 chosen.
[22511] dbg: message: ---- MIME PARSER START ----
[22511] dbg: message: main message type: text/plain
[22511] dbg: message: parsing normal part
[22511] dbg: message: added part, type: text/plain
[22511] dbg: message: ---- MIME PARSER END ----
[22511] dbg: bayes: database connection established
[22511] dbg: bayes: found bayes db version 3
[22511] dbg: bayes: unable to initialize database for root user, aborting!
[22511] dbg: dns: testing resolver nameservers: 192.168.1.1
[22511] dbg: dns: trying (3) kernel.org...
[22511] dbg: dns: looking up NS for 'kernel.org'
[22511] dbg: dns: NS lookup of kernel.org using 192.168.1.1 succeeded => DNS
available (set dns_available to override)
[22511] dbg: dns: is DNS available? 1
[22511] dbg: metadata: X-Spam-Relays-Trusted:
[22511] dbg: metadata: X-Spam-Relays-Untrusted:
[22511] dbg: message: no encoding detected
[22511] dbg: plugin: Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x8e256c8)
implements 'parsed_metadata'
[22511] dbg: uridnsbl: domains to query:
[22511] dbg: dns: checking RBL sbl-xbl.spamhaus.org., set sblxbl-notfirsthop
[22511] dbg: dns: checking RBL sa-accredit.habeas.com., set
habeas-firsttrusted
[22511] dbg: dns: checking RBL sbl-xbl.spamhaus.org., set sblxbl
[22511] dbg: dns: checking RBL sa-other.bondedsender.org., set bsp-untrusted
[22511] dbg: dns: checking RBL combined.njabl.org., set njabl-notfirsthop
[22511] dbg: dns: checking RBL combined.njabl.org., set njabl
[22511] dbg: dns: checking RBL combined-HIB.dnsiplists.completewhois.com.,
set whois
[22511] dbg: dns: checking RBL list.dsbl.org., set dsbl-notfirsthop
[22511] dbg: dns: checking RBL bl.spamcop.net., set spamcop
[22511] dbg: dns: checking RBL sa-trusted.bondedsender.org., set
bsp-firsttrusted
[22511] dbg: dns: checking RBL combined-HIB.dnsiplists.completewhois.com.,
set whois-notfirsthop
[22511] dbg: dns: checking RBL dnsbl.sorbs.net., set sorbs-notfirsthop
[22511] dbg: dns: checking RBL dnsbl.sorbs.net., set sorbs
[22511] dbg: dns: checking RBL iadb.isipp.com., set iadb-firsttrusted
[22511] dbg: check: running tests for priority: 0
[22511] dbg: rules: running header regexp tests; score so far=0
[22511] dbg: rules: ran header rule __HAS_MSGID ======> got hit: "<"
[22511] dbg: rules: ran header rule __SANE_MSGID ======> got hit:
"<11...@lint_rules>
[22511] dbg: rules: "
[22511] dbg: rules: ran header rule NO_REAL_NAME ======> got hit:
"ignore@compiling.spamassassin.taint.org
[22511] dbg: rules: "
[22511] dbg: rules: ran header rule __MSGID_OK_HOST ======> got hit:
"@lint_rules>"
[22511] dbg: rules: ran header rule __MSGID_OK_DIGITS ======> got hit:
"1130958660"
[22511] dbg: plugin: registering glue method for check_hashcash_double_spend
(Mail::SpamAssassin::Plugin::Hashcash=HASH(0x8e29404))
[22511] dbg: plugin: registering glue method for check_for_spf_helo_pass
(Mail::SpamAssassin::Plugin::SPF=HASH(0x8e5258c))
[22511] dbg: spf: message was delivered entirely via trusted relays, not
required
[22511] dbg: eval: all '*From' addrs:
ignore@compiling.spamassassin.taint.org
[22511] dbg: plugin: registering glue method for check_subject_in_blacklist
(Mail::SpamAssassin::Plugin::WhiteListSubject=HASH(0x9061014))
[22511] dbg: plugin: registering glue method for check_hashcash_value
(Mail::SpamAssassin::Plugin::Hashcash=HASH(0x8e29404))
[22511] dbg: eval: all '*To' addrs:
[22511] dbg: plugin: registering glue method for check_for_spf_neutral
(Mail::SpamAssassin::Plugin::SPF=HASH(0x8e5258c))
[22511] dbg: spf: message was delivered entirely via trusted relays, not
required
[22511] dbg: plugin: registering glue method for check_for_spf_softfail
(Mail::SpamAssassin::Plugin::SPF=HASH(0x8e5258c))
[22511] dbg: rules: ran eval rule NO_RELAYS ======> got hit
[22511] dbg: plugin: registering glue method for check_for_spf_pass
(Mail::SpamAssassin::Plugin::SPF=HASH(0x8e5258c))
[22511] dbg: plugin: registering glue method for check_for_spf_helo_softfail
(Mail::SpamAssassin::Plugin::SPF=HASH(0x8e5258c))
[22511] dbg: plugin: registering glue method for
check_for_def_spf_whitelist_from
(Mail::SpamAssassin::Plugin::SPF=HASH(0x8e5258c))
[22511] dbg: spf: cannot get Envelope-From, cannot use SPF
[22511] dbg: spf: def_spf_whitelist_from: could not find useable envelope
sender
[22511] dbg: plugin: registering glue method for check_for_spf_fail
(Mail::SpamAssassin::Plugin::SPF=HASH(0x8e5258c))
[22511] dbg: rules: ran eval rule __UNUSABLE_MSGID ======> got hit
[22511] dbg: plugin: registering glue method for check_subject_in_whitelist
(Mail::SpamAssassin::Plugin::WhiteListSubject=HASH(0x9061014))
[22511] dbg: rules: ran eval rule MISSING_HEADERS ======> got hit
[22511] dbg: plugin: registering glue method for
check_for_spf_whitelist_from
(Mail::SpamAssassin::Plugin::SPF=HASH(0x8e5258c))
[22511] dbg: spf: spf_whitelist_from: could not find useable envelope sender
[22511] dbg: rules: running body-text per-line regexp tests; score so
far=0.738
[22511] dbg: rules: ran body rule __NONEMPTY_BODY ======> got hit: "I"
[22511] dbg: uri: running uri tests; score so far=0.738
[22511] dbg: bayes: database connection established
[22511] dbg: bayes: found bayes db version 3
[22511] dbg: bayes: unable to initialize database for root user, aborting!
[22511] dbg: bayes: not scoring message, returning undef
[22511] dbg: bayes: opportunistic call attempt failed, DB not readable
[22511] dbg: plugin: registering glue method for check_uridnsbl
(Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x8e256c8))
[22511] dbg: rules: running raw-body-text per-line regexp tests; score so
far=0.738
[22511] dbg: rules: running full-text regexp tests; score so far=0.738
[22511] dbg: plugin: registering glue method for check_razor2_range
(Mail::SpamAssassin::Plugin::Razor2=HASH(0x8e9391c))
[22511] dbg: info: entering helper-app run mode
[22511] dbg: info: leaving helper-app run mode
[22511] dbg: razor2: part=0 engine=4 contested=0 confidence=0
[22511] dbg: razor2: results: spam? 0
[22511] dbg: razor2: results: engine 8, highest cf score: 0
[22511] dbg: razor2: results: engine 4, highest cf score: 0
[22511] dbg: plugin: registering glue method for check_razor2
(Mail::SpamAssassin::Plugin::Razor2=HASH(0x8e9391c))
[22511] dbg: plugin: registering glue method for check_pyzor
(Mail::SpamAssassin::Plugin::Pyzor=HASH(0x8e673a0))
[22511] dbg: util: current PATH is:
/sbin:/usr/sbin:/bin:/usr/bin:/usr/local/sbin:/usr/local/bin:/usr/X11R6/bin
[22511] dbg: pyzor: pyzor is not available: no pyzor executable found
[22511] dbg: pyzor: no pyzor found, disabling Pyzor
[22511] dbg: plugin: Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x8e256c8)
implements 'check_tick'
[22511] dbg: check: running tests for priority: 500
[22511] dbg: plugin: Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x8e256c8)
implements 'check_post_dnsbl'
[22511] dbg: rules: running meta tests; score so far=0.738
[22511] dbg: rules: running header regexp tests; score so far=2.216
[22511] dbg: rules: running body-text per-line regexp tests; score so
far=2.216
[22511] dbg: uri: running uri tests; score so far=2.216
[22511] dbg: rules: running raw-body-text per-line regexp tests; score so
far=2.216
[22511] dbg: rules: running full-text regexp tests; score so far=2.216
[22511] dbg: check: running tests for priority: 1000
[22511] dbg: rules: running meta tests; score so far=2.216
[22511] dbg: rules: running header regexp tests; score so far=2.216
[22511] dbg: plugin: registering glue method for
check_from_in_auto_whitelist
(Mail::SpamAssassin::Plugin::AWL=HASH(0x9043df0))
[22511] dbg: config: using "/root/.spamassassin" for user state dir
[22511] dbg: locker: safe_lock: created
/root/.spamassassin/auto-whitelist.mutex
[22511] dbg: locker: safe_lock: trying to get lock on
/root/.spamassassin/auto-whitelist with 30 timeout
[22511] dbg: locker: safe_lock: link to
/root/.spamassassin/auto-whitelist.mutex: link ok
[22511] dbg: auto-whitelist: tie-ing to DB file of type DB_File R/W in
/root/.spamassassin/auto-whitelist
[22511] dbg: auto-whitelist: db-based
ignore@compiling.spamassassin.taint.org|ip=none scores 0/0
[22511] dbg: auto-whitelist: AWL active, pre-score: 2.216, autolearn score:
2.216, mean: undef, IP: undef
[22511] dbg: auto-whitelist: DB addr list: untie-ing and unlocking
[22511] dbg: auto-whitelist: DB addr list: file locked, breaking lock
[22511] dbg: locker: safe_unlock: unlocked
/root/.spamassassin/auto-whitelist.mutex
[22511] dbg: auto-whitelist: post auto-whitelist score: 2.216
[22511] dbg: rules: running body-text per-line regexp tests; score so
far=2.216
[22511] dbg: uri: running uri tests; score so far=2.216
[22511] dbg: rules: running raw-body-text per-line regexp tests; score so
far=2.216
[22511] dbg: rules: running full-text regexp tests; score so far=2.216
[22511] dbg: check: is spam? score=2.216 required=5
[22511] dbg: check:
tests=MISSING_HEADERS,MISSING_SUBJECT,NO_REAL_NAME,NO_RECEIVED,NO_RELAYS,TO_
CC_NONE
[22511] dbg: check:
subtests=__HAS_MSGID,__MSGID_OK_DIGITS,__MSGID_OK_HOST,__NONEMPTY_BODY,__SAN
E_MSGID,__UNUSABLE_MSGID
------------------------------
Mike Loiterman
grantADLER
Tel: 630-302-4944
Fax: 773-442-0992
Email: mike@ascendency.net
PGP Key: 0xD1B9D18E
Re: Bayes mysql db error
Posted by Michael Parker <pa...@pobox.com>.
Mike Loiterman wrote:
>Mysql 4.1.15
>
>DBD 3.0002
>DBI 1.48
>
>I can't get the --lint output into a file....but it doesn't say much else
>besides what I've listed above.
>
>
>
Ahh yes, but it puts it in context which your other cut-and-paste does
not, for instance I believe that the error is harmless.
spamassassin -D --lint > debug.txt 2>&1
Also, and sa-learn -u root --dump magic
Which Bayes Storage engine are you using?
Michael
RE: Bayes mysql db error
Posted by Mike Loiterman <mi...@ascendency.net>.
Michael Parker <ma...@pobox.com> wrote:
> Mike Loiterman wrote:
>
>> FreeBSD vesion 5.4
>> SA version 3.1.0_3
>> Perl version 5.8.7
>>
>> I keep getting these errors when spamd tries to work with the mysql
>> db I setup:
>>
>> [2615] dbg: bayes: database connection established
>> [2615] dbg: bayes: found bayes db version 3
>> [2615] dbg: bayes: unable to initialize database for root user,
>> aborting! [2615] dbg: bayes: not scoring message, returning undef
>> [2615] dbg: bayes: opportunistic call attempt failed, DB not readable
>>
>> I've checked that the db name, user, host, and password are correct
>> about 1000 times. The db exists, can be logged into, the tables are
>> there and it seems completely functional, expcept for this error.
>> For now, I'm using root, so there shouldn't be any problems.
>>
>>
>
> Somewhat odd. You failed to mention what version of MySQL you are
> using, what version of DBI/DBD::mysql you are using, that might shed
> some light. Also, a little fuller debug, including the output from
> spamassassin -D --lint might help.
>
> Michael
Mysql 4.1.15
DBD 3.0002
DBI 1.48
I can't get the --lint output into a file....but it doesn't say much else
besides what I've listed above.
I am so frustrated. I can't get anything to work. I've been wrestling with
this all night. Grrrrrr.
------------------------------
Mike Loiterman
grantADLER
Tel: 630-302-4944
Fax: 773-442-0992
Email: mike@ascendency.net
PGP Key: 0xD1B9D18E
Re: Bayes mysql db error
Posted by Michael Parker <pa...@pobox.com>.
Mike Loiterman wrote:
>FreeBSD vesion 5.4
>SA version 3.1.0_3
>Perl version 5.8.7
>
>I keep getting these errors when spamd tries to work with the mysql db I
>setup:
>
> [2615] dbg: bayes: database connection established
> [2615] dbg: bayes: found bayes db version 3
> [2615] dbg: bayes: unable to initialize database for root user, aborting!
> [2615] dbg: bayes: not scoring message, returning undef
> [2615] dbg: bayes: opportunistic call attempt failed, DB not readable
>
>I've checked that the db name, user, host, and password are correct about
>1000 times. The db exists, can be logged into, the tables are there and it
>seems completely functional, expcept for this error. For now, I'm using
>root, so there shouldn't be any problems.
>
>
Somewhat odd. You failed to mention what version of MySQL you are
using, what version of DBI/DBD::mysql you are using, that might shed
some light. Also, a little fuller debug, including the output from
spamassassin -D --lint might help.
Michael