On 2011-07-29 15:03, monolit939 wrote:
Axb wrote:
On 2011-07-29 11:14, monolit939 wrote:
Hello,
I have found test which says the change of type of Spamassassin database
can
increase performance almost three times (from Berkeley DB format to SDBM
format). I want to ask you if somebody has some experience with
conversion
of standard Spamassassin bayes database.
I have found just this
http://wiki.mailscanner.info/doku.php?id=documentation:anti_spam:spamassassin:bayes:sdbm&rev=1269508492
guide , but it describes solution for mailscanner...
stop spamd
sa-learn --backup> /tmp/bayes_export
add to local.cf
bayes_store_module Mail::SpamAssassin::BayesStore::SDBM
sa-learn --restore /tmp/bayes_export
test change:
spamassassin -D --lint 2>&1 | grep -i bayes
if you see no errors
restart spamd
ls /path/to/bayes shows
bayes.mutex
bayes_seen.dir
bayes_seen.pag
bayes_toks.dir
bayes_toks.pag
h2h
Hello,
I have problems with conversion from Berkeley DB to SDBM. I followed steps
you wrote...
/etc/init.d/spamassassin stop
su mail -c 'sa-learn --backup> /tmp/bayes_export'
add 'bayes_store_module Mail::SpamAssassin::BayesStore::SDBM' to
/etc/mail/spamassassin/local.cf
su mail -c 'sa-learn --restore /tmp/bayes_export'
OUTPUT: ERROR: Bayes restore returned an error, please re-run with -D for
more information
su mail -c 'sa-learn -D --restore /tmp/bayes_export'
OUTPUT:
<SNIPPED>
file /var/mail/.spamassassin/*
/var/mail/.spamassassin/auto-whitelist: Berkeley DB (Hash, version 8,
native byte-order)
/var/mail/.spamassassin/auto-whitelist.mutex: ASCII text
/var/mail/.spamassassin/bayes_journal: ASCII text
/var/mail/.spamassassin/bayes.mutex: ASCII text
/var/mail/.spamassassin/bayes_seen: Berkeley DB (Hash, version 8,
native byte-order)
/var/mail/.spamassassin/bayes_seen.dir: empty
/var/mail/.spamassassin/bayes_seen.pag: empty
/var/mail/.spamassassin/bayes_toks: Berkeley DB (Hash, version 9,
native byte-order)
/var/mail/.spamassassin/bayes_toks.dir: empty
/var/mail/.spamassassin/bayes_toks.pag: data
/var/mail/.spamassassin/mnt: setgid directory
/var/mail/.spamassassin/ol: setgid directory
/var/mail/.spamassassin/spamassassin.zip: Zip archive data, at least
v1.0 to extract
/var/mail/.spamassassin/user_prefs: ASCII English text
As you can see, database files were not converted to SDBM, they are still
the Berkeley DB type. Do you have some clue now? Or should I post some other
output or log?
hmm....pls run the backup & restore as root.
then, also as root:
spamassassin -D --lint 2>&1 | grep -i bayes
and show us the output.
you can change ownership later
