How to enable antispam mysql

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
(a) Turn on this localconfig key
 su - zimbra
 zmlocalconfig -e antispam_mysql_enabled=true

(b) Initialize the db
 su - zimbra
~/libexec/zmantispamdbinit
(c) Try to  access to the db
 su - zimbra
 antispam-mysql zimbra_antispam
  show tables;
+---------------------------+
| Tables_in_zimbra_antispam |
+---------------------------+
| bayes_expire              |
| bayes_global_vars         |
| bayes_seen                |
| bayes_token               |
| bayes_vars                |
+---------------------------+
5 rows in set (0)

 The config file is /opt/zimbra/conf/antispam-my.cnf
 The pid and socket  files are in /opt/zimbra/data/amavisd/mysql
 The log file is /opt/zimbra/log/antispam-mysqld.log
 The create database script is located in /opt/zimbra/data/amavisd/mysql/antispamdb.sql
 http://bugzilla.zimbra.com/buglist.cgi?quicksearch=antispam
 
Jump to: navigation, search