[vhffs-dev] [703] Updated exim configuration for mirrored DB.

[subversion@xxxxxxxxx]

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