> 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 ------------------------------------------------------- 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/
