download template 

https://www.mediafire.com/file/460he7fs88mkegg/db_template_policyd_carbonio_raystinger.zip/file

read instructions included on file 

note :

include quota send per minutes , whitelist incoming/outgoing only .

my configurations only allowed listed domain for in and out

good luck

1. enable carbonio policyd service as zextras

zmprov ms $(zmhostname) +zimbraServiceInstalled cbpolicyd +zimbraServiceEnabled cbpolicyd

2. enable access control for link to policyd

carbonio prov ms `zmhostname` zimbraCBPolicydAccessControlEnabled TRUE

3. edit database configuration as root 

nano  /opt/zextras/common/share/webui/includes/config.php

then make sure your config similiar like this

#$DB_DSN="mysql:host=localhost;dbname=cluebringer";
$DB_DSN="sqlite:/opt/zextras/data/cbpolicyd/db/cbpolicyd.sqlitedb";
$DB_USER="root";

4. install required apps

apt install apache2 libapache2-mod-php php-sqlite3

5. as root do

sed -i 's/Listen 80/Listen 7780/g' /etc/apache2/ports.conf

 

ln -s /opt/zextras/common/share/webui /var/www/html/

 

cd /opt/zextras/data/cbpolicyd
chmod -R 777 db/

systemctl restart apache2

6. finaly open your policyd  

http://your IP:7780/webui/