Axb wrote: > > 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 > > > > >
Hello, it will be problem, because when I use: sa-learn --backup > /tmp/bayes_export I get: ls -l /tmp/bayes_export -rw-r--r-- 1 root root 77 2011-07-29 15:37 /tmp/bayes_export # the file has just 77B Content of the file is: v 3 db_version # this must be the first line!!! v 0 num_spam v 0 num_nonspam BUT when I use: su mail -c 'sa-learn --backup > /tmp/bayes_export' I get: ls -l /tmp/bayes_export -rw-r--r-- 1 mail mail 35434634 2011-07-29 15:27 /tmp/bayes_export #the file has more than 35MB! -- View this message in context: http://old.nabble.com/Conversion-Spamassassin%28bayes%29-database-to-SDBM-tp32160172p32160833.html Sent from the SpamAssassin - Users mailing list archive at Nabble.com.
