spamassassin global database

[Red Squirrel]

I moved the spamassassin global database to /data/misc/bayesdb that way it actually gets backed up more often then when it was in /etc/mail/spamassassin which is the default location. How do I tell spamassassin to use it? since I've done that I get more spam since its not reading that database anymore. My bayes learn script works fine as it specifies that path. There's got to be some kind of main.cf line I can use. bayes_path does not work.

 

[corkyg]

I let my ISP handle that - they use Can-It by RoaringPenguin, which in turn bases Can-It on Spamassassin. You might find a clue in their support files:

Can-It

 

[Nothinman]

In Debian the default setting is "bayes_path /var/spool/spamassassin/bayes" in local.cf and it does indeed use the database at that path, if it's not working for you then you've messed something else up.

 

[Red Squirrel]

I read you need to use a ~/ type path for that command because of some security thing... basically its forcing you to have 1 DB per user, which imo is stupid, spam is spam, I only want to mark it once globally, not once per account. When I do a spamassassin --lint I get an error that its invalid. This is on FC5.

 

[cleverhandle]

Originally posted by: RedSquirrel
basically its forcing you to have 1 DB per user, which imo is stupid, spam is spam, I only want to mark it once globally, not once per account.

There are numerous mentions online of people using a global bayes database, so I tend to think that you've misconfigured something or are not understanding something. I'm guessing that the problem lies with permissions. Note in particular that running spamassassin as a script works in slightly different ways than running spamd as a daemon as far as privileges are concerned.

 

[Nothinman]

I read you need to use a ~/ type path for that command because of some security thing... basically its forcing you to have 1 DB per user, which imo is stupid, spam is spam, I only want to mark it once globally, not once per account. When I do a spamassassin --lint I get an error that its invalid. This is on FC5.

Well I would guess that whatever you read is wrong, as I said before I switched to an SQL database I had my bayes database in a flatfile at /var/spool/spamassassin/bayes and it worked fine. Of course permissions might end up being an issue, SVN is similar and can be a real PITA to get permissions right.

 

[Red Squirrel]

Well it worked fine when it was in the /etc/mail/spamassassin/bayesdbfolder but I moved it since I dont want it there, so I need to tell SA to look in the new location.

And other people seem to have issues with bayes_path. I think thats just for the per user one, so it wants a ~ path. My configuration is spamc/spamd, but the script that runs every now and then simply uses bayes-learn to learn all the mailboxes to the specified database. That command works fine, and the DB is populated, I just need to tell SA where it is, since its looking in /etc/mail/spamassassin/bayesdb.

http://www.mail-archive.com/users@spamassassin.apache.org/msg17703.html

 

[cleverhandle]

Originally posted by: RedSquirrel
And other people seem to have issues with bayes_path. I think thats just for the per user one, so it wants a ~ path...

http://www.mail-archive.com/users@spamassassin.apache.org/msg17703.html

You're hearing what you want to hear, not what's on the page. That link is pointing out that spamd (which may run as root) will not read user-specified paths. Spamassassin and sa-learn, which run with privileges of the caller, will read those paths. Are you setting a bayes_path in local.cf ? That's where spamd is going to read it from.

 

[Nothinman]

Yea, that message says that spamd will ignore bayes_path in the user's config file when the administrator has set bayes_path in the global local.cf, not that it doesn't work at all.

 

[Red Squirrel]

odd, since I'm getting that same error if I try to use that in local.cf.

[22413] warn: config: SpamAssassin failed to parse line, "/data/misc/bayesdb" is not valid for "bayes_path", skipping: bayes_path /data/misc/bayesdb

That path is valid, and the database is valid since sa-learn can read/write to it fine. But during the actual spam checking process, its not wanting to use the bayes_path option, so it does not know where the db is. Its still looking in /etc/mail/spamassassin which is the default location.

[root@borg spamassassin]# sa-learn --dump magic --dbpath /data/misc/bayesdb
0.000          0          3          0  non-token data: bayes db version
0.000          0        270          0  non-token data: nspam
0.000          0        953          0  non-token data: nham
0.000          0      70928          0  non-token data: ntokens
0.000          0 1101963600          0  non-token data: oldest atime
0.000          0 1157141708          0  non-token data: newest atime
0.000          0          0          0  non-token data: last journal sync atime
0.000          0          0          0  non-token data: last expiry atime
0.000          0          0          0  non-token data: last expire atime delta
0.000          0          0          0  non-token data: last expire reduction count
[root@borg spamassassin]#

This is the entire output, perhaps something else is wrong, causing me this issue.

