Mitchell Hudson schrieb am 19.03.2008 18:18:
I have a few questions though, you said I am not using
bayes_sql_override_username but I have "bayes_sql_override_username
spamassassin " in my config, does that not count?
I'm sorry, I overlooked that. Yes, in the configuration that you posted
it was set. And I also told rubbish by claiming that you ran under the
username root. SA reported the internal userid from the sql table, and
that was probably the user 'spamassassin'.
As well I tried
setting the min_ham and min_spam to 1 just for a short test, and took
out the bayes_sql_override_username and it wasn't calling. When I did
the use spamassassin; select * from bayes_vars; I did get a list of
people, but they have very few tokens, in the order of 1 or 2 which
looks to me like those tokens were created when I was tinkering and
removed the sql_override_username, otherwise everything is put into the
spamassassin user which has a few hundred thousand tokens in it currently.
Yes, that's a valid explanation. Sorry for the confusion from my part.
But that leads us back to your question: "why it is not scoring?". Did
you really found all bayes-related output from --lint? If I run a
"spamassassin --lint -D 2>&1|grep -i bayes", I get more bayes-related
output:
[21631] dbg: plugin: loading Mail::SpamAssassin::Plugin::Bayes from @INC
[21631] dbg: config: fixed relative path:
/var/lib/spamassassin/3.002004/updates_spamassassin_org/23_bayes.cf
[21631] dbg: config: using
"/var/lib/spamassassin/3.002004/updates_spamassassin_org/23_bayes.cf"
for included file
[21631] dbg: config: read file
/var/lib/spamassassin/3.002004/updates_spamassassin_org/23_bayes.cf
[21631] dbg: bayes: using username: mail
[21631] dbg: bayes: database connection established
[21631] dbg: bayes: found bayes db version 3
[21631] dbg: bayes: Using userid: 2
[21631] dbg: bayes: corpus size: nspam = 214240, nham = 138319
[21631] dbg: bayes: tok_get_all: token count: 21
[21631] dbg: bayes: score = 0.0020110638266459
[21631] dbg: bayes: DB expiry: tokens in DB: 461680, Expiry max size:
500000, Oldest atime: 1203126859, Newest atime: 1205950517, Last expire:
1205444421, Current time: 1205950517
[21631] dbg: rules: ran eval rule BAYES_00 ======> got hit (1)
[21631] dbg: check:
tests=BAYES_00,MISSING_DATE,MISSING_HEADERS,MISSING_SUBJECT,NO_RECEIVED,NO_RELAYS
I am using Mysql as database.
Tschau
Alex