From c0bc067867644e7b74135e28d9d23b03e7cc069c Mon Sep 17 00:00:00 2001 From: Gregor Kleen Date: Thu, 5 May 2022 22:46:05 +0200 Subject: surtr: ... --- hosts/surtr/email/default.nix | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/hosts/surtr/email/default.nix b/hosts/surtr/email/default.nix index f30d9aaf..c3069a92 100644 --- a/hosts/surtr/email/default.nix +++ b/hosts/surtr/email/default.nix @@ -287,9 +287,9 @@ in { dovecotSqlConf = pkgs.writeText "dovecot-sql.conf" '' driver = pgsql connect = dbname=email - password_query = SELECT NULL as password, 'Y' as nopassword, user, quota_rule, 'dovecot2' as uid, 'dovecot2' as gid FROM imap_user WHERE user = '%u' - user_query = SELECT user, quota_rule, 'dovecot2' as uid, 'dovecot2' as gid FROM imap_user WHERE user = '%u' - iterate_query = SELECT user FROM imap_user + password_query = SELECT NULL as password, 'Y' as nopassword, "user", quota_rule, 'dovecot2' as uid, 'dovecot2' as gid FROM imap_user WHERE "user" = '%u' + user_query = SELECT "user", quota_rule, 'dovecot2' as uid, 'dovecot2' as gid FROM imap_user WHERE "user" = '%u' + iterate_query = SELECT "user" FROM imap_user ''; in '' mail_home = /var/lib/mail/%u -- cgit v1.2.3