[root@borg spamassassin]# spamassassin -D --lint
[22413] dbg: logger: adding facilities: all
[22413] dbg: logger: logging level is DBG
[22413] dbg: generic: SpamAssassin version 3.1.0
[22413] dbg: config: score set 0 chosen.
[22413] dbg: util: running in taint mode? yes
[22413] dbg: util: taint mode: deleting unsafe environment variables, resetting PATH
[22413] dbg: util: PATH included '/usr/kerberos/sbin', keeping
[22413] dbg: util: PATH included '/usr/kerberos/bin', keeping
[22413] dbg: util: PATH included '/usr/local/sbin', keeping
[22413] dbg: util: PATH included '/usr/local/bin', keeping
[22413] dbg: util: PATH included '/sbin', keeping
[22413] dbg: util: PATH included '/bin', keeping
[22413] dbg: util: PATH included '/usr/sbin', keeping
[22413] dbg: util: PATH included '/usr/bin', keeping
[22413] dbg: util: PATH included '/root/bin', which doesn't exist, dropping
[22413] dbg: util: final PATH set to: /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
[22413] dbg: dns: is Net::DNS::Resolver available? yes
[22413] dbg: dns: Net::DNS version: 0.55
[22413] dbg: dns: name server: 10.1.1.10, family: 2, ipv6: 0
[22413] dbg: diag: perl platform: 5.008008 linux
[22413] dbg: diag: module installed: Digest::SHA1, version 2.11
[22413] dbg: diag: module not installed: Mail::SPF::Query ('require' failed)
[22413] dbg: diag: module not installed: IP::Country::Fast ('require' failed)
[22413] dbg: diag: module not installed: Razor2::Client::Agent ('require' failed)
[22413] dbg: diag: module not installed: Net::Ident ('require' failed)
[22413] dbg: diag: module not installed: IO::Socket::INET6 ('require' failed)
[22413] dbg: diag: module not installed: IO::Socket::SSL ('require' failed)
[22413] dbg: diag: module installed: Time::HiRes, version 1.86
[22413] dbg: diag: module installed: HTML::Parser, version 3.50
[22413] dbg: diag: module installed: MIME::Base64, version 3.07
[22413] dbg: diag: module installed: DB_File, version 1.814
[22413] dbg: diag: module installed: Net::DNS, version 0.55
[22413] dbg: diag: module installed: Net::SMTP, version 2.29
[22413] dbg: diag: module installed: DBI, version 1.50
[22413] dbg: diag: module installed: Getopt::Long, version 2.35
[22413] dbg: diag: module installed: LWP::UserAgent, version 2.033
[22413] dbg: diag: module installed: HTTP::Date, version 1.47
[22413] dbg: diag: module not installed: Archive::Tar ('require' failed)
[22413] dbg: diag: module not installed: IO::Zlib ('require' failed)
[22413] dbg: ignore: using a test message to lint rules
[22413] dbg: config: using "/etc/mail/spamassassin" for site rules pre files
[22413] dbg: config: read file /etc/mail/spamassassin/init.pre
[22413] dbg: config: read file /etc/mail/spamassassin/v310.pre
[22413] dbg: config: using "/usr/share/spamassassin" for sys rules pre files
[22413] dbg: config: using "/usr/share/spamassassin" for default rules dir
[22413] dbg: config: read file /usr/share/spamassassin/10_misc.cf
[22413] dbg: config: read file /usr/share/spamassassin/20_advance_fee.cf
[22413] dbg: config: read file /usr/share/spamassassin/20_anti_ratware.cf
[22413] dbg: config: read file /usr/share/spamassassin/20_body_tests.cf
[22413] dbg: config: read file /usr/share/spamassassin/20_compensate.cf
[22413] dbg: config: read file /usr/share/spamassassin/20_dnsbl_tests.cf
[22413] dbg: config: read file /usr/share/spamassassin/20_drugs.cf
[22413] dbg: config: read file /usr/share/spamassassin/20_fake_helo_tests.cf
[22413] dbg: config: read file /usr/share/spamassassin/20_head_tests.cf
[22413] dbg: config: read file /usr/share/spamassassin/20_html_tests.cf
[22413] dbg: config: read file /usr/share/spamassassin/20_meta_tests.cf
[22413] dbg: config: read file /usr/share/spamassassin/20_net_tests.cf
[22413] dbg: config: read file /usr/share/spamassassin/20_phrases.cf
[22413] dbg: config: read file /usr/share/spamassassin/20_porn.cf
[22413] dbg: config: read file /usr/share/spamassassin/20_ratware.cf
[22413] dbg: config: read file /usr/share/spamassassin/20_uri_tests.cf
[22413] dbg: config: read file /usr/share/spamassassin/23_bayes.cf
[22413] dbg: config: read file /usr/share/spamassassin/25_accessdb.cf
[22413] dbg: config: read file /usr/share/spamassassin/25_antivirus.cf
[22413] dbg: config: read file /usr/share/spamassassin/25_body_tests_es.cf
[22413] dbg: config: read file /usr/share/spamassassin/25_body_tests_pl.cf
[22413] dbg: config: read file /usr/share/spamassassin/25_dcc.cf
[22413] dbg: config: read file /usr/share/spamassassin/25_domainkeys.cf
[22413] dbg: config: read file /usr/share/spamassassin/25_hashcash.cf
[22413] dbg: config: read file /usr/share/spamassassin/25_pyzor.cf
[22413] dbg: config: read file /usr/share/spamassassin/25_razor2.cf
[22413] dbg: config: read file /usr/share/spamassassin/25_replace.cf
[22413] dbg: config: read file /usr/share/spamassassin/25_spf.cf
[22413] dbg: config: read file /usr/share/spamassassin/25_textcat.cf
[22413] dbg: config: read file /usr/share/spamassassin/25_uribl.cf
[22413] dbg: config: read file /usr/share/spamassassin/30_text_de.cf
[22413] dbg: config: read file /usr/share/spamassassin/30_text_fr.cf
[22413] dbg: config: read file /usr/share/spamassassin/30_text_it.cf
[22413] dbg: config: read file /usr/share/spamassassin/30_text_nl.cf
[22413] dbg: config: read file /usr/share/spamassassin/30_text_pl.cf
[22413] dbg: config: read file /usr/share/spamassassin/30_text_pt_br.cf
[22413] dbg: config: read file /usr/share/spamassassin/50_scores.cf
[22413] dbg: config: read file /usr/share/spamassassin/60_awl.cf
[22413] dbg: config: read file /usr/share/spamassassin/60_whitelist.cf
[22413] dbg: config: read file /usr/share/spamassassin/60_whitelist_spf.cf
[22413] dbg: config: read file /usr/share/spamassassin/60_whitelist_subject.cf
[22413] dbg: config: using "/etc/mail/spamassassin" for site rules dir
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_adult.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_bayes_poison_nxm.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_evilnum0.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_evilnum1.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_evilnum2.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_genlsubj3.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_header.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_header_eng.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_highrisk.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_html.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_html2.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_obfu.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_obfu0.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_obfu1.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_obfu2.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_obfu3.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_obfu4.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_random.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_specific.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_spoof.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_unsub.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sare_uri_eng.cf
[22413] dbg: config: read file /etc/mail/spamassassin/70_sc_top200.cf
[22413] dbg: config: read file /etc/mail/spamassassin/71_sare_bml_pre25x.cf
[22413] dbg: config: read file /etc/mail/spamassassin/71_sare_redirect_pre3.0.0.cf
[22413] dbg: config: read file /etc/mail/spamassassin/72_sare_bml_post25x.cf
[22413] dbg: config: read file /etc/mail/spamassassin/99_sare_fraud_post25x.cf
[22413] dbg: config: read file /etc/mail/spamassassin/99_sare_fraud_pre25x.cf
[22413] dbg: config: read file /etc/mail/spamassassin/autogen.cf
[22413] dbg: config: read file /etc/mail/spamassassin/customrules.cf
[22413] dbg: config: read file /etc/mail/spamassassin/evilnumbers_sept04.cf
[22413] dbg: config: read file /etc/mail/spamassassin/local.cf
[22413] dbg: config: using "/root/.spamassassin" for user state dir
[22413] dbg: config: using "/root/.spamassassin/user_prefs" for user prefs file
[22413] dbg: config: read file /root/.spamassassin/user_prefs
[22413] dbg: plugin: loading Mail::SpamAssassin::Plugin::URIDNSBL from @INC
[22413] dbg: plugin: registered Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x9f55890)
[22413] dbg: plugin: loading Mail::SpamAssassin::Plugin::Hashcash from @INC
[22413] dbg: plugin: registered Mail::SpamAssassin::Plugin::Hashcash=HASH(0xab79524)
[22413] dbg: plugin: loading Mail::SpamAssassin::Plugin::SPF from @INC
[22413] dbg: plugin: registered Mail::SpamAssassin::Plugin::SPF=HASH(0xab48884)
[22413] dbg: plugin: loading Mail::SpamAssassin::Plugin::Pyzor from @INC
[22413] dbg: pyzor: network tests on, attempting Pyzor
[22413] dbg: plugin: registered Mail::SpamAssassin::Plugin::Pyzor=HASH(0xabcb1f4)
[22413] dbg: plugin: loading Mail::SpamAssassin::Plugin::SpamCop from @INC
[22413] dbg: reporter: network tests on, attempting SpamCop
[22413] dbg: plugin: registered Mail::SpamAssassin::Plugin::SpamCop=HASH(0xab9cb94)
[22413] dbg: plugin: loading Mail::SpamAssassin::Plugin::AWL from @INC
[22413] dbg: plugin: registered Mail::SpamAssassin::Plugin::AWL=HASH(0xab9f60c)
[22413] dbg: plugin: loading Mail::SpamAssassin::Plugin::AutoLearnThreshold from @INC
[22413] dbg: plugin: registered Mail::SpamAssassin::Plugin::AutoLearnThreshold=HASH(0xaba05b4)
[22413] dbg: plugin: loading Mail::SpamAssassin::Plugin::WhiteListSubject from @INC
[22413] dbg: plugin: registered Mail::SpamAssassin::Plugin::WhiteListSubject=HASH(0xac2dc4c)
[22413] dbg: plugin: loading Mail::SpamAssassin::Plugin::MIMEHeader from @INC
[22413] dbg: plugin: registered Mail::SpamAssassin::Plugin::MIMEHeader=HASH(0xabc5c68)
[22413] dbg: plugin: loading Mail::SpamAssassin::Plugin::ReplaceTags from @INC
[22413] dbg: plugin: registered Mail::SpamAssassin::Plugin::ReplaceTags=HASH(0xac27cd8)
[22413] dbg: config: adding redirector regex: /^http:\/\/chkpt\.zdnet\.com\/chkpt\/\w+\/(.*)$/i
[22413] dbg: config: adding redirector regex: /^http:\/\/www(?:\d+)?\.nate\.com\/r\/\w+\/(.*)$/i
[22413] dbg: config: adding redirector regex: /^http:\/\/.+\.gov\/(?:.*\/)?externalLink\.jhtml\?.*url=(.*?)(?:&.*)?$/i
[22413] dbg: config: adding redirector regex: /^http:\/\/redir\.internet\.com\/.+?\/.+?\/(.*)$/i
[22413] dbg: config: adding redirector regex: /^http:\/\/(?:.*?\.)?adtech\.de\/.*(?:;|\|)link=(.*?)(?:;|$)/i
[22413] dbg: config: adding redirector regex: m'^http.*?/redirect\.php\?.*(?<=[?&])goto=(.*?)(?:$|[&\#])'i
[22413] dbg: config: adding redirector regex: m'^https?:/*(?:[^/]+\.)?emf\d\.com/r\.cfm.*?&r=(.*)'i
[22413] warn: config: SpamAssassin failed to parse line, "/data/misc/bayesdb" is not valid for "bayes_path", skipping: bayes_path /data/misc/bayesdb
[22413] warn: config: warning: score set for non-existent rule ALL_TRUSTED
[22413] dbg: plugin: Mail::SpamAssassin::Plugin::ReplaceTags=HASH(0xac27cd8) implements 'finish_parsing_end'
[22413] dbg: replacetags: replacing tags
[22413] dbg: replacetags: done replacing tags
[22413] dbg: config: using "/root/.spamassassin" for user state dir
[22413] dbg: bayes: tie-ing to DB file R/O /root/.spamassassin/bayes_toks
[22413] dbg: bayes: tie-ing to DB file R/O /root/.spamassassin/bayes_seen
[22413] dbg: bayes: found bayes db version 3
[22413] dbg: bayes: DB journal sync: last sync: 0
[22413] dbg: config: using "/root/.spamassassin" for user state dir
[22413] dbg: bayes: not available for scanning, only 0 spam(s) in bayes DB < 200
[22413] dbg: bayes: untie-ing
[22413] dbg: bayes: untie-ing db_toks
[22413] dbg: bayes: untie-ing db_seen
[22413] dbg: config: score set 1 chosen.
[22413] dbg: message: ---- MIME PARSER START ----
[22413] dbg: message: main message type: text/plain
[22413] dbg: message: parsing normal part
[22413] dbg: message: added part, type: text/plain
[22413] dbg: message: ---- MIME PARSER END ----
[22413] dbg: bayes: tie-ing to DB file R/O /root/.spamassassin/bayes_toks
[22413] dbg: bayes: tie-ing to DB file R/O /root/.spamassassin/bayes_seen
[22413] dbg: bayes: found bayes db version 3
[22413] dbg: bayes: DB journal sync: last sync: 0
[22413] dbg: bayes: not available for scanning, only 0 spam(s) in bayes DB < 200
[22413] dbg: bayes: untie-ing
[22413] dbg: bayes: untie-ing db_toks
[22413] dbg: bayes: untie-ing db_seen
[22413] dbg: dns: testing resolver nameservers: 10.1.1.10
[22413] dbg: dns: trying (3) motorola.com...
[22413] dbg: dns: looking up NS for 'motorola.com'
[22413] dbg: dns: NS lookup of motorola.com using 10.1.1.10 succeeded => DNS available (set dns_available to override)
[22413] dbg: dns: is DNS available? 1
[22413] dbg: metadata: X-Spam-Relays-Trusted: 
[22413] dbg: metadata: X-Spam-Relays-Untrusted: 
[22413] dbg: message: no encoding detected
[22413] dbg: plugin: Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x9f55890) implements 'parsed_metadata'
[22413] dbg: uridnsbl: domains to query: 
[22413] dbg: dns: checking RBL sbl-xbl.spamhaus.org., set sblxbl-notfirsthop
[22413] dbg: dns: checking RBL sa-accredit.habeas.com., set habeas-firsttrusted
[22413] dbg: dns: checking RBL sbl-xbl.spamhaus.org., set sblxbl
[22413] dbg: dns: checking RBL sa-other.bondedsender.org., set bsp-untrusted
[22413] dbg: dns: checking RBL combined.njabl.org., set njabl-notfirsthop
[22413] dbg: dns: checking RBL combined.njabl.org., set njabl
[22413] dbg: dns: checking RBL combined-HIB.dnsiplists.completewhois.com., set whois
[22413] dbg: dns: checking RBL list.dsbl.org., set dsbl-notfirsthop
[22413] dbg: dns: checking RBL bl.spamcop.net., set spamcop
[22413] dbg: dns: checking RBL sa-trusted.bondedsender.org., set bsp-firsttrusted
[22413] dbg: dns: checking RBL combined-HIB.dnsiplists.completewhois.com., set whois-notfirsthop
[22413] dbg: dns: checking RBL dnsbl.sorbs.net., set sorbs-notfirsthop
[22413] dbg: dns: checking RBL dnsbl.sorbs.net., set sorbs
[22413] dbg: dns: checking RBL iadb.isipp.com., set iadb-firsttrusted
[22413] dbg: check: running tests for priority: 0
[22413] dbg: rules: running header regexp tests; score so far=0
[22413] dbg: rules: ran header rule __HAS_MSGID ======> got hit: "<"
[22413] dbg: rules: ran header rule __SANE_MSGID ======> got hit: "<1157305663@lint_rules>
[22413] dbg: rules: "
[22413] dbg: rules: ran header rule __MSGID_OK_HOST ======> got hit: "@lint_rules>"
[22413] dbg: rules: ran header rule NO_REAL_NAME ======> got hit: "ignore@compiling.spamassassin.taint.org
[22413] dbg: rules: "
[22413] dbg: rules: ran header rule __MSGID_OK_DIGITS ======> got hit: "1157305663"
[22413] dbg: plugin: registering glue method for check_hashcash_double_spend (Mail::SpamAssassin::Plugin::Hashcash=HASH(0xab79524))
[22413] dbg: plugin: registering glue method for check_for_spf_helo_pass (Mail::SpamAssassin::Plugin::SPF=HASH(0xab48884))
[22413] dbg: spf: message was delivered entirely via trusted relays, not required
[22413] dbg: eval: all '*From' addrs: [email]ignore@compiling.spamassassin.taint.org[/email]
[22413] dbg: plugin: registering glue method for check_subject_in_blacklist (Mail::SpamAssassin::Plugin::WhiteListSubject=HASH(0xac2dc4c))
[22413] dbg: plugin: registering glue method for check_hashcash_value (Mail::SpamAssassin::Plugin::Hashcash=HASH(0xab79524))
[22413] dbg: eval: all '*To' addrs: 
[22413] dbg: plugin: registering glue method for check_for_spf_neutral (Mail::SpamAssassin::Plugin::SPF=HASH(0xab48884))
[22413] dbg: spf: message was delivered entirely via trusted relays, not required
[22413] dbg: plugin: registering glue method for check_for_spf_softfail (Mail::SpamAssassin::Plugin::SPF=HASH(0xab48884))
[22413] dbg: rules: ran eval rule NO_RELAYS ======> got hit
[22413] dbg: plugin: registering glue method for check_for_spf_pass (Mail::SpamAssassin::Plugin::SPF=HASH(0xab48884))
[22413] dbg: plugin: registering glue method for check_for_spf_helo_softfail (Mail::SpamAssassin::Plugin::SPF=HASH(0xab48884))
[22413] dbg: plugin: registering glue method for check_for_def_spf_whitelist_from (Mail::SpamAssassin::Plugin::SPF=HASH(0xab48884))
[22413] dbg: spf: cannot get Envelope-From, cannot use SPF
[22413] dbg: spf: def_spf_whitelist_from: could not find useable envelope sender
[22413] dbg: plugin: registering glue method for check_for_spf_fail (Mail::SpamAssassin::Plugin::SPF=HASH(0xab48884))
[22413] dbg: rules: ran eval rule __UNUSABLE_MSGID ======> got hit
[22413] dbg: plugin: registering glue method for check_subject_in_whitelist (Mail::SpamAssassin::Plugin::WhiteListSubject=HASH(0xac2dc4c))
[22413] dbg: plugin: registering glue method for check_for_spf_whitelist_from (Mail::SpamAssassin::Plugin::SPF=HASH(0xab48884))
[22413] dbg: spf: spf_whitelist_from: could not find useable envelope sender
[22413] dbg: rules: ran eval rule MISSING_HEADERS ======> got hit
[22413] dbg: rules: running body-text per-line regexp tests; score so far=0.738
[22413] dbg: rules: ran body rule __NONEMPTY_BODY ======> got hit: "I"
[22413] dbg: rules: ran body rule __SARE_HTML_HAS_MSG ======> got hit: "I"
[22413] dbg: uri: running uri tests; score so far=0.738
[22413] dbg: bayes: tie-ing to DB file R/O /root/.spamassassin/bayes_toks
[22413] dbg: bayes: tie-ing to DB file R/O /root/.spamassassin/bayes_seen
[22413] dbg: bayes: found bayes db version 3
[22413] dbg: bayes: DB journal sync: last sync: 0
[22413] dbg: bayes: not available for scanning, only 0 spam(s) in bayes DB < 200
[22413] dbg: bayes: not scoring message, returning undef
[22413] dbg: bayes: DB expiry: tokens in DB: 0, Expiry max size: 150000, Oldest atime: 0, Newest atime: 0, Last expire: 0, Current time: 1157305710
[22413] dbg: bayes: DB journal sync: last sync: 0
[22413] dbg: bayes: untie-ing
[22413] dbg: bayes: untie-ing db_toks
[22413] dbg: bayes: untie-ing db_seen
[22413] dbg: plugin: registering glue method for check_uridnsbl (Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x9f55890))
[22413] dbg: rules: running raw-body-text per-line regexp tests; score so far=0.738
[22413] dbg: rules: running full-text regexp tests; score so far=0.738
[22413] dbg: plugin: registering glue method for check_pyzor (Mail::SpamAssassin::Plugin::Pyzor=HASH(0xabcb1f4))
[22413] dbg: util: current PATH is: /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
[22413] dbg: pyzor: pyzor is not available: no pyzor executable found
[22413] dbg: pyzor: no pyzor found, disabling Pyzor
[22413] dbg: plugin: Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x9f55890) implements 'check_tick'
[22413] dbg: check: running tests for priority: 500
[22413] dbg: plugin: Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x9f55890) implements 'check_post_dnsbl'
[22413] dbg: rules: running meta tests; score so far=0.738
[22413] dbg: rules: running header regexp tests; score so far=2.216
[22413] dbg: rules: running body-text per-line regexp tests; score so far=2.216
[22413] dbg: uri: running uri tests; score so far=2.216
[22413] dbg: rules: running raw-body-text per-line regexp tests; score so far=2.216
[22413] dbg: rules: running full-text regexp tests; score so far=2.216
[22413] dbg: check: running tests for priority: 1000
[22413] dbg: rules: running meta tests; score so far=2.216
[22413] dbg: rules: running header regexp tests; score so far=2.216
[22413] dbg: plugin: registering glue method for check_from_in_auto_whitelist (Mail::SpamAssassin::Plugin::AWL=HASH(0xab9f60c))
[22413] dbg: rules: running body-text per-line regexp tests; score so far=2.216
[22413] dbg: uri: running uri tests; score so far=2.216
[22413] dbg: rules: running raw-body-text per-line regexp tests; score so far=2.216
[22413] dbg: rules: running full-text regexp tests; score so far=2.216
[22413] dbg: check: is spam? score=2.216 required=5
[22413] dbg: check: tests=MISSING_HEADERS,MISSING_SUBJECT,NO_REAL_NAME,NO_RECEIVED,NO_RELAYS,TO_CC_NONE
[22413] dbg: check: subtests=__HAS_MSGID,__MSGID_OK_DIGITS,__MSGID_OK_HOST,__NONEMPTY_BODY,__SANE_MSGID,__SARE_HTML_HAS_MSG,__UNUSABLE_MSGID
[22413] warn: lint: 2 issues detected, please rerun with debug enabled for more information
[root@borg spamassassin]#

 

