Many thanks Mark, I missed that one. Nearly ok now! On Sun, 23 Oct 2005, Mark Martinec wrote:
> Date: Sun, 23 Oct 2005 22:30:10 +0200 > From: Mark Martinec <[EMAIL PROTECTED]> > To: [email protected] > Cc: [email protected] > Subject: Re: [AMaViS-user] SpamAssassin and postgresql > > > Not sure it's related to amavis, but I'm testing amavis 2.3.3 with > > spamassassin 3.1 and I can't seem to be able tgo use spamassassin with > > posgresql. > > > > I've set up a /etc/mail/spamassassin/db.cf like this: > > bayes_sql_dsn DBI:Pg:dbname=spam:host=localhost > > bayes_sql_username amavis > > user_scores_sql_username amavis > > user_scores_dsn DBI:Pg:dbname=spam;host=localhost > > > > And spamassassin is still using DB file. > > You probably forgot to turn it on. > See SA documentation file sql/README.bayes : > > The directives required to turn on the SQL based bayesian storage are: > > bayes_store_module Mail::SpamAssassin::BayesStore::SQL > > This directive is used by the Bayes module to determine which storage > module should be used. If not set it will default to: > Mail::SpamAssassin::BayesStore::DBM > > There is also a MySQL specific storage driver available to provides a > small boost in performance. It requires version 4.1 or above of the > MySQL database software to work properly. In addition, it provides > rollback on error functionality if you create your bayes database > table using the InnoDB storage engine (ie s/MyISAM/InnoDB/ on the > bayes_mysql.sql file). WARNING: Using this module with a version of > MySQL < 4.1 could have unexpected results. To use the MySQL 4.1+ > specific module set your bayes_store_module directive accordingly: > > bayes_store_module Mail::SpamAssassin::BayesStore::MySQL > > > Mark > > -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 15, Chemin des Monges +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: [email protected] ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery) ------------------------------------------------------- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today * Register for a JBoss Training Course Free Certification Exam for All Training Attendees Through End of 2005 Visit http://www.jboss.com/services/certification for more information _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
