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(-)
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