f89e074dd1
Governed substrate for autonomous agents: scoped identity (passports), audited actions, MCP workspace. Infra IPs and secrets redacted for public release.
61 lines
2.5 KiB
Bash
Executable file
61 lines
2.5 KiB
Bash
Executable file
#!/usr/bin/env bash
|
|
# GOD CRM self-host entrypoint: wait for Postgres, load schema on first run, start.
|
|
set -euo pipefail
|
|
|
|
PGHOST="${POSTGRES_HOST:-db}"
|
|
PGPORT="${POSTGRES_PORT:-5432}"
|
|
PGUSER="${POSTGRES_USER:-godcrm}"
|
|
PGDB="${POSTGRES_DB:-godcrm}"
|
|
export PGPASSWORD="${POSTGRES_PASSWORD:-}"
|
|
SCHEMA_FILE="/app/deploy/selfhost/schema.sql"
|
|
|
|
echo "[entrypoint] waiting for postgres at ${PGHOST}:${PGPORT} ..."
|
|
for i in $(seq 1 60); do
|
|
if pg_isready -h "$PGHOST" -p "$PGPORT" -U "$PGUSER" -d "$PGDB" >/dev/null 2>&1; then
|
|
echo "[entrypoint] postgres is ready"
|
|
break
|
|
fi
|
|
if [ "$i" -eq 60 ]; then
|
|
echo "[entrypoint] ERROR: postgres not reachable after 60s" >&2
|
|
exit 1
|
|
fi
|
|
sleep 1
|
|
done
|
|
|
|
# First run → load the verified schema snapshot. The CRM's prod schema is not
|
|
# reproducible from the knex migration chain, so self-host ships the real schema
|
|
# (structure only, no data). Detect "already initialised" via the users table.
|
|
INITIALISED="$(psql -h "$PGHOST" -p "$PGPORT" -U "$PGUSER" -d "$PGDB" -tAc \
|
|
"SELECT to_regclass('public.users') IS NOT NULL;" 2>/dev/null || echo f)"
|
|
|
|
if [ "$INITIALISED" = "t" ]; then
|
|
echo "[entrypoint] schema already present — skipping load"
|
|
else
|
|
echo "[entrypoint] empty database — loading schema snapshot ..."
|
|
psql -h "$PGHOST" -p "$PGPORT" -U "$PGUSER" -d "$PGDB" \
|
|
-v ON_ERROR_STOP=1 -q -f "$SCHEMA_FILE"
|
|
echo "[entrypoint] schema loaded"
|
|
|
|
# ADR-165-F Track A — seed the SC-SIM demo on first run so a fresh clean-room boot
|
|
# opens on a WORKING, pre-run simulator (public space /s/sc-sim + project + the 8
|
|
# pack tables + scheme/config + a COMPLETED run @ ~96% sorter utilization) instead
|
|
# of an empty CRM. First-run only (this schema-load branch); the seeder is idempotent
|
|
# and combat-guarded (hard-refuses godcrm_prod), and reads POSTGRES_* from the app env.
|
|
# Non-fatal by design: a seed hiccup — or a public image that ships without the
|
|
# SC-SIM module — must NOT brick the platform boot; the CRM still starts, we log it.
|
|
SEED_SCRIPT="/app/backend/scripts/seed-sc-sim-demo.js"
|
|
if [ -f "$SEED_SCRIPT" ]; then
|
|
echo "[entrypoint] seeding SC-SIM demo ..."
|
|
if node "$SEED_SCRIPT"; then
|
|
echo "[entrypoint] SC-SIM demo seeded"
|
|
else
|
|
rc=$?
|
|
echo "[entrypoint] WARNING: SC-SIM demo seed failed (exit ${rc}) — starting without demo content" >&2
|
|
fi
|
|
else
|
|
echo "[entrypoint] SC-SIM seeder not present in image — skipping demo seed"
|
|
fi
|
|
fi
|
|
|
|
echo "[entrypoint] starting: $*"
|
|
exec "$@"
|