(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