Re: Bayes update

[Robert LeBlanc]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Administrator wrote:
> If you disable the bayes mySQL database you will break amavisd-maia. 

Not quite; you can use the flat-file Berkeley-style database for your
Bayes and AWL databases with Maia if you like, it's just that certain
SQL-specific utilities (e.g. maiadbtool.pl) only work on SQL tables, so
those obviously won't help you in that case.

- --
Robert LeBlanc <[EMAIL PROTECTED]>
Renaissoft, Inc.
Maia Mailguard 

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7 (GNU/Linux)

iD8DBQFGr4HAGmqOER2NHewRAg3UAJ4jzJXKLdmNCb963wWDa9+snrhwQQCfXUAU
1YIksmRbV+PeCbK3F2+7x7Q=
=gvu9
-END PGP SIGNATURE-

Re: Bayes update

[Administrator]

If you disable the bayes mySQL database you will break amavisd-maia. 
Either use amavisd-maia or amavisd-new with either flat files or mySQL.

Salvatore wrote:
> "Lina, Patrick" wrote:
>> At least these must be configured:
>> use_bayes 1
>> bayes_path /var/amavisd/.spamassassin/bayes
>>
>> All the bayes_sql* and bayes_store_module can be
>> removed/hashed out.
>>
>> De default store module for bayes is DB_File (make sure
>> you have the DB_File perl module installed)
>
> ..with phpmyadmin I have view maia db, now I must remove all tables
> show for maia db ? and the I must add:
>
> use_bayes 1
>
> ..in local.cf ?
> Thanks again.
>
> --
> Salvatore.
>
>
>

Re: Bayes update

[Salvatore]

"Lina, Patrick" wrote:

At least these must be configured:
use_bayes 1
bayes_path /var/amavisd/.spamassassin/bayes

All the bayes_sql* and bayes_store_module can be
removed/hashed out.

De default store module for bayes is DB_File (make sure
you have the DB_File perl module installed)


..with phpmyadmin I have view maia db, now I must remove all tables show for 
maia db ? and the I must add:


use_bayes 1

..in local.cf ?
Thanks again.

--
Salvatore.

RE: Bayes update

[Lina, Patrick]

Salvatore,

At least these must be configured:
 use_bayes 1
 bayes_path /var/amavisd/.spamassassin/bayes

All the bayes_sql* and bayes_store_module can be
removed/hashed out.

De default store module for bayes is DB_File (make sure
you have the DB_File perl module installed)


   Patrick

> -Original Message-
> From: Salvatore [mailto:[EMAIL PROTECTED] 
> Sent: dinsdag 31 juli 2007 12:14
> To: users@spamassassin.apache.org
> Cc: Lina, Patrick
> Subject: Re: Bayes update
> 
> "Lina, Patrick" wrote:
> >Looks to me you've configured mySQL as your Bayes database,
> >so the flat files in your 'bayes_path' aren't used.
> >Try checking if your mySQL DB gets updated.
> 
> ..if I don't want use mySQL as my Bayes database I must 
> disable in local.cf:
> 
> bayes_store_module  Mail::SpamAssassin::BayesStore::MySQL
> bayes_sql_dsn  DBI:mysql:maia:localhost
> bayes_sql_username  amavis
> bayes_sql_password  xxx
> bayes_sql_override_username amavis
> auto_whitelist_factory  Mail::SpamAssassin::SQLBasedAddrList
> user_awl_dsn  DBI:mysql:maia:localhost
> user_awl_sql_username  amavis
> user_awl_sql_password  
> 
> ??
> I don't have much familiarity with MySQL,
> Thanks.
> 
> --
> Salvatore.
> 
> 

Re: Bayes update

[Salvatore]

"Lina, Patrick" wrote:

Looks to me you've configured mySQL as your Bayes database,
so the flat files in your 'bayes_path' aren't used.
Try checking if your mySQL DB gets updated.


..if I don't want use mySQL as my Bayes database I must disable in local.cf:

bayes_store_module  Mail::SpamAssassin::BayesStore::MySQL
bayes_sql_dsn  DBI:mysql:maia:localhost
bayes_sql_username  amavis
bayes_sql_password  xxx
bayes_sql_override_username amavis
auto_whitelist_factory  Mail::SpamAssassin::SQLBasedAddrList
user_awl_dsn  DBI:mysql:maia:localhost
user_awl_sql_username  amavis
user_awl_sql_password  

??
I don't have much familiarity with MySQL,
Thanks.

--
Salvatore.

RE: Bayes update

[Lina, Patrick]

Hi Salvatore,

Looks to me you've configured mySQL as your Bayes database,
so the flat files in your 'bayes_path' aren't used.
Try checking if your mySQL DB gets updated.

Greetings,

   Patrick


> -Original Message-
> From: Salvatore [mailto:[EMAIL PROTECTED] 
> Sent: dinsdag 31 juli 2007 11:21
> To: users@spamassassin.apache.org
> Subject: Bayes update
> 
> Hi, I use SA-3.1.9 with amavisd-new and Maia...my problem is 
> that the bayes 
> aren't bring up to date, I have:
> 
> [EMAIL PROTECTED] ~]# ls -l /var/amavisd/.spamassassin/
> totale 32
> -rwxr-x--- 1 amavis amavis 12288 20 lug 17:40 auto-whitelist
> -rwxr-x--- 1 amavis amavis 12288 20 lug 17:32 bayes_seen
> -rwxr-x--- 1 amavis amavis 12288 20 lug 17:32 bayes_toks
> -rwxr-x--- 1 amavis amavis  1487 20 lug 17:40 user_prefs
> 
> ..my local.cf my is:
> 
> bayes_path /var/amavisd/.spamassassin/bayes
> auto_whitelist_path /var/amavisd/.spamassassin/auto_whitelist
> bayes_store_module  Mail::SpamAssassin::BayesStore::MySQL
> bayes_sql_dsn  DBI:mysql:maia:localhost
> bayes_sql_username  amavis
> bayes_sql_password  xxx
> bayes_sql_override_username amavis
> auto_whitelist_factory  Mail::SpamAssassin::SQLBasedAddrList
> user_awl_dsn  DBI:mysql:maia:localhost
> user_awl_sql_username  amavis
> user_awl_sql_password  
> 
> ..also file in:
> /var/lib/spamassassin/3.001099
> 
> are stop at 20 lug.
> Thanks.
> 
> --
> Salvatore.
> 
>