WARNING: This guide applies to Zimbra 8.0.0 and 8.0.1. If you are running Zimbra 8.0.2+ please find the official docs at Postfix Policyd - Zimbra :: Wiki
Hello everybody!Due to popular demand, I took some time to check out how to enable CBPolicyD in Zimbra 8 (right now this applies for both version 8.0.0 and 8.0.1)! Luckily the steps haven't changed a bit since Zimbra 7.1.1, so the guide posted HERE is still valid...
HOWEVER!!!
Two additional steps are required:
It looks like most of the files comprising the Web Interface for CBPolicyD are missing in the Zimbra 8.0.0 and 8.0.1 packages. If you want to obtain the missing files you should do the following:
- Point your browser at Download | Policyd
- Locate the "Unstable v2.1.x Snapshot" box and click on Download Now
- Download the "v2.1.x-201205100639" package in your favourite format (.tar.bz2, .tar.gz, .tar.xz or .zip)
- Unpack the package. You'll see that it contains 3 folders and a lot of .php and .css files.
- Copy the .php and .css files in the /opt/zimbra/cbpolicyd/share/webui/ directory in your Zimbra server
Now that you have all the files you need you can enable the WebUI in one of the 2 ways described in the original post.
Step 2: Initializing the database
Before enabling the CBPolicyD module you need to initialize it's database.
The initialization procedure for a SQLite Database is the following:
cd /opt/zimbra/cbpolicyd/share/database/
for i in core.tsql access_control.tsql quotas.tsql amavis.tsql checkhelo.tsql checkspf.tsql greylisting.tsql accounting.tsql
do
./convert-tsql sqlite $i
done > /tmp/db1.sql
sqlite3 /opt/zimbra/data/cbpolicyd/db/cbpolicyd.sqlitedb < /tmp/db1.sql
Special thanks to Mishikal for contributing some nice suggestions!
Enjoy!
Cine
cd /opt/zimbra/cbpolicyd/share/database/
for i in core.tsql access_control.tsql quotas.tsql amavis.tsql checkhelo.tsql checkspf.tsql greylisting.tsql accounting.tsql
do
./convert-tsql sqlite $i
done > /tmp/db1.sql
sqlite3 /opt/zimbra/data/cbpolicyd/db/cbpolicyd.sqlitedb < /tmp/db1.sql
Special thanks to Mishikal for contributing some nice suggestions!
Enjoy!
Cine