* 'pgsql-transport.cf'
- fixed query
* 'pgsql-smtpd_sender_login_maps.cf'
- added missing ' at end of query
--- a/ChangeLog Sun Mar 02 20:22:00 2008 +0000
+++ b/ChangeLog Sun Mar 02 22:41:59 2008 +0000
@@ -11,6 +11,8 @@
* VirtualMailManager/VirtualMailManager.py: some small fixes
* VirtualMailManager/Domain.py: Added Transport-stuff
* vmm.cfg: Added option transport in section misc
+ * pgsql-transport.cf: changed query for new table layout
+ * pgsql-smtpd_sender_login_maps.cf: added missing single quote in query
2008-02-02 Pascal Volk <neverseen@users.sourceforge.net>
--- a/pgsql-smtpd_sender_login_maps.cf Sun Mar 02 20:22:00 2008 +0000
+++ b/pgsql-smtpd_sender_login_maps.cf Sun Mar 02 22:41:59 2008 +0000
@@ -10,4 +10,4 @@
# Postfix 2.2 and later The SQL query template. See pgsql_table(5).
query = SELECT address FROM postfix_maildir WHERE address='%s'
- UNION SELECT destination FROM postfix_alias WHERE address='%s
+ UNION SELECT destination FROM postfix_alias WHERE address='%s'
--- a/pgsql-transport.cf Sun Mar 02 20:22:00 2008 +0000
+++ b/pgsql-transport.cf Sun Mar 02 22:41:59 2008 +0000
@@ -9,4 +9,4 @@
dbname = mailsys
# Postfix 2.2 and later The SQL query template. See pgsql_table(5).
-query = SELECT transport FROM postfix_transport WHERE domainname='%s'
+query = SELECT transport FROM postfix_transport WHERE address='%s'