From fbe1b755f3cfc0eda924c0810a938c8ab157933c Mon Sep 17 00:00:00 2001
From: Gregor Kleen <gkleen@yggdrasil.li>
Date: Thu, 5 May 2022 23:33:08 +0200
Subject: surtr: ...

---
 hosts/surtr/email/default.nix | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

(limited to 'hosts/surtr/email')

diff --git a/hosts/surtr/email/default.nix b/hosts/surtr/email/default.nix
index f73b4be0..8889991c 100644
--- a/hosts/surtr/email/default.nix
+++ b/hosts/surtr/email/default.nix
@@ -139,9 +139,14 @@ in {
         virtual_mailbox_domains = ''pgsql:${pkgs.writeText "virtual_mailbox_domains.cf" ''
           hosts = postgresql:///email
           dbname = email
-          query = SELECT domain FROM virtual_mailbox_domain WHERE domain = '%s'
+          query = SELECT 1 FROM virtual_mailbox_domain WHERE domain = '%s'
         ''}'';
         virtual_mailbox_maps = ''pgsql:${pkgs.writeText "virtual_mailbox_maps.cf" ''
+          hosts = postgresql:///email
+          dbname = email
+          query = SELECT 1 FROM virtual_mailbox_mapping WHERE lookup = '%s'
+        ''}'';
+        lmtp_generic_maps = ''pgsql:${pkgs.writeText "virtual_mailbox_maps.cf" ''
           hosts = postgresql:///email
           dbname = email
           query = SELECT mailbox FROM virtual_mailbox_mapping WHERE lookup = '%s'
-- 
cgit v1.2.3