On Oct 4, 2009, at 8:56 PM, Steven W. Orr wrote:
I did some googling, and the more I read, the more apparent that the
documentation is a little light.
So here are the questions that I think are really the 800 pound
elephant in
the room:
* If I do set bayes_auto_expire to 0 and I am using MySQL then does
any run of
sa-learn cause the expired rows of bayes_token to be removed if
there are no
corresponding rows that relate back to bayes_seen?
No. Also, I think you're not really understanding how expiry works, I
suggest you read the Expiration section of the sa-learn man page to
get a better idea of what is going on.
* If I set bayes_auto_expire to 0, and I am using MySQL then do I
need to run
a cron job which does this? How often should I run it?
sa-learn --force-expire --sync
Yes, if you turn off auto expire then you will need to come up with
some way to run it manually. How often really depends on your mail
traffic. However, unless you have a poorly tuned MySQL database or
underpowered system I would recommend just keeping auto expire turned
on. Its very quick to run under SQL and should not slow down your
usual mail processing.
* I set bayes_sql_override_username to something. If I did not, then
do I have
to have a cron job as described above that runs as each user that is
listed in
bayes_vars.username?
Yes, you would have to run it for each user.
* If I set bayes_auto_expire to 1, then does every update of any row
in the
spamassassin database try to clean up these rows that could be
removed?
Please read the sa-learn man page for details on how expiration works,
but what happens is that when a message is scanned by bayes a small
check is made to see if it needs to happen. In more recent versions
of spamd this expiration happens after the result is returned to the
client so there should be no waiting.
Hope that answers some questions.
Michael
I'm hoping that I'm not ranting. Sorry.
--
Time flies like the wind. Fruit flies like a banana. Stranger things
have .0.
happened but none stranger than this. Does your driver's license say
Organ ..0
Donor?Black holes are where God divided by zero. Listen to me! We
are all- 000
individuals! What if this weren't a hypothetical question?
steveo at syslang.net
