From 04edbf561c44e28753cbbaa3870b23b220cc644c Mon Sep 17 00:00:00 2001 From: Luke Hoersten Date: Sun, 4 Feb 2024 20:27:19 -0600 Subject: Tons of updates to fix migration to new server. --- prosody/templates/setup_db.psql.j2 | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'prosody') diff --git a/prosody/templates/setup_db.psql.j2 b/prosody/templates/setup_db.psql.j2 index 25e9ec0..fd4f430 100644 --- a/prosody/templates/setup_db.psql.j2 +++ b/prosody/templates/setup_db.psql.j2 @@ -1,2 +1,3 @@ -CREATE USER {{prosody_db}} WITH ENCRYPTED PASSWORD '{{prosody_db_pass}}'; +CREATE USER {{prosody_db}}; +ALTER USER {{prosody_db}} WITH PASSWORD '{{prosody_db_pass}}'; CREATE DATABASE {{prosody_db}} ENCODING 'UTF8' LC_COLLATE='C.UTF-8' LC_CTYPE='C.UTF-8' template=template0 OWNER {{prosody_db}}; -- cgit v1.2.3