[vhffs-dev] [703] Updated exim configuration for mirrored DB. |
[ Thread Index |
Date Index
| More vhffs.org/vhffs-dev Archives
]
Revision: 703
Author: beuss
Date: 2007-07-09 11:04:23 +0000 (Mon, 09 Jul 2007)
Log Message:
-----------
Updated exim configuration for mirrored DB.
View definition missed -request ml addresses.
Modified Paths:
--------------
trunk/vhffs-backend/src/pgsql/initdb.sql.in
trunk/vhffs-doc/config/exim4-mx2/exim4.conf
Modified: trunk/vhffs-backend/src/pgsql/initdb.sql.in
===================================================================
--- trunk/vhffs-backend/src/pgsql/initdb.sql.in 2007-07-09 09:38:11 UTC (rev 702)
+++ trunk/vhffs-backend/src/pgsql/initdb.sql.in 2007-07-09 11:04:23 UTC (rev 703)
@@ -395,7 +395,9 @@
UNION
SELECT local_part, domain FROM vhffs_forward
UNION
- SELECT local_part, domain FROM vhffs_ml) AS a
+ SELECT local_part, domain FROM vhffs_ml
+ UNION
+ SELECT local_part || '-request' AS local_part, domain FROM vhffs_ml) AS a
INNER JOIN vhffs_mxdomain d ON d.domain = a.domain
INNER JOIN vhffs_object o ON o.object_id = d.object_id
WHERE o.state = 6;
Modified: trunk/vhffs-doc/config/exim4-mx2/exim4.conf
===================================================================
--- trunk/vhffs-doc/config/exim4-mx2/exim4.conf 2007-07-09 09:38:11 UTC (rev 702)
+++ trunk/vhffs-doc/config/exim4-mx2/exim4.conf 2007-07-09 11:04:23 UTC (rev 703)
@@ -1,6 +1,9 @@
hide pgsql_servers = PGHOST/PGDB/PGUSER/PGPASS
PGSQL_RELAY_DOMAIN = ${lookup pgsql{SELECT domain FROM vhffs_mxdomain WHERE domain = '$domain'}}
+# Use this query if your MX2 directly uses VHFFS database
PGSQL_RELAY_CHECKLOCALPART = ${lookup pgsql{SELECT d.domain FROM vhffs_mxdomain d WHERE d.domain = '$domain' AND (d.catchall != '' OR EXISTS (SELECT domain FROM vhffs_boxes WHERE domain = '$domain' AND local_part = '$local_part') OR EXISTS (SELECT domain FROM vhffs_forward WHERE domain = '$domain' AND local_part = '$local_part') OR EXISTS (SELECT domain FROM vhffs_ml WHERE domain = '$domain' AND (local_part = '$local_part' OR local_part || '-request' = '$local_part')))}}
+# Use this query if your MX has a mirrored VHFFS db (using mirror-mx2.pl)
+# PGSQL_RELAY_CHECKLOCALPART = ${lookup pgsql{SELECT d.domain FROM vhffs_mxdomain WHERE d.domain = '$domain' AND (d.catchall != '' OR EXISTS (SELECT domain FROM vhffs_addresses WHERE domain = '$domain' AND local_part = '$local_part'))}}
exim_path = /usr/sbin/exim4