From iRedMail

THIS ARTICLE IS STILL A DRAFT, DO NOT APPLY IT IN PRODUCTION SERVER.

Summary

This article is used to configure related components to store SpamAssassin Bayes data in SQL server.

Tested with:

• iRedMail-0.8.0 with MySQL backend.
• CentOS 6.2 (x86_64)
• SpamAssassin-3.3.1
• Amavisd-new-2.6.6
• MySQL-5.1.61

Notes:

• This article should work with all iRedMail releases. We take iRedMail-0.8.0 for example.
• This article should work with all backends: OpenLDAP, MySQL, PostgreSQL. We take MySQL backend for example.
• This article should work with Amavisd-new-2.6.0 and later versions, includes Amavisd-new-2.7.x.

Create required SQL database used to store bayes data

Enable Bayes modules in SpamAssassin

Edit /etc/mail/spamassassin/local.cf, add (or modify below settings):

use_bayes          1
bayes_auto_learn   1
bayes_auto_expire  1

# Store bayesian data in MySQL
bayes_store_module Mail::SpamAssassin::BayesStore::MySQL
bayes_sql_dsn      DBI:mysql:sa_bayes:127.0.0.1:3006

# Store bayesian data in PostgreSQL
#bayes_store_module Mail::SpamAssassin::BayesStore::PgSQL
#bayes_sql_dsn      DBI:Pg:sa_bayes:127.0.0.1:5432

bayes_sql_username sa_user
bayes_sql_password sa_user_password

# Override the username used for storing
# data in the database. This could be used to group users together to
# share bayesian filter data. You can also use this config option to
# trick sa-learn to learn data as a specific user.
bayes_sql_override_username vmail