Issues running Agola with Postgres

devinchristianson · November 21, 2022, 8:05pm

I’ve been unable to figure out a working docker-compose stack with agola using postgres as a database, despite success with local databases such as etcd. (see reproducible example below)

if runservice or configstore are run individually, they run indefinitely with no output until they are stopped.

This appears to be similar behavior to what this poster is describing: Configstore and runservice not starting or logging any errors

see gist:

gist.github.com

https://gist.github.com/devinchristianson/3aebaf837a0902d74100c5be31075d6d

config.yml

gateway:
  apiExposedURL: "https://cicd.testurl.dev"
  webExposedURL: "https://cicd.testurl.dev"
  runserviceURL: "http://localhost:4000"
  configstoreURL: "http://localhost:4002"
  gitserverURL: "http://localhost:4003"
  web:
    listenAddress: ":8000"
  tokenSigning:
    method: hmac

This file has been truncated. show original

docker-compose.yml

version: '3.8'

services:
    minio:
        image: "minio/minio"
        restart: unless-stopped
        expose:
            - 9000
        environment:
            MINIO_ACCESS_KEY: testaccesskey

This file has been truncated. show original

setup-dbs.sh

#!/bin/bash
set -e

psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL
	CREATE DATABASE runservice;
	GRANT ALL PRIVILEGES ON DATABASE runservice TO postgres;
    CREATE DATABASE notification;
	GRANT ALL PRIVILEGES ON DATABASE notification TO postgres;
    CREATE DATABASE configstore;
	GRANT ALL PRIVILEGES ON DATABASE configstore TO postgres;

This file has been truncated. show original