[cleverhandle]

Can you post the content of your /etc/mail/spamassassin/local.cf?

edit: Also an ls -l showing the permissions for the directory where you want the database.

 

[Red Squirrel]

Here's the info:

[root@borg spamassassin]# cat local.cf
# These values can be overridden by editing ~/.spamassassin/user_prefs.cf
# (see spamassassin(1) for details)

# These should be safe assumptions and allow for simple visual sifting
# without risking lost emails.

required_hits 5

rewrite_header Subject (_SCORE_) [SPAM]

add_header all Report _REPORT_
report ***This message scanned by the BORG local server***


use_bayes 1
use_auto_whitelist 0
bayes_file_mode 0770
bayes_path /data/misc/bayesdb

skip_rbl_checks 0
#use_razor 0
#use_dcc 0
#use_pyzor 0



[root@borg spamassassin]# dir /data/misc/bayesdb
total 2.2M
136K -rwxr-xr-x 1 root root 164K Sep 2 11:36 bayes_seen
2.1M -rwxr-xr-x 1 root root 2.6M Sep 2 11:43 bayes_toks
[root@borg spamassassin]#

 

[cleverhandle]

What happens if you run as non-root, as a user without any ~/.spamassassin directory? Perl can do funny things when you run as root, due to lots of built-in security checks.

 

