Initial setup of matrix with mautrix-whatsapp

1 files changed, 8 insertions, 0 deletions

diff --git a/TODOs.org b/TODOs.org
index 0504aef..2d60619 100644
--- a/TODOs.org
+++ b/TODOs.org
@@ -138,3 +138,11 @@ magnitute harder for the attacker.
 ** Enable 2FA for Nextcloud?
 Do XMPP support that too?
 * Scrath
+initialScript = pkgs.writeText "synapse-init.sql" ''
+  CREATE ROLE "matrix-synapse" WITH LOGIN PASSWORD '${synapseDBPassword}';
+
+  CREATE DATABASE "matrix-synapse" WITH OWNER "matrix-synapse"
+    TEMPLATE template0
+    LC_COLLATE = "C"
+    LC_CTYPE = "C";
+'';