SA-3.1.5
I recently moved from individual incoming machine Bayes DBs
to a central MySql Bayes that all incoming servers connect
to. I noticed that running 'sa-learn --force-expire'
on the DB server worked the first time but has done nothing
in the last few weeks. A "--dump magic" shows the same
numbers each day.
I then did a 'sa-learn --dump magic' on the DB server and
also on one of the incoming servers. Why the different
numbers? (I use bayes_sql_override_username on all)
DB Server
=========
0.000 0 3 0 non-token data: bayes db version
0.000 0 870921 0 non-token data: nspam
0.000 0 1860058 0 non-token data: nham
0.000 0 165567 0 non-token data: ntokens
0.000 0 1158164112 0 non-token data: oldest atime
0.000 0 1158306146 0 non-token data: newest atime
0.000 0 0 0 non-token data: last journal sync atime
0.000 0 1158920635 0 non-token data: last expiry atime
0.000 0 86400 0 non-token data: last expire atime delta
0.000 0 21899 0 non-token data: last expire reduction
count
Mail Server
==========
0.000 0 3 0 non-token data: bayes db version
0.000 0 6999 0 non-token data: nspam
0.000 0 25847 0 non-token data: nham
0.000 0 1000393 0 non-token data: ntokens
0.000 0 1158260598 0 non-token data: oldest atime
0.000 0 1158950372 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
I have confirmed that all servers are talking to the DB servers
for Bayes info. The numbers change on the mail server output
but the numbers from sa-learn for the DB server never change.
What am I missing? When I did the 'sa-learn --restore' to
copy over one of the existing Bayes DBs, should I have used
the --username to match the "bayes_sql_override_username" even
though it was also set on the DB server local.cf?
--
Tim Rosmus <[EMAIL PROTECTED]>
Postmaster / USENET / DNS
Northwest Nexus Inc. / NetOS Inc.
