From 7b1044eb94621cc07e2b201bb9242d24dea1af6d Mon Sep 17 00:00:00 2001 From: Gregor Kleen Date: Fri, 6 May 2022 00:13:21 +0200 Subject: surtr: ... --- hosts/surtr/email/default.nix | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'hosts/surtr') diff --git a/hosts/surtr/email/default.nix b/hosts/surtr/email/default.nix index 265207cc..de8ea04b 100644 --- a/hosts/surtr/email/default.nix +++ b/hosts/surtr/email/default.nix @@ -349,7 +349,7 @@ in { args = ${pkgs.writeText "dovecot-sql.conf" '' driver = pgsql connect = dbname=email - user_query = SELECT DISTINCT ON (local IS NULL) "user", quota_rule, 'dovecot2' as uid, 'dovecot2' as gid FROM lmtp_mapping WHERE (local = '%n' AND domain = '%d') OR (local IS NULL AND domain = '%d') ORDER BY ((local IS NULL) ASC) + user_query = SELECT DISTINCT ON (local IS NULL) "user", quota_rule, 'dovecot2' as uid, 'dovecot2' as gid FROM lmtp_mapping WHERE (local = '%n' AND domain = '%d') OR (local IS NULL AND domain = '%d') ORDER BY (local IS NULL) ASC ''} skip = never -- cgit v1.2.3