Dear Gary,

Storing bayes in mysql with SA needs configuring in SA configs, not in 
amavisd-new config files. So you need to edit your SA local.cf file with 
something similar:

bayes_store_module           Mail::SpamAssassin::BayesStore::SQL
bayes_sql_dsn                   DBI:mysql:SA:127.0.0.1:3306
bayes_sql_username              amavis_username
bayes_sql_password              password
bayes_sql_override_username     amavis_username

Same thing with SQL based AWL:
user_awl_dsn                    DBI:mysql:SA:127.0.0.1:3306
user_awl_sql_username           amavis_username
user_awl_sql_password           password

Amavis just loads SpamAssassin with its config...

regards, Jernej

Gary Chodos wrote:
> we are storing bayes in mysql now, so to load the modules I tried the
> following in amavisd.conf:
> 
> @additional_perl_modules = qw(
>       Mail::SpamAssassin::BayesStore::SQL
>       Mail::SpamAssassin::BayesStore::MySQL
>       Mail::SpamAssassin::SQLBasedAddrList
>       Mail::SpamAssassin::CompiledRegexps::body_0
>     );
> 
> but after amavisd reload, in the logs there is no mention of these
> modules being loaded.  What else do we need to do?  thanks.
> 
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
> trial. Simplify your report design, integration and deployment - and focus on 
> what you do best, core application coding. Discover what's new with 
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> AMaViS-user mailing list
> AMaViS-user@lists.sourceforge.net 
> https://lists.sourceforge.net/lists/listinfo/amavis-user 
>  AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 
>  AMaViS-HowTos:http://www.amavis.org/howto/ 


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net 
https://lists.sourceforge.net/lists/listinfo/amavis-user 
 AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 
 AMaViS-HowTos:http://www.amavis.org/howto/ 

Reply via email to