Skip to content

Docker install with postgres not working #1883

@cwilhelm

Description

@cwilhelm

Describe the bug
Install admidio with docker-compose.yml below, then requests throw exceptions like table adm_session not available. A quick fix is to delete the newly created config.php. After that the installation can be started.

To Reproduce
Steps to reproduce the behavior:

  1. create docker-compose.yml and run docker compose up
  2. Go to 'http://localhost:8080'
  3. See error

docker-compose.yml:

services:
  admidio-postgres-db:
    restart: unless-stopped
    image: postgres:18
    container_name: admidio-psql
    volumes:
      - "./db:/var/lib/postgresql"
    env_file:
      - .env
    environment:
      - POSTGRES_PASSWORD: password
      - POSTGRES_USER: admidio
      - POSTGRES_DB:admidio
    security_opt:
      - "seccomp:unconfined"

  admidio:
    restart: unless-stopped
    image: admidio/admidio:latest
    container_name: admidio-app
    depends_on:
      - admidio-postgres-db
    volumes:
      - ./admidio/files:/opt/app-root/src/adm_my_files
      - ./admidio/plugins:/opt/app-root/src/adm_plugins
      - ./admidio/themes:/opt/app-root/src/themes
    ports:
      - 8080:8080
    environment:
      - ADMIDIO_DB_TYPE=pgsql
      - ADMIDIO_DB_HOST=admidio-postgres-db:5432
      - ADMIDIO_DB_NAME=admidio
      - ADMIDIO_DB_USER=admidio
      - ADMIDIO_DB_PASSWORD=password
      - ADMIDIO_DB_TABLE_PRAEFIX=adm
      - ADMIDIO_MAIL_RELAYHOST=192.168.10.10:25
      - ADMIDIO_LOGIN_FOR_UPDATE=1
      - ADMIDIO_ORGANISATION=TVZ
      - ADMIDIO_PASSWORD_HASH_ALGORITHM=DEFAULT
      - TZ=Europe/Zurich
      - ADMIDIO_ROOT_PATH=http://localhost:3100
    security_opt:
      - "seccomp:unconfined"

Expected behavior
Either the app should run with the created config.php or the installation should start properly.

System (please complete the following information):

  • Admidio-Version v5 [admidio/admidio:latest]
  • Database [PostgreSQL]

Metadata

Metadata

Assignees

Labels

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions