commit e4b97b3ec4d827773c2c3c5ad0d81b809e3bbbf9 parent 6de5bd557a4eba064fd78cc1b6d2e4f921a17d68 Author: MTRNord <mtrnord1@gmail.com> Date: Mon, 19 Jun 2023 16:11:41 +0200 Fix mailu Diffstat:
| M | apps/base/mailu/release.yaml | | | 19 | +++++++++++++++++++ |
1 file changed, 19 insertions(+), 0 deletions(-)
diff --git a/apps/base/mailu/release.yaml b/apps/base/mailu/release.yaml @@ -31,6 +31,25 @@ spec: image: tag: "14.8.0-debian-11-r14" primary: + initdb: + ## @skip postgresql.primary.initdb.scripts.create_roundcube_database.sh + ## DO NOT EDIT Script to create the roundcube database + scripts: + create_roundcube_database.sh: | + #!/bin/bash + # set -o errexit + # set -o nounset + # set -o pipefail + info "Running DB initialisation..." + info "Creating database ${ROUNDCUBE_DB_NAME}..." + echo "CREATE DATABASE \"$ROUNDCUBE_DB_NAME\"" | postgresql_execute "" "postgres" "$POSTGRES_POSTGRES_PASSWORD" + info "Creating user ${ROUNDCUBE_DB_USER}" + echo "CREATE ROLE \"${ROUNDCUBE_DB_USER}\" WITH LOGIN CREATEDB PASSWORD '${ROUNDCUBE_DB_PW}';" | postgresql_execute "" "postgres" "$POSTGRES_POSTGRES_PASSWORD" + info "Granting access to \"${ROUNDCUBE_DB_USER}\" to the database \"${ROUNDCUBE_DB_NAME}\"" + echo "GRANT ALL PRIVILEGES ON DATABASE \"${ROUNDCUBE_DB_NAME}\" TO \"${ROUNDCUBE_DB_USER}\"\;" | postgresql_execute "" "postgres" "$POSTGRES_POSTGRES_PASSWORD" + echo "ALTER DATABASE \"${ROUNDCUBE_DB_NAME}\" OWNER TO \"${ROUNDCUBE_DB_USER}\"\;" | postgresql_execute "" "postgres" "$POSTGRES_POSTGRES_PASSWORD" + info "Setting ownership for the 'public' schema database \"${ROUNDCUBE_DB_NAME}\" to \"${ROUNDCUBE_DB_USER}\"" + echo "ALTER SCHEMA public OWNER TO \"${ROUNDCUBE_DB_USER}\"\;" | postgresql_execute "$ROUNDCUBE_DB_NAME" "postgres" "$POSTGRES_POSTGRES_PASSWORD" tolerations: - key: "arch" operator: "Equal"