Postfix Zarafa DB plugin integration
From Zarafa wiki
The Zarafa DB user plugin will store all user information inside the MySQL database. Postfix has the possibility to couple also to a MySQL backend for recipient checking and aliases resolving. Via the following configuration file, you can integrate Postfix with the Zarafa MySQL database.
Postfix main.cf
myhostname = zarafa alias_maps = hash:/etc/aliases alias_database = hash:/etc/aliases virtual_alias_maps = mysql:/etc/postfix/mysql-aliases.cf myorigin = /etc/mailname mydestination = $myhostname, $myhostname.local, localhost, $mydomain mynetworks = 127.0.0.0/8 mailbox_transport = zarafa: zarafa_recipient_limit = 1 inet_interfaces = all
Postfix mysql-aliases.cf
# The user name and password to log into the mysql server. user = root password = zarafa hosts = 127.0.0.1 dbname = zarafa # For Postfix 2.2 and later The SQL query template. # See mysql_table(5) for details. query = select value from objectproperty where objectid=(select objectid from objectproperty where value='%s' limit 1) and propname='loginname';
This configuration only resolv the primary mailaddress of an user. Aliases should be kept in the /etc/aliases file or an extra aliases MySQL table.