IRedMail/FAQ/Store.SpamAssassin.Bayes.In.SQL
From iRedMail
(Difference between revisions)
(Created page with '__TOC__ '''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 …') |
(→Summary) |
||
| Line 6: | Line 6: | ||
This article is used to configure related components to store SpamAssassin Bayes data in SQL server. | This article is used to configure related components to store SpamAssassin Bayes data in SQL server. | ||
| - | Tested with | + | Tested with: |
* iRedMail-0.8.0 with MySQL backend. | * iRedMail-0.8.0 with MySQL backend. | ||
| Line 14: | Line 14: | ||
* MySQL-5.1.61 | * 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 iRedMail releases. We take iRedMail-'''0.8.0''' for example. | ||
Revision as of 13:44, 16 May 2012
Contents |
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):
| File: local.cf |
use_bayes 1 bayes_auto_learn 1 bayes_auto_expire 1 # Store bayesian data in SQL database # For MySQL bayes_store_module Mail::SpamAssassin::BayesStore::MySQL bayes_sql_dsn DBI:mysql:sa_bayes:127.0.0.1:3006 # For PostgreSQL #bayes_store_module Mail::SpamAssassin::BayesStore::PgSQL #bayes_sql_dsn DBI:Pg:sa_bayes:127.0.0.1:5432 bayes_sql_username db_username bayes_sql_password db_password bayes_sql_override_username vmail |