[Red Squirrel]

same thing

Last login: Sun Sep 3 13:55:37 2006 from 10.1.1.20
-bash-3.1$ dir -a
. .. .bash_history .lesshst mail .procmailrc .ssh tmptransfers .viminfo webmin-1.290-1.noarch.rpm
-bash-3.1$
-bash-3.1$
-bash-3.1$ spamassassin -D --lint
[23211] dbg: logger: adding facilities: all
[23211] dbg: logger: logging level is DBG
[23211] dbg: generic: SpamAssassin version 3.1.0
[23211] dbg: config: score set 0 chosen.
[23211] dbg: util: running in taint mode? yes
[23211] dbg: util: taint mode: deleting unsafe environment variables, resetting PATH
[23211] dbg: util: PATH included '/usr/kerberos/bin', keeping
[23211] dbg: util: PATH included '/usr/local/bin', keeping
[23211] dbg: util: PATH included '/bin', keeping
[23211] dbg: util: PATH included '/usr/bin', keeping
[23211] dbg: util: final PATH set to: /usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin
[23211] dbg: dns: is Net:NS::Resolver available? yes
[23211] dbg: dns: Net:NS version: 0.55
[23211] dbg: dns: name server: 10.1.1.10, family: 2, ipv6: 0
[23211] dbg: diag: perl platform: 5.008008 linux
[23211] dbg: diag: module installed: Digest::SHA1, version 2.11
[23211] dbg: diag: module installed: HTML:arser, version 3.50
[23211] dbg: diag: module installed: MIME::Base64, version 3.07
[23211] dbg: diag: module installed: DB_File, version 1.814
[23211] dbg: diag: module installed: Net:NS, version 0.55
[23211] dbg: diag: module installed: Net::SMTP, version 2.29
[23211] dbg: diag: module not installed: Mail::SPF::Query ('require' failed)
[23211] dbg: diag: module not installed: IP::Country::Fast ('require' failed)
[23211] dbg: diag: module not installed: Razor2::Client::Agent ('require' failed)
[23211] dbg: diag: module not installed: Net::Ident ('require' failed)
[23211] dbg: diag: module not installed: IO::Socket::INET6 ('require' failed)
[23211] dbg: diag: module not installed: IO::Socket::SSL ('require' failed)
[23211] dbg: diag: module installed: Time::HiRes, version 1.86
[23211] dbg: diag: module installed: DBI, version 1.50
[23211] dbg: diag: module installed: Getopt::Long, version 2.35
[23211] dbg: diag: module installed: LWP::UserAgent, version 2.033
[23211] dbg: diag: module installed: HTTP:ate, version 1.47
[23211] dbg: diag: module not installed: Archive::Tar ('require' failed)
[23211] dbg: diag: module not installed: IO::Zlib ('require' failed)
[23211] dbg: ignore: using a test message to lint rules
[23211] dbg: config: using "/etc/mail/spamassassin" for site rules pre files
[23211] dbg: config: read file /etc/mail/spamassassin/init.pre
[23211] dbg: config: read file /etc/mail/spamassassin/v310.pre
[23211] dbg: config: using "/usr/share/spamassassin" for sys rules pre files
[23211] dbg: config: using "/usr/share/spamassassin" for default rules dir
[23211] dbg: config: read file /usr/share/spamassassin/10_misc.cf
[23211] dbg: config: read file /usr/share/spamassassin/20_advance_fee.cf
[23211] dbg: config: read file /usr/share/spamassassin/20_anti_ratware.cf
[23211] dbg: config: read file /usr/share/spamassassin/20_body_tests.cf
[23211] dbg: config: read file /usr/share/spamassassin/20_compensate.cf
[23211] dbg: config: read file /usr/share/spamassassin/20_dnsbl_tests.cf
[23211] dbg: config: read file /usr/share/spamassassin/20_drugs.cf
[23211] dbg: config: read file /usr/share/spamassassin/20_fake_helo_tests.cf
[23211] dbg: config: read file /usr/share/spamassassin/20_head_tests.cf
[23211] dbg: config: read file /usr/share/spamassassin/20_html_tests.cf
[23211] dbg: config: read file /usr/share/spamassassin/20_meta_tests.cf
[23211] dbg: config: read file /usr/share/spamassassin/20_net_tests.cf
[23211] dbg: config: read file /usr/share/spamassassin/20_phrases.cf
[23211] dbg: config: read file /usr/share/spamassassin/20_porn.cf
[23211] dbg: config: read file /usr/share/spamassassin/20_ratware.cf
[23211] dbg: config: read file /usr/share/spamassassin/20_uri_tests.cf
[23211] dbg: config: read file /usr/share/spamassassin/23_bayes.cf
[23211] dbg: config: read file /usr/share/spamassassin/25_accessdb.cf
[23211] dbg: config: read file /usr/share/spamassassin/25_antivirus.cf
[23211] dbg: config: read file /usr/share/spamassassin/25_body_tests_es.cf
[23211] dbg: config: read file /usr/share/spamassassin/25_body_tests_pl.cf
[23211] dbg: config: read file /usr/share/spamassassin/25_dcc.cf
[23211] dbg: config: read file /usr/share/spamassassin/25_domainkeys.cf
[23211] dbg: config: read file /usr/share/spamassassin/25_hashcash.cf
[23211] dbg: config: read file /usr/share/spamassassin/25_pyzor.cf
[23211] dbg: config: read file /usr/share/spamassassin/25_razor2.cf
[23211] dbg: config: read file /usr/share/spamassassin/25_replace.cf
[23211] dbg: config: read file /usr/share/spamassassin/25_spf.cf
[23211] dbg: config: read file /usr/share/spamassassin/25_textcat.cf
[23211] dbg: config: read file /usr/share/spamassassin/25_uribl.cf
[23211] dbg: config: read file /usr/share/spamassassin/30_text_de.cf
[23211] dbg: config: read file /usr/share/spamassassin/30_text_fr.cf
[23211] dbg: config: read file /usr/share/spamassassin/30_text_it.cf
[23211] dbg: config: read file /usr/share/spamassassin/30_text_nl.cf
[23211] dbg: config: read file /usr/share/spamassassin/30_text_pl.cf
[23211] dbg: config: read file /usr/share/spamassassin/30_text_pt_br.cf
[23211] dbg: config: read file /usr/share/spamassassin/50_scores.cf
[23211] dbg: config: read file /usr/share/spamassassin/60_awl.cf
[23211] dbg: config: read file /usr/share/spamassassin/60_whitelist.cf
[23211] dbg: config: read file /usr/share/spamassassin/60_whitelist_spf.cf
[23211] dbg: config: read file /usr/share/spamassassin/60_whitelist_subject.cf
[23211] dbg: config: using "/etc/mail/spamassassin" for site rules dir
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_adult.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_bayes_poison_nxm.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_evilnum0.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_evilnum1.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_evilnum2.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_genlsubj3.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_header.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_header_eng.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_highrisk.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_html.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_html2.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_obfu.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_obfu0.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_obfu1.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_obfu2.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_obfu3.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_obfu4.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_random.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_specific.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_spoof.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_unsub.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sare_uri_eng.cf
[23211] dbg: config: read file /etc/mail/spamassassin/70_sc_top200.cf
[23211] dbg: config: read file /etc/mail/spamassassin/71_sare_bml_pre25x.cf
[23211] dbg: config: read file /etc/mail/spamassassin/71_sare_redirect_pre3.0.0.cf
[23211] dbg: config: read file /etc/mail/spamassassin/72_sare_bml_post25x.cf
[23211] dbg: config: read file /etc/mail/spamassassin/99_sare_fraud_post25x.cf
[23211] dbg: config: read file /etc/mail/spamassassin/99_sare_fraud_pre25x.cf
[23211] dbg: config: read file /etc/mail/spamassassin/autogen.cf
[23211] dbg: config: read file /etc/mail/spamassassin/customrules.cf
[23211] dbg: config: read file /etc/mail/spamassassin/evilnumbers_sept04.cf
[23211] dbg: config: read file /etc/mail/spamassassin/local.cf
[23211] dbg: config: using "/home/sshlogon/.spamassassin" for user state dir
[23211] dbg: config: using "/home/sshlogon/.spamassassin" for user state dir
[23211] warn: config: created user preferences file: /home/sshlogon/.spamassassin/user_prefs
[23211] dbg: config: using "/home/sshlogon/.spamassassin/user_prefs" for user prefs file
[23211] dbg: config: read file /home/sshlogon/.spamassassin/user_prefs
[23211] dbg: plugin: loading Mail::SpamAssassin:lugin::URIDNSBL from @INC
[23211] dbg: plugin: registered Mail::SpamAssassin:lugin::URIDNSBL=HASH(0x91b07dc)
[23211] dbg: plugin: loading Mail::SpamAssassin:lugin::Hashcash from @INC
[23211] dbg: plugin: registered Mail::SpamAssassin:lugin::Hashcash=HASH(0x9dd51b8)
[23211] dbg: plugin: loading Mail::SpamAssassin:lugin::SPF from @INC
[23211] dbg: plugin: registered Mail::SpamAssassin:lugin::SPF=HASH(0x9da3748)
[23211] dbg: plugin: loading Mail::SpamAssassin:lugin:yzor from @INC
[23211] dbg: pyzor: network tests on, attempting Pyzor
[23211] dbg: plugin: registered Mail::SpamAssassin:lugin:yzor=HASH(0x9e28720)
[23211] dbg: plugin: loading Mail::SpamAssassin:lugin::SpamCop from @INC
[23211] dbg: reporter: network tests on, attempting SpamCop
[23211] dbg: plugin: registered Mail::SpamAssassin:lugin::SpamCop=HASH(0x9df7cb0)
[23211] dbg: plugin: loading Mail::SpamAssassin:lugin::AWL from @INC
[23211] dbg: plugin: registered Mail::SpamAssassin:lugin::AWL=HASH(0x9dfa728)
[23211] dbg: plugin: loading Mail::SpamAssassin:lugin::AutoLearnThreshold from @INC
[23211] dbg: plugin: registered Mail::SpamAssassin:lugin::AutoLearnThreshold=HASH(0x9dfb6d0)
[23211] dbg: plugin: loading Mail::SpamAssassin:lugin::WhiteListSubject from @INC
[23211] dbg: plugin: registered Mail::SpamAssassin:lugin::WhiteListSubject=HASH(0x9e8a068)
[23211] dbg: plugin: loading Mail::SpamAssassin:lugin::MIMEHeader from @INC
[23211] dbg: plugin: registered Mail::SpamAssassin:lugin::MIMEHeader=HASH(0x9e33d3c)
[23211] dbg: plugin: loading Mail::SpamAssassin:lugin::ReplaceTags from @INC
[23211] dbg: plugin: registered Mail::SpamAssassin:lugin::ReplaceTags=HASH(0x9e87ab4)
[23211] dbg: config: adding redirector regex: /^http:\/\/chkpt\.zdnet\.com\/chkpt\/\w+\/(.*)$/i
[23211] dbg: config: adding redirector regex: /^http:\/\/www(?:\d+)?\.nate\.com\/r\/\w+\/(.*)$/i
[23211] dbg: config: adding redirector regex: /^http:\/\/.+\.gov\/(?:.*\/)?externalLink\.jhtml\?.*url=(.*?)(?:&.*)?$/i
[23211] dbg: config: adding redirector regex: /^http:\/\/redir\.internet\.com\/.+?\/.+?\/(.*)$/i
[23211] dbg: config: adding redirector regex: /^http:\/\/(?:.*?\.)?adtech\.de\/.*(?:;|\|)link=(.*?)(?:;|$)/i
[23211] dbg: config: adding redirector regex: m'^http.*?/redirect\.php\?.*(?<=[?&])goto=(.*?)(?:$|[&\#])'i
[23211] dbg: config: adding redirector regex: m'^https?:/*(?:[^/]+\.)?emf\d\.com/r\.cfm.*?&r=(.*)'i
[23211] warn: config: SpamAssassin failed to parse line, "/data/misc/bayesdb" is not valid for "bayes_path", skipping: bayes_path /data/misc/bayesdb
[23211] warn: config: warning: score set for non-existent rule ALL_TRUSTED
[23211] dbg: plugin: Mail::SpamAssassin:lugin::ReplaceTags=HASH(0x9e87ab4) implements 'finish_parsing_end'
[23211] dbg: replacetags: replacing tags
[23211] dbg: replacetags: done replacing tags
[23211] dbg: config: using "/home/sshlogon/.spamassassin" for user state dir
[23211] dbg: bayes: no dbs present, cannot tie DB R/O: /home/sshlogon/.spamassassin/bayes_toks
[23211] dbg: config: score set 1 chosen.
[23211] dbg: message: ---- MIME PARSER START ----
[23211] dbg: message: main message type: text/plain
[23211] dbg: message: parsing normal part
[23211] dbg: message: added part, type: text/plain
[23211] dbg: message: ---- MIME PARSER END ----
[23211] dbg: bayes: no dbs present, cannot tie DB R/O: /home/sshlogon/.spamassassin/bayes_toks
[23211] dbg: dns: testing resolver nameservers: 10.1.1.10
[23211] dbg: dns: trying (3) comcast.net...
[23211] dbg: dns: looking up NS for 'comcast.net'
[23211] dbg: dns: NS lookup of comcast.net using 10.1.1.10 succeeded => DNS available (set dns_available to override)
[23211] dbg: dns: is DNS available? 1
[23211] dbg: metadata: X-Spam-Relays-Trusted:
[23211] dbg: metadata: X-Spam-Relays-Untrusted:
[23211] dbg: message: no encoding detected
[23211] dbg: plugin: Mail::SpamAssassin:lugin::URIDNSBL=HASH(0x91b07dc) implements 'parsed_metadata'
[23211] dbg: uridnsbl: domains to query:
[23211] dbg: dns: checking RBL sbl-xbl.spamhaus.org., set sblxbl-notfirsthop
[23211] dbg: dns: checking RBL sa-accredit.habeas.com., set habeas-firsttrusted
[23211] dbg: dns: checking RBL sbl-xbl.spamhaus.org., set sblxbl
[23211] dbg: dns: checking RBL sa-other.bondedsender.org., set bsp-untrusted
[23211] dbg: dns: checking RBL combined.njabl.org., set njabl-notfirsthop
[23211] dbg: dns: checking RBL combined.njabl.org., set njabl
[23211] dbg: dns: checking RBL combined-HIB.dnsiplists.completewhois.com., set whois
[23211] dbg: dns: checking RBL list.dsbl.org., set dsbl-notfirsthop
[23211] dbg: dns: checking RBL bl.spamcop.net., set spamcop
[23211] dbg: dns: checking RBL sa-trusted.bondedsender.org., set bsp-firsttrusted
[23211] dbg: dns: checking RBL combined-HIB.dnsiplists.completewhois.com., set whois-notfirsthop
[23211] dbg: dns: checking RBL dnsbl.sorbs.net., set sorbs-notfirsthop
[23211] dbg: dns: checking RBL dnsbl.sorbs.net., set sorbs
[23211] dbg: dns: checking RBL iadb.isipp.com., set iadb-firsttrusted
[23211] dbg: check: running tests for priority: 0
[23211] dbg: rules: running header regexp tests; score so far=0
[23211] dbg: rules: ran header rule __HAS_MSGID ======> got hit: "<"
[23211] dbg: rules: ran header rule __SANE_MSGID ======> got hit: "<1157311685@lint_rules>
[23211] dbg: rules: "
[23211] dbg: rules: ran header rule __MSGID_OK_HOST ======> got hit: "@lint_rules>"
[23211] dbg: rules: ran header rule NO_REAL_NAME ======> got hit: "ignore@compiling.spamassassin.taint.org
[23211] dbg: rules: "
[23211] dbg: rules: ran header rule __MSGID_OK_DIGITS ======> got hit: "1157311685"
[23211] dbg: plugin: registering glue method for check_hashcash_double_spend (Mail::SpamAssassin:lugin::Hashcash=HASH(0x9dd51b8))
[23211] dbg: plugin: registering glue method for check_for_spf_helo_pass (Mail::SpamAssassin:lugin::SPF=HASH(0x9da3748))
[23211] dbg: spf: message was delivered entirely via trusted relays, not required
[23211] dbg: eval: all '*From' addrs: ignore@compiling.spamassassin.taint.org
[23211] dbg: plugin: registering glue method for check_subject_in_blacklist (Mail::SpamAssassin:lugin::WhiteListSubject=HASH(0x9e8a068))
[23211] dbg: plugin: registering glue method for check_hashcash_value (Mail::SpamAssassin:lugin::Hashcash=HASH(0x9dd51b8))
[23211] dbg: eval: all '*To' addrs:
[23211] dbg: plugin: registering glue method for check_for_spf_neutral (Mail::SpamAssassin:lugin::SPF=HASH(0x9da3748))
[23211] dbg: spf: message was delivered entirely via trusted relays, not required
[23211] dbg: plugin: registering glue method for check_for_spf_softfail (Mail::SpamAssassin:lugin::SPF=HASH(0x9da3748))
[23211] dbg: rules: ran eval rule NO_RELAYS ======> got hit
[23211] dbg: plugin: registering glue method for check_for_spf_pass (Mail::SpamAssassin:lugin::SPF=HASH(0x9da3748))
[23211] dbg: plugin: registering glue method for check_for_spf_helo_softfail (Mail::SpamAssassin:lugin::SPF=HASH(0x9da3748))
[23211] dbg: plugin: registering glue method for check_for_def_spf_whitelist_from (Mail::SpamAssassin:lugin::SPF=HASH(0x9da3748))
[23211] dbg: spf: cannot get Envelope-From, cannot use SPF
[23211] dbg: spf: def_spf_whitelist_from: could not find useable envelope sender
[23211] dbg: plugin: registering glue method for check_for_spf_fail (Mail::SpamAssassin:lugin::SPF=HASH(0x9da3748))
[23211] dbg: rules: ran eval rule __UNUSABLE_MSGID ======> got hit
[23211] dbg: plugin: registering glue method for check_subject_in_whitelist (Mail::SpamAssassin:lugin::WhiteListSubject=HASH(0x9e8a068))
[23211] dbg: plugin: registering glue method for check_for_spf_whitelist_from (Mail::SpamAssassin:lugin::SPF=HASH(0x9da3748))
[23211] dbg: spf: spf_whitelist_from: could not find useable envelope sender
[23211] dbg: rules: ran eval rule MISSING_HEADERS ======> got hit
[23211] dbg: rules: running body-text per-line regexp tests; score so far=0.738
[23211] dbg: rules: ran body rule __NONEMPTY_BODY ======> got hit: "I"
[23211] dbg: rules: ran body rule __SARE_HTML_HAS_MSG ======> got hit: "I"
[23211] dbg: uri: running uri tests; score so far=0.738
[23211] dbg: bayes: no dbs present, cannot tie DB R/O: /home/sshlogon/.spamassassin/bayes_toks
[23211] dbg: bayes: not scoring message, returning undef
[23211] dbg: bayes: opportunistic call attempt failed, DB not readable
[23211] dbg: plugin: registering glue method for check_uridnsbl (Mail::SpamAssassin:lugin::URIDNSBL=HASH(0x91b07dc))
[23211] dbg: rules: running raw-body-text per-line regexp tests; score so far=0.738
[23211] dbg: rules: running full-text regexp tests; score so far=0.738
[23211] dbg: plugin: registering glue method for check_pyzor (Mail::SpamAssassin:lugin:yzor=HASH(0x9e28720))
[23211] dbg: util: current PATH is: /usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin
[23211] dbg: pyzor: pyzor is not available: no pyzor executable found
[23211] dbg: pyzor: no pyzor found, disabling Pyzor
[23211] dbg: plugin: Mail::SpamAssassin:lugin::URIDNSBL=HASH(0x91b07dc) implements 'check_tick'
[23211] dbg: check: running tests for priority: 500
[23211] dbg: plugin: Mail::SpamAssassin:lugin::URIDNSBL=HASH(0x91b07dc) implements 'check_post_dnsbl'
[23211] dbg: rules: running meta tests; score so far=0.738
[23211] dbg: rules: running header regexp tests; score so far=2.216
[23211] dbg: rules: running body-text per-line regexp tests; score so far=2.216
[23211] dbg: uri: running uri tests; score so far=2.216
[23211] dbg: rules: running raw-body-text per-line regexp tests; score so far=2.216
[23211] dbg: rules: running full-text regexp tests; score so far=2.216
[23211] dbg: check: running tests for priority: 1000
[23211] dbg: rules: running meta tests; score so far=2.216
[23211] dbg: rules: running header regexp tests; score so far=2.216
[23211] dbg: plugin: registering glue method for check_from_in_auto_whitelist (Mail::SpamAssassin:lugin::AWL=HASH(0x9dfa728))
[23211] dbg: rules: running body-text per-line regexp tests; score so far=2.216
[23211] dbg: uri: running uri tests; score so far=2.216
[23211] dbg: rules: running raw-body-text per-line regexp tests; score so far=2.216
[23211] dbg: rules: running full-text regexp tests; score so far=2.216
[23211] dbg: check: is spam? score=2.216 required=5
[23211] dbg: check: tests=MISSING_HEADERS,MISSING_SUBJECT,NO_REAL_NAME,NO_RECEIVED,NO_RELAYS,TO_CC_NONE
[23211] dbg: check: subtests=__HAS_MSGID,__MSGID_OK_DIGITS,__MSGID_OK_HOST,__NONEMPTY_BODY,__SANE_MSGID,__SARE_HTML_HAS_MSG,__UNUSABLE_MSGID
[23211] warn: lint: 2 issues detected, please rerun with debug enabled for more information
-bash-3.1$

 

