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. --- pleroma/otp/tasks/main.yaml | 4 ++++ pleroma/otp/templates/setup_db.psql.j2 | 3 ++- 2 files changed, 6 insertions(+), 1 deletion(-) (limited to 'pleroma') diff --git a/pleroma/otp/tasks/main.yaml b/pleroma/otp/tasks/main.yaml index 4aeec9e..de6b8ed 100644 --- a/pleroma/otp/tasks/main.yaml +++ b/pleroma/otp/tasks/main.yaml @@ -11,6 +11,10 @@ - "libmagic-dev" - "libtinfo5" +- name: install libssl1.1 deb + become: yes + apt: deb="http://ports.ubuntu.com/pool/main/o/openssl/libssl1.1_1.1.1f-1ubuntu2_{{arch}}.deb" + - name: create pleroma config and data directories become: yes file: diff --git a/pleroma/otp/templates/setup_db.psql.j2 b/pleroma/otp/templates/setup_db.psql.j2 index 1b27174..8fc10cf 100644 --- a/pleroma/otp/templates/setup_db.psql.j2 +++ b/pleroma/otp/templates/setup_db.psql.j2 @@ -1,4 +1,5 @@ -CREATE USER {{pleroma_db_user}} WITH ENCRYPTED PASSWORD '{{pleroma_db_passwd}}'; +CREATE USER {{pleroma_db_user}}; +ALTER USER {{pleroma_db_user}} WITH ENCRYPTED PASSWORD '{{pleroma_db_passwd}}'; CREATE DATABASE {{pleroma_db}} WITH OWNER {{pleroma_db_user}}; \c {{pleroma_db}}; --Extensions made by ecto.migrate that need superuser access -- cgit v1.2.3