Postfix Zarafa DB plugin integration - Revision history

Matthijs: can't get it to work on 6.40.4, perhaps query issue?

2011-01-05T15:34:39Z

can't get it to work on 6.40.4, perhaps query issue?

← Older revision		Revision as of 15:34, 5 January 2011
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.

Gertvdijk: added Ubuntu/Debian postfix-mysql

2010-03-12T10:21:18Z

added Ubuntu/Debian postfix-mysql

← Older revision		Revision as of 10:21, 12 March 2010
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.
-

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

		+	'''Note #2:''' For Ubuntu and Debian you might need to install the <tt>postfix-mysql</tt> package.

	'''Postfix main.cf'''		'''Postfix main.cf'''
Line 30:		Line 30:
	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.

Admin at 07:07, 4 April 2009

2009-04-04T07:07:43Z

← Older revision		Revision as of 07:07, 4 April 2009
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.
		+
		+
		+	'''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.
		+

	'''Postfix main.cf'''		'''Postfix main.cf'''

Admin at 07:48, 2 December 2008

2008-12-02T07:48:56Z

← Older revision		Revision as of 07:48, 2 December 2008
Line 13:		Line 13:
	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

Admin at 10:14, 19 September 2008

2008-09-19T10:14:18Z

← Older revision		Revision as of 10:14, 19 September 2008
Line 24:		Line 24:
	# For Postfix 2.2 and later The SQL query template.		# For Postfix 2.2 and later The SQL query template.
	# See mysql_table(5) for details.		# 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';	+	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.	+	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.

Admin at 18:11, 8 September 2008

2008-09-08T18:11:20Z

← Older revision		Revision as of 18:11, 8 September 2008
Line 4:		Line 4:

	'''Postfix main.cf'''		'''Postfix main.cf'''
-		+	mydomain = demo.zarafa.com
-	myhostname = ~~zarafa~~	+	myhostname = host
	alias_maps = hash:/etc/aliases		alias_maps = hash:/etc/aliases
	alias_database = hash:/etc/aliases		alias_database = hash:/etc/aliases

Admin: New page: 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 resolv...

2008-09-08T18:10:17Z

New page: 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 resolv...

New page

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.