Re: Bayes mysql db error
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 21 [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
Mike Loiterman wrote: Mysql 4.1.15 DBD 3.0002 DBI 1.48 I can't get the --lint output into a filebut 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 21 Also, and sa-learn -u root --dump magic Which Bayes Storage engine are you using? Michael signature.asc Description: OpenPGP digital signature
RE: Bayes mysql db error
Michael Parker mailto:[EMAIL PROTECTED] wrote: Mike Loiterman wrote: Mysql 4.1.15 DBD 3.0002 DBI 1.48 I can't get the --lint output into a filebut 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 21 Also, and sa-learn -u root --dump magic Which Bayes Storage engine are you using? Michael 8:24:50 [EMAIL PROTECTED]: /home/mike]# spamassassin -D --lint debug.txt 21 Ambiguous output redirect. 8:22:54 [EMAIL PROTECTED]: /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: [EMAIL PROTECTED] PGP Key: 0xD1B9D18E
Re: Bayes mysql db error
On Mittwoch, 2. November 2005 15:25 Mike Loiterman wrote: 8:24:50 [EMAIL PROTECTED]: /home/mike]# spamassassin -D --lint debug.txt 21 Ambiguous output redirect. Arhm - is that a Unix box? I can't imagine where that error comes from. Try spamassassin -D --lint 21|cat debug.txt or spamassassin -D --lint 21|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
On Wednesday 02 November 2005 12:02, Rick Cooper wrote: -Original Message- From: Michael Monnerie [mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED]: /home/mike]# spamassassin -D --lint debug.txt 21 Ambiguous output redirect. Arhm - is that a Unix box? I can't imagine where that error comes from. Try spamassassin -D --lint 21|cat debug.txt or spamassassin -D --lint 21|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 21 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 21 is correct for Bourne Shell and it's derrivatives. -- Larry G. Starr - [EMAIL PROTECTED] or [EMAIL PROTECTED] 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
Michael Parker mailto:[EMAIL PROTECTED] wrote:
Mike Loiterman wrote:
Mysql 4.1.15
DBD 3.0002
DBI 1.48
I can't get the --lint output into a filebut 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 21
Also, and sa-learn -u root --dump magic
Which Bayes Storage engine are you using?
Michael
G...pesky tcsh shell...switching back to bash for good:
spamassassin -D --lint debug.txt 21
[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
Re: Bayes mysql db error
From: Michael Monnerie [EMAIL PROTECTED]
On Mittwoch, 2. November 2005 15:25 Mike Loiterman wrote:
8:24:50 [EMAIL PROTECTED]: /home/mike]# spamassassin -D --lint
debug.txt 21
Ambiguous output redirect.
Arhm - is that a Unix box? I can't imagine where that error comes from.
Try
spamassassin -D --lint 21|cat debug.txt
or
spamassassin -D --lint 21|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
On Wed, 2 Nov 2005, jdow wrote: |# On Mittwoch, 2. November 2005 15:25 Mike Loiterman wrote: |# 8:24:50 [EMAIL PROTECTED]: /home/mike]# spamassassin -D --lint |# debug.txt 21 |# 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 21 with csh or tcsh as the users shell. To redirect STDERR to STDOUT under these shells, use or | only. |# spamassassin -D --lint 21|cat debug.txt |# or |# spamassassin -D --lint 21|mail mike |# (this last line to receive it as mail) |# spamassassin -D --lint debug.txt or spamassassin -D --lint | mail mike -- Tim Rosmus [EMAIL PROTECTED] Postmaster / USENET / DNS Northwest Nexus Inc. / NetOS Inc.
Re: Bayes mysql db error
On Wed, Nov 02, 2005 at 01:23:54PM -0600, Mike Loiterman wrote: spamassassin -D --lint debug.txt 21 [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 [EMAIL PROTECTED] Office: 717-396-5032 Project Manager, Planning and Service ManagementFax:717-396-5590 Armstrong World Industries, Inc.Cell: 717-917-7099
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: [EMAIL PROTECTED] PGP Key: 0xD1B9D18E
Re: Bayes mysql db error
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 signature.asc Description: OpenPGP digital signature
RE: Bayes mysql db error
Michael Parker mailto:[EMAIL PROTECTED] 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 filebut 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. Grr. -- Mike Loiterman grantADLER Tel: 630-302-4944 Fax: 773-442-0992 Email: [EMAIL PROTECTED] PGP Key: 0xD1B9D18E
