Postfix Zarafa DB plugin integration

From Zarafa wiki

(Difference between revisions)
Jump to: navigation, search
m
(can't get it to work on 6.40.4, perhaps query issue?)
(3 intermediate revisions not shown)
Line 2: Line 2:
Postfix has the possibility to couple also to a MySQL backend for recipient checking and aliases resolving.
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.
Via the following configuration file, you can integrate Postfix with the Zarafa MySQL database.
 +
 +
'''UPDATE NOTICE:''' This section is probably out of date and is not guaranteed to work with the latest Zarafa versions. Please proceed with caution.
 +
 +
'''Note:''' When using Red Hat or Centos Postfix doesn't have the mysql module included. You can use the Postfix from the [http://mirror.centos.org/centos/5/centosplus Centos Plus] repository.
 +
 +
'''Note #2:''' For Ubuntu and Debian you might need to install the <tt>postfix-mysql</tt> package.
'''Postfix main.cf'''
'''Postfix main.cf'''
Line 13: Line 19:
  mynetworks = 127.0.0.0/8
  mynetworks = 127.0.0.0/8
  mailbox_transport = zarafa:
  mailbox_transport = zarafa:
-
  zarafa_recipient_limit = 1
+
  zarafa_destination_recipient_limit = 1
  inet_interfaces = all
  inet_interfaces = all
Line 26: Line 32:
  query = select value from objectproperty where objectid=(select objectid from objectproperty where value='%s' limit 1) and propname='loginname';
  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.
+
This configuration only resolves the primary mail address of an user. Aliases should be kept in the /etc/aliases file or an extra aliases MySQL table.

Revision as of 15:34, 5 January 2011

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.

UPDATE NOTICE: This section is probably out of date and is not guaranteed to work with the latest Zarafa versions. Please proceed with caution.

Note: When using Red Hat or Centos Postfix doesn't have the mysql module included. You can use the Postfix from the Centos Plus repository.

Note #2: For Ubuntu and Debian you might need to install the postfix-mysql package.

Postfix main.cf

mydomain = demo.zarafa.com
myhostname = host
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_destination_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 resolves the primary mail address of an user. Aliases should be kept in the /etc/aliases file or an extra aliases MySQL table.

Personal tools