Repository Public
1#!/bin/zsh2# Idempotent preparation of the hosting node: databases, data directory, key files. Never overwrites anything.3set -euo pipefail4export PATH="/opt/homebrew/bin:/opt/homebrew/opt/postgresql@17/bin:$PATH"5DATA="$HOME/sp-vault-data"; CONF="$HOME/.config/sp-vault"; BK="$HOME/backups/sp-vault"6mkdir -p "$DATA/attachments" "$CONF" "$BK"; chmod 700 "$DATA" "$CONF" "$BK"7for DB in sp_vault sp_vault_managed; do psql -d postgres -tAc "select 1 from pg_database where datname='$DB'" | grep -q 1 || createdb "$DB"; done8umask 0779[ -f "$CONF/backup.key" ] || { openssl rand -base64 48 > "$CONF/backup.key"; echo " created $CONF/backup.key (keep a copy off this node)"; }10[ -f "$CONF/managed.key" ] || { openssl rand -base64 32 > "$CONF/managed.key"; echo " created $CONF/managed.key (managed-secrets master key: keep a copy off this node, apart from database backups)"; }11[ -f "$CONF/managed.token" ] || { openssl rand -base64 32 | tr '+/' '-_' | tr -d '=' > "$CONF/managed.token"; echo " created $CONF/managed.token"; }12chmod 600 "$CONF"/*13echo " node ready (databases sp_vault + sp_vault_managed, data $DATA)"14