diff options
author | Gregor Kleen <gkleen@yggdrasil.li> | 2022-05-06 00:06:14 +0200 |
---|---|---|
committer | Gregor Kleen <gkleen@yggdrasil.li> | 2022-05-06 00:06:14 +0200 |
commit | d273c73163f21c515039a1800b9d71c6002edae8 (patch) | |
tree | 2ba915c3921327e9c4b13f6914ad45c8959196f9 /hosts/surtr | |
parent | c7d0bc58c1a38042f88e68d12eb845fcfb7df4c0 (diff) | |
download | nixos-d273c73163f21c515039a1800b9d71c6002edae8.tar nixos-d273c73163f21c515039a1800b9d71c6002edae8.tar.gz nixos-d273c73163f21c515039a1800b9d71c6002edae8.tar.bz2 nixos-d273c73163f21c515039a1800b9d71c6002edae8.tar.xz nixos-d273c73163f21c515039a1800b9d71c6002edae8.zip |
surtr: ...
Diffstat (limited to 'hosts/surtr')
-rw-r--r-- | hosts/surtr/email/default.nix | 1 | ||||
-rw-r--r-- | hosts/surtr/postgresql.nix | 9 |
2 files changed, 9 insertions, 1 deletions
diff --git a/hosts/surtr/email/default.nix b/hosts/surtr/email/default.nix index b3306ece..9abb9a7e 100644 --- a/hosts/surtr/email/default.nix +++ b/hosts/surtr/email/default.nix | |||
@@ -319,7 +319,6 @@ in { | |||
319 | auth_ssl_username_from_cert = yes | 319 | auth_ssl_username_from_cert = yes |
320 | ssl_cert_username_field = commonName | 320 | ssl_cert_username_field = commonName |
321 | auth_mechanisms = external | 321 | auth_mechanisms = external |
322 | auth_username_format = %n | ||
323 | 322 | ||
324 | auth_verbose = yes | 323 | auth_verbose = yes |
325 | verbose_ssl = yes | 324 | verbose_ssl = yes |
diff --git a/hosts/surtr/postgresql.nix b/hosts/surtr/postgresql.nix index bbe8d01b..28ccd8c4 100644 --- a/hosts/surtr/postgresql.nix +++ b/hosts/surtr/postgresql.nix | |||
@@ -56,6 +56,15 @@ in { | |||
56 | 56 | ||
57 | CREATE VIEW lmtp_mapping ("user", quota_rule, local, domain) AS SELECT mailbox.mailbox AS "user", (CASE WHEN quota_bytes IS NULL THEN '*:ignore' ELSE '*:bytes=' || quota_bytes END) AS quota_rule, local, domain FROM mailbox INNER JOIN mailbox_mapping ON mailbox.id = mailbox_mapping.mailbox; | 57 | CREATE VIEW lmtp_mapping ("user", quota_rule, local, domain) AS SELECT mailbox.mailbox AS "user", (CASE WHEN quota_bytes IS NULL THEN '*:ignore' ELSE '*:bytes=' || quota_bytes END) AS quota_rule, local, domain FROM mailbox INNER JOIN mailbox_mapping ON mailbox.id = mailbox_mapping.mailbox; |
58 | COMMIT; | 58 | COMMIT; |
59 | |||
60 | BEGIN; | ||
61 | SELECT _v.register_patch('002-citext', ARRAY['000-base'], null); | ||
62 | |||
63 | CREATE EXTENSION citext; | ||
64 | ALTER TABLE mailbox ALTER mailbox TYPE citext; | ||
65 | ALTER TABLE mailbox_mapping ALTER local TYPE citext; | ||
66 | ALTER TABLE mailbox_mapping ALTER domain TYPE citext; | ||
67 | COMMIT; | ||
59 | ''} | 68 | ''} |
60 | ''; | 69 | ''; |
61 | }; | 70 | }; |