postfix/pgsql-smtpd_sender_login_maps.cf
author martin f. krafft <madduck@madduck.net>
Sun, 15 Apr 2012 13:17:21 +0200
branchv0.6.x
changeset 555 499c63f52462
parent 491 320531aa1280
permissions -rw-r--r--
Provide list{addresses,aliases,users,relocated} subcommands The patch provides the list{addresses,aliases,users,relocated} subcommands to the UI. All commands actually take the same path in the code and only one query is run with different parameters for each case. There are still two shortcomings: 1. With alias domains, the output order is not as one might want it, e.g. foo@example.org bar@example.org foo@example.com bar@example.com when it should really be foo@ twice and then bar@ twice. I have not found a way to modify the SQL accordingly. 2. The SELECT queries for Accounts, Alias and Relocated are hard-coded in common.py.
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: 73
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: 73
diff changeset
     2
#
0332b85f55e1 Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents: 73
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: 73
diff changeset
     4
hosts = localhost
0
bb0aa2102206 Initial import @sf.net
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     5
bb0aa2102206 Initial import @sf.net
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     6
# The user name and password to log into the pgsql server.
bb0aa2102206 Initial import @sf.net
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     7
user = postfix
bb0aa2102206 Initial import @sf.net
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     8
password = some_password
bb0aa2102206 Initial import @sf.net
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     9
bb0aa2102206 Initial import @sf.net
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    10
# The database name on the servers.
bb0aa2102206 Initial import @sf.net
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    11
dbname = mailsys
bb0aa2102206 Initial import @sf.net
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: 73
diff changeset
    13
# XXX see create_optional_types_and_functions.pgsql
0332b85f55e1 Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents: 73
diff changeset
    14
# 	* line  9: type sender_login
0332b85f55e1 Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents: 73
diff changeset
    15
# 	* line 26: function postfix_smtpd_sender_login_map + comment above
0332b85f55e1 Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents: 73
diff changeset
    16
#
0332b85f55e1 Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents: 73
diff changeset
    17
# The SQL query template used to search the database
491
320531aa1280 postfix: Uncommented the query in pgsql-smtpd_sender_login_maps.cf.
Pascal Volk <user@localhost.localdomain.org>
parents: 159
diff changeset
    18
query = SELECT login FROM postfix_smtpd_sender_login_map('%u', '%d')