postfix/pgsql-virtual_mailbox_domains.cf
author "martin f. krafft" <madduck@debian.org>
Tue, 07 Aug 2012 21:53:41 +0000
changeset 582 605f8c115711
parent 159 78b6b06188d3
permissions -rw-r--r--
Due to the UNION query in address_list, the assumption that the list of gids received from the database would be continuous does not hold. To prevent addresses for domains with multiple entry types from being listed, it is necessary to check the list of domain gids for every entry. Signed-off-by: martin f. krafft <madduck@debian.org> --- VirtualMailManager/common.py | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-)
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
105
0332b85f55e1 Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents: 76
diff changeset
     1
# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS
0332b85f55e1 Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents: 76
diff changeset
     2
#
0332b85f55e1 Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents: 76
diff changeset
     3
# The hosts that Postfix will try to connect to and query from.
0332b85f55e1 Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents: 76
diff changeset
     4
hosts = localhost
11
7a5bd38c5b98 * 'pgsql-virtual_mailbox_domains.cf'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     5
7a5bd38c5b98 * 'pgsql-virtual_mailbox_domains.cf'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     6
# The user name and password to log into the pgsql server.
7a5bd38c5b98 * 'pgsql-virtual_mailbox_domains.cf'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     7
user = postfix
7a5bd38c5b98 * 'pgsql-virtual_mailbox_domains.cf'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     8
password = some_password
7a5bd38c5b98 * 'pgsql-virtual_mailbox_domains.cf'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     9
7a5bd38c5b98 * 'pgsql-virtual_mailbox_domains.cf'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    10
# The database name on the servers.
7a5bd38c5b98 * 'pgsql-virtual_mailbox_domains.cf'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    11
dbname = mailsys
7a5bd38c5b98 * 'pgsql-virtual_mailbox_domains.cf'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    12
105
0332b85f55e1 Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents: 76
diff changeset
    13
# The SQL query template used to search the database
0332b85f55e1 Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents: 76
diff changeset
    14
query = SELECT gid FROM postfix_gid WHERE domainname='%s'