Postfix Zarafa DB plugin integration

From Zarafa wiki

Revision as of 07:48, 2 December 2008 by Admin (Talk | contribs)
Jump to: navigation, search

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.


mydomain =
myhostname = host
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
virtual_alias_maps = mysql:/etc/postfix/
myorigin = /etc/mailname
mydestination = $myhostname, $myhostname.local, localhost, $mydomain
mynetworks =
mailbox_transport = zarafa:
zarafa_destination_recipient_limit = 1
inet_interfaces = all


# The user name and password to log into the mysql server.
user = root
password = zarafa
hosts =
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 resolves the primary mailaddress of an user. Aliases should be kept in the /etc/aliases file or an extra aliases MySQL table.

Personal tools