[cleverhandle]

OK, so we know we're reading the correct configuration files at least. Next up would be permissions. You have bayes_file_mode set to 770, but that doesn't match the mode shown in ls -l. What happens if you totally open everything up? (Set file_mode to 777, chmod the db files and the parent directory 777).

 

[Nothinman]

It's not permissions, he specified the path wrong. If you read the Mail::SpamAssassin::Conf(3pm) man page it says:

bayes_path /path/filename (default: ~/.spamassassin/bayes)
This is the directory and filename for Bayes databases. Several databases will be created, with this as the base directory and filename, with
"_toks", "_seen", etc. appended to the base. The default setting results in files called "~/.spamassassin/bayes_seen", "~/.spamassas-
sin/bayes_toks", etc.


So the path is not only the containing directory but also the prefix for the _seen, _toks, etc files that it creates. I changed the bayes_path to say "/data/misc/bayesdb/bayes" in my config and it worked just fine.

[16307] dbg: bayes: tie-ing to DB file R/O /data/misc/bayesdb/bayes_toks
[16307] dbg: bayes: tie-ing to DB file R/O /data/misc/bayesdb/bayes_seen
[16307] dbg: bayes: found bayes db version 3
[16307] dbg: bayes: DB journal sync: last sync: 1147548197

 

[Red Squirrel]

Hmm intersting. Would have never figured that out myself. Thanks.

That seems to have fixed it, no error, I'll see in the next few days if I start getting less spam. Been getting a couple per day that make it through.

 

[Nothinman]

Hmm intersting. Would have never figured that out myself. Thanks.

Yea, I've noticed that you and documentation don't seem to get along too well.