# HG changeset patch # User Pascal Volk # Date 1256239846 0 # Node ID 78b6b06188d3b0011bb80fa7fb11d106783f3ed2 # Parent 6949f6eaf26e9ca2ddcef5d6dc59ff7b0ae01240 Moved Postfix PostgreSQL client configuration files into the postfix directory. diff -r 6949f6eaf26e -r 78b6b06188d3 install.sh --- a/install.sh Thu Oct 22 18:40:06 2009 +0000 +++ b/install.sh Thu Oct 22 19:30:46 2009 +0000 @@ -30,7 +30,7 @@ python setup.py clean --all >/dev/null install -b -m 0600 ${INSTALL_OPTS} vmm.cfg ${PREFIX}/etc/ -install ${INSTALL_OPTS_CF} pgsql-*.cf ${PF_CONFDIR}/ +install ${INSTALL_OPTS_CF} postfix/pgsql-*.cf ${PF_CONFDIR}/ install -m 0700 ${INSTALL_OPTS} vmm ${PREFIX}/sbin [ -d ${LOCALE_DIR} ] || mkdir -m 0755 -p ${LOCALE_DIR} @@ -70,7 +70,7 @@ done [ -d ${DOC_DIR}/examples ] || mkdir -m 0755 -p ${DOC_DIR}/examples -install -m 0644 ${INSTALL_OPTS} pgsql-*.cf ${DOC_DIR}/examples +install -m 0644 ${INSTALL_OPTS} postfix/pgsql-*.cf ${DOC_DIR}/examples install -m 0644 ${INSTALL_OPTS} vmm.cfg ${DOC_DIR}/examples echo diff -r 6949f6eaf26e -r 78b6b06188d3 pgsql-relocated_maps.cf --- a/pgsql-relocated_maps.cf Thu Oct 22 18:40:06 2009 +0000 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,14 +0,0 @@ -# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS -# -# The hosts that Postfix will try to connect to and query from. -hosts = localhost - -# The user name and password to log into the pgsql server. -user = postfix -password = some_password - -# The database name on the servers. -dbname = mailsys - -# The SQL query template used to search the database -query = SELECT destination FROM postfix_relocated WHERE address='%s' diff -r 6949f6eaf26e -r 78b6b06188d3 pgsql-smtpd_sender_login_maps.cf --- a/pgsql-smtpd_sender_login_maps.cf Thu Oct 22 18:40:06 2009 +0000 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,18 +0,0 @@ -# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS -# -# The hosts that Postfix will try to connect to and query from. -hosts = localhost - -# The user name and password to log into the pgsql server. -user = postfix -password = some_password - -# The database name on the servers. -dbname = mailsys - -# XXX see create_optional_types_and_functions.pgsql -# * line 9: type sender_login -# * line 26: function postfix_smtpd_sender_login_map + comment above -# -# The SQL query template used to search the database -#query = SELECT login FROM postfix_smtpd_sender_login_map('%u', '%d') diff -r 6949f6eaf26e -r 78b6b06188d3 pgsql-transport.cf --- a/pgsql-transport.cf Thu Oct 22 18:40:06 2009 +0000 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,14 +0,0 @@ -# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS -# -# The hosts that Postfix will try to connect to and query from. -hosts = localhost - -# The user name and password to log into the pgsql server. -user = postfix -password = some_password - -# The database name on the servers. -dbname = mailsys - -# The SQL query template used to search the database -query = SELECT transport FROM postfix_transport WHERE address='%s' diff -r 6949f6eaf26e -r 78b6b06188d3 pgsql-virtual_alias_maps.cf --- a/pgsql-virtual_alias_maps.cf Thu Oct 22 18:40:06 2009 +0000 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,14 +0,0 @@ -# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS -# -# The hosts that Postfix will try to connect to and query from. -hosts = localhost - -# The user name and password to log into the pgsql server. -user = postfix -password = some_password - -# The database name on the servers. -dbname = mailsys - -# The SQL query template used to search the database -query = SELECT destination FROM postfix_alias WHERE address='%s' diff -r 6949f6eaf26e -r 78b6b06188d3 pgsql-virtual_gid_maps.cf --- a/pgsql-virtual_gid_maps.cf Thu Oct 22 18:40:06 2009 +0000 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,14 +0,0 @@ -# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS -# -# The hosts that Postfix will try to connect to and query from. -hosts = localhost - -# The user name and password to log into the pgsql server. -user = postfix -password = some_password - -# The database name on the servers. -dbname = mailsys - -# The SQL query template used to search the database -query = SELECT gid FROM postfix_gid WHERE domainname='%d' diff -r 6949f6eaf26e -r 78b6b06188d3 pgsql-virtual_mailbox_domains.cf --- a/pgsql-virtual_mailbox_domains.cf Thu Oct 22 18:40:06 2009 +0000 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,14 +0,0 @@ -# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS -# -# The hosts that Postfix will try to connect to and query from. -hosts = localhost - -# The user name and password to log into the pgsql server. -user = postfix -password = some_password - -# The database name on the servers. -dbname = mailsys - -# The SQL query template used to search the database -query = SELECT gid FROM postfix_gid WHERE domainname='%s' diff -r 6949f6eaf26e -r 78b6b06188d3 pgsql-virtual_mailbox_maps.cf --- a/pgsql-virtual_mailbox_maps.cf Thu Oct 22 18:40:06 2009 +0000 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,14 +0,0 @@ -# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS -# -# The hosts that Postfix will try to connect to and query from. -hosts = localhost - -# The user name and password to log into the pgsql server. -user = postfix -password = some_password - -# The database name on the servers. -dbname = mailsys - -# The SQL query template used to search the database -query = SELECT maildir FROM postfix_maildir WHERE address='%s' diff -r 6949f6eaf26e -r 78b6b06188d3 pgsql-virtual_uid_maps.cf --- a/pgsql-virtual_uid_maps.cf Thu Oct 22 18:40:06 2009 +0000 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,14 +0,0 @@ -# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS -# -# The hosts that Postfix will try to connect to and query from. -hosts = localhost - -# The user name and password to log into the pgsql server. -user = postfix -password = some_password - -# The database name on the servers. -dbname = mailsys - -# The SQL query template used to search the database -query = SELECT uid FROM postfix_uid WHERE address='%s' diff -r 6949f6eaf26e -r 78b6b06188d3 postfix/pgsql-relocated_maps.cf --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/postfix/pgsql-relocated_maps.cf Thu Oct 22 19:30:46 2009 +0000 @@ -0,0 +1,14 @@ +# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS +# +# The hosts that Postfix will try to connect to and query from. +hosts = localhost + +# The user name and password to log into the pgsql server. +user = postfix +password = some_password + +# The database name on the servers. +dbname = mailsys + +# The SQL query template used to search the database +query = SELECT destination FROM postfix_relocated WHERE address='%s' diff -r 6949f6eaf26e -r 78b6b06188d3 postfix/pgsql-smtpd_sender_login_maps.cf --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/postfix/pgsql-smtpd_sender_login_maps.cf Thu Oct 22 19:30:46 2009 +0000 @@ -0,0 +1,18 @@ +# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS +# +# The hosts that Postfix will try to connect to and query from. +hosts = localhost + +# The user name and password to log into the pgsql server. +user = postfix +password = some_password + +# The database name on the servers. +dbname = mailsys + +# XXX see create_optional_types_and_functions.pgsql +# * line 9: type sender_login +# * line 26: function postfix_smtpd_sender_login_map + comment above +# +# The SQL query template used to search the database +#query = SELECT login FROM postfix_smtpd_sender_login_map('%u', '%d') diff -r 6949f6eaf26e -r 78b6b06188d3 postfix/pgsql-transport.cf --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/postfix/pgsql-transport.cf Thu Oct 22 19:30:46 2009 +0000 @@ -0,0 +1,14 @@ +# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS +# +# The hosts that Postfix will try to connect to and query from. +hosts = localhost + +# The user name and password to log into the pgsql server. +user = postfix +password = some_password + +# The database name on the servers. +dbname = mailsys + +# The SQL query template used to search the database +query = SELECT transport FROM postfix_transport WHERE address='%s' diff -r 6949f6eaf26e -r 78b6b06188d3 postfix/pgsql-virtual_alias_maps.cf --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/postfix/pgsql-virtual_alias_maps.cf Thu Oct 22 19:30:46 2009 +0000 @@ -0,0 +1,14 @@ +# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS +# +# The hosts that Postfix will try to connect to and query from. +hosts = localhost + +# The user name and password to log into the pgsql server. +user = postfix +password = some_password + +# The database name on the servers. +dbname = mailsys + +# The SQL query template used to search the database +query = SELECT destination FROM postfix_alias WHERE address='%s' diff -r 6949f6eaf26e -r 78b6b06188d3 postfix/pgsql-virtual_gid_maps.cf --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/postfix/pgsql-virtual_gid_maps.cf Thu Oct 22 19:30:46 2009 +0000 @@ -0,0 +1,14 @@ +# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS +# +# The hosts that Postfix will try to connect to and query from. +hosts = localhost + +# The user name and password to log into the pgsql server. +user = postfix +password = some_password + +# The database name on the servers. +dbname = mailsys + +# The SQL query template used to search the database +query = SELECT gid FROM postfix_gid WHERE domainname='%d' diff -r 6949f6eaf26e -r 78b6b06188d3 postfix/pgsql-virtual_mailbox_domains.cf --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/postfix/pgsql-virtual_mailbox_domains.cf Thu Oct 22 19:30:46 2009 +0000 @@ -0,0 +1,14 @@ +# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS +# +# The hosts that Postfix will try to connect to and query from. +hosts = localhost + +# The user name and password to log into the pgsql server. +user = postfix +password = some_password + +# The database name on the servers. +dbname = mailsys + +# The SQL query template used to search the database +query = SELECT gid FROM postfix_gid WHERE domainname='%s' diff -r 6949f6eaf26e -r 78b6b06188d3 postfix/pgsql-virtual_mailbox_maps.cf --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/postfix/pgsql-virtual_mailbox_maps.cf Thu Oct 22 19:30:46 2009 +0000 @@ -0,0 +1,14 @@ +# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS +# +# The hosts that Postfix will try to connect to and query from. +hosts = localhost + +# The user name and password to log into the pgsql server. +user = postfix +password = some_password + +# The database name on the servers. +dbname = mailsys + +# The SQL query template used to search the database +query = SELECT maildir FROM postfix_maildir WHERE address='%s' diff -r 6949f6eaf26e -r 78b6b06188d3 postfix/pgsql-virtual_uid_maps.cf --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/postfix/pgsql-virtual_uid_maps.cf Thu Oct 22 19:30:46 2009 +0000 @@ -0,0 +1,14 @@ +# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS +# +# The hosts that Postfix will try to connect to and query from. +hosts = localhost + +# The user name and password to log into the pgsql server. +user = postfix +password = some_password + +# The database name on the servers. +dbname = mailsys + +# The SQL query template used to search the database +query = SELECT uid FROM postfix_uid WHERE address='%s' diff -r 6949f6eaf26e -r 78b6b06188d3 upgrade.sh --- a/upgrade.sh Thu Oct 22 18:40:06 2009 +0000 +++ b/upgrade.sh Thu Oct 22 19:30:46 2009 +0000 @@ -94,6 +94,6 @@ done [ -d ${DOC_DIR}/examples ] || mkdir -m 0755 -p ${DOC_DIR}/examples -install -m 0644 ${INSTALL_OPTS} pgsql-*.cf ${DOC_DIR}/examples +install -m 0644 ${INSTALL_OPTS} postfix/pgsql-*.cf ${DOC_DIR}/examples install -m 0644 ${INSTALL_OPTS} vmm.cfg ${DOC_DIR}/examples