Axb wrote:
>
> On 2011-07-29 15:50, monolit939 wrote:
>>
>>
>> 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!
>
> I'm guessing you don't have the path to bayes in local.cf which is why
> root fails as it doesn't find your active bayes files
>
> for example:
>
> local.cf
> bayes_path /var/lib/bayes/bayes
>
>
>
>
>
>
Hello,
I added to /etc/mail/spamassassin/local.cf this line:
bayes_path /var/mail/.spamassassin
As you could notice from my previous posts - spamassassin database files are
placed in path /var/mail/.spamassassin.
I stopped spamd and then I started:
sa-learn --backup > /tmp/bayes_export
The resolution is the same - 77B file with content I uploaded in my previous
post.
Do you have any suggetions?
--
View this message in context:
http://old.nabble.com/Conversion-Spamassassin%28bayes%29-database-to-SDBM-tp32160172p32160907.html
Sent from the SpamAssassin - Users mailing list archive at Nabble.com.
