
#Spamassassin password#
Where is the name of the MySQL user and is the password for the MySQL user account on the remote server and where is the FQDN of the remote host already running the Spamassassin MySQL Database engine. Zmlocalconfig -e antispam_mysql_password= On local server zmlocalconfig -e antispam_mysql_user= To enable the local MTA server to access the remote Spamassassin MySQL Database, as the zimbra user, run the following commands on the local server: On remote server zmlocalconfig -s antispam_mysql_user This can be obtained by running the following commands as the zimbra user: To configure Spamassassin to utilize a remote Spamassassin MySQL Database server, the user name and password of the remote Spamassassin MySQL Database is required. Optionally in a multi-node environment, if a Spamassassin MySQL Database server is already running on another MTA node, Spamassassin can be configured to utilize that remote Spamassassin MySQL Database (instead of running an additional MySQL database instance). Migrating existing Bayes data (from Berkeley DB to MySQL DB) is currently not supported.Īccessing a Remote Spamassassin MySQL Database Sending a message like this is the default method of spam notification under SpamAssassin. Migrating to (Default) Berkeley DB Format Database If SpamAssassin is configured to run this test, and a message is processed by the server that contains the string this is a test of spamassassin, a message similar to that in Figure 3.16 should be sent to the recipient. Zmlocalconfig -e antispam_mysql_enabled=FALSE Reverting to (Default) Berkeley DB Format Database Zmlocalconfig -e antispam_mysql_enabled=TRUE Spam-assassin and ClamAV are the tools to block spam and viruses, however amavis is required to tie this all together. A MySQL database affords increased performance to SpamAssassin and message processing as it allows for concurrent access to the indexed database.Īlthough there is some overhead in running and maintaining an extra MySQLĭatabase instance, the performance gains may warrant this extra overhead.Īs the zimbra user, run the following commands:

Thus the default for SpamAssassin to use the Berkeley DB format database may not be ideal.Īlternatively, SpamAssassin can be configured to use a dedicated MySQL back-endĭatabase on an MTA node to store its Bayes filtering data. The Berkeley DB format database implementation in SpamAssassin uses a sequential locking mechanism which can impede message processing for larger ZCS installations. Below are the ones which I have followed for testing.

I have gone through different docs regarding the same. I would like to reject emails especially Chinese. This is certified documentation and is protected for editing by Zimbra Employees & Moderators only.īy default, SpamAssassin in Zimbra ZCS utilizes a Berkeley DB format database for it's Bayes filtering data. Hi, I would like to do global filtering of foreign language emails using Spamassasin.
