Postfix Zarafa DB plugin integration

From Zarafa wiki

(Difference between revisions)
Jump to: navigation, search
(added Ubuntu/Debian postfix-mysql)
m (filename was misleading as it was called mysql-aliases.cf but resolves users.)
 
(One intermediate revision 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:''' 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.
Line 12: Line 14:
  alias_maps = hash:/etc/aliases
  alias_maps = hash:/etc/aliases
  alias_database = hash:/etc/aliases
  alias_database = hash:/etc/aliases
-
  virtual_alias_maps = mysql:/etc/postfix/mysql-aliases.cf
+
  virtual_alias_maps = mysql:/etc/postfix/mysql-users.cf
  myorigin = /etc/mailname
  myorigin = /etc/mailname
  mydestination = $myhostname, $myhostname.local, localhost, $mydomain
  mydestination = $myhostname, $myhostname.local, localhost, $mydomain
Line 20: Line 22:
  inet_interfaces = all
  inet_interfaces = all
-
'''Postfix mysql-aliases.cf'''
+
'''Postfix mysql-users.cf'''
  # The user name and password to log into the mysql server.
  # The user name and password to log into the mysql server.
  user = root
  user = root

Latest revision as of 14:53, 23 July 2013

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-users.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-users.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