| Main Archive Page > Month Archives > spamassassin-users archives |
Re: Conversion Spamassassin(bayes) database to SDBM
From: monolit939 <pavel.muller_at_nospam>Date: Fri Jul 29 2011 - 13:50:55 GMT
To: users@spamassassin.apache.org
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.