docker-compose.yaml

# Copyright (C) 2023 - present Juergen Zimmermann, Hochschule Karlsruhe
#
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program.  If not, see <https://www.gnu.org/licenses/>.

# Aufruf:   docker compose up postgres pgadmin fakesmtp kunde
#           docker compose down

# Netzwerk "kunde_default" für die Container durch den Verzeichnisnamen
---
# https://docs.docker.com/compose/compose-file
# https://docs.docker.com/compose/compose-file/compose-file-v3
services:

  # ------------------------------------------------------------------------------------
  # P o s t g r e S Q L
  # ------------------------------------------------------------------------------------
  postgres:
    image: postgres:15.3-bullseye
    ports:
      - published: 5432
        target: 5432
    volumes:
      - type: bind
        source: C:/Zimmermann/volumes/postgres/data
        target: /var/lib/postgresql/data
      - type: bind
        source: C:/Zimmermann/volumes/postgres/postgresql.conf
        target: /etc/postgresql/postgresql.conf
        read_only: true
      - type: bind
        source: C:/Zimmermann/volumes/postgres/tablespace
        target: /var/lib/postgresql/tablespace
      - type: bind
        source: C:/Zimmermann/volumes/postgres/sql
        target: /sql
        read_only: true
    environment:
      POSTGRES_PASSWORD: p
      TZ: Europe/Berlin
      PGTZ: Europe/Berlin
      #PGDATA: /var/lib/postgresql/data
      # https://www.postgresql.org/docs/current/auth-trust.html
      #POSTGRES_HOST_AUTH_METHOD: trust
    user: "postgres:postgres"
    security_opt:
      - label:user:postgres
      - no-new-privileges:true
    container_name: postgres
    hostname: postgres
    deploy:
      resources:
        limits:
          cpus: "2.0"
          memory: 2048M
    healthcheck:
      test:
        [
          CMD,
          pg_isready,
          --dbname,
          postgres,
          --username,
          postgres
        ]
      interval: 5s
      timeout: 2s
      start_period: 5s

  # ------------------------------------------------------------------------------------
  # p g a d m i n
  # ------------------------------------------------------------------------------------
  # http://localhost:8888 mit Emailadresse "pgadmin@acme.com" und Passwort "p"
  pgadmin:
    image: dpage/pgadmin4:7.1
    ports:
      - published: 8888
        target: 80
    volumes:
      - type: bind
        source: C:/Zimmermann/volumes/postgres/pgadmin
        # https://www.pgadmin.org/docs/pgadmin4/latest/container_deployment.html
        target: /var/lib/pgadmin
      - type: bind
        source: C:/Zimmermann/volumes/postgres/pgadmin4
        target: /var/lib/pgadmin4
    environment:
      PGADMIN_DEFAULT_EMAIL: pgadmin@acme.com
      PGADMIN_DEFAULT_PASSWORD: p
    user: "pgadmin:5050"
    container_name: pgadmin
    hostname: pgadmin
    deploy:
      resources:
        limits:
          cpus: "2.0"
          memory: 2048M

  # ------------------------------------------------------------------------------------
  # M y S Q L
  # ------------------------------------------------------------------------------------
  mysql:
    image: mysql:8.0.33-oracle
    ports:
      - published: 3306
        target: 3306
    volumes:
      - type: bind
        source: C:/Zimmermann/volumes/mysql/db
        target: /var/lib/mysql
      - type: bind
        source: C:/Zimmermann/volumes/mysql/mysqld
        target: /var/run/mysqld
      - type: bind
        source: C:/Zimmermann/volumes/mysql/run-mysqld
        target: /run/mysqld
      - type: bind
        source: C:/Zimmermann/volumes/mysql/log
        target: /var/log
      - type: bind
        source: C:/Zimmermann/volumes/mysql/tmp
        target: /tmp
      - type: bind
        source: C:/Zimmermann/volumes/mysql/sql
        target: /sql
        read_only: true
    environment:
      PMA_HOST: mysql
      MYSQL_ROOT_PASSWORD: p
      TZ: Europe/Berlin
    security_opt:
      - label:user:mysql
      - no-new-privileges:true
    container_name: mysql
    hostname: mysql
    deploy:
      resources:
        limits:
          cpus: "2.0"
          memory: 2048M
    healthcheck:
      test:
        [
          CMD,
          mysqladmin,
          --user=root,
          --password=p,
          --host=mysql,
          ping
        ]
      interval: 5s
      timeout: 2s
      start_period: 5s

  # ------------------------------------------------------------------------------------
  # p h p M y A d m i n
  # ------------------------------------------------------------------------------------
  phpmyadmin:
    image: phpmyadmin/phpmyadmin:5.2.1
    links: [ mysql ]
    ports:
      - published: 8889
        target: 80
    environment:
      MYSQL_ROOT_PASSWORD: p
      PMA_HOST: mysql
      PMA_PORT: 3306
      PMA_ARBITRARY: 1
    # kein dedizierter User im Image vorhanden
    container_name: phpmyadmin
    # https://github.com/phpmyadmin/docker/issues/293
    hostname: phpmyadmin.mysql.docker
    deploy:
      resources:
        limits:
          cpus: "0.5"
          memory: 768M

  # ------------------------------------------------------------------------------------
  # D B e a v e r
  # ------------------------------------------------------------------------------------
  # als User "cbadmin" muss man eine DB-Verbindung und einen User einrichten
  dbeaver:
    image: dbeaver/cloudbeaver:23.0.4
    links: [ mysql ]
    ports:
      - published: 8978
        target: 8978
    volumes:
      - type: bind
        source: C:/Zimmermann/volumes/dbeaver
        target: /opt/cloudbeaver/workspace
    environment:
      TZ: Europe/Berlin
    container_name: dbeaver
    hostname: dbeaver
    deploy:
      resources:
        limits:
          cpus: "0.5"
          memory: 768M

  # ------------------------------------------------------------------------------------
  # O r a c l e
  # ------------------------------------------------------------------------------------
  oracle:
    # 2 statt 12 GB; u.a. genutzt fuer die Entwicklung von Hibernate und Spring Data JPA
    image: gvenzl/oracle-xe:21.3.0-slim
    #image: container-registry.oracle.com/database/express
    ports:
      - published: 1521
        target: 1521
      # https://github.com/gvenzl/oci-oracle-xe/issues/174
      - published: 5500
        target: 5500
    volumes:
      - type: bind
        source: C:/Zimmermann/volumes/oracle/oradata
        target: /opt/oracle/oradata
      - type: bind
        source: C:/Zimmermann/volumes/oracle/sql
        target: /sql
    environment:
      TZ: Europe/Berlin
      # Passwort fuer SYS, SYSTEM und PDBADMIN: nur beim 1. Aufruf setzen
      ORACLE_PASSWORD: p
      #ORACLE_DATABASE=XEPDB1
      # SGA (System Global Area) fuer Cache
      INIT_SGA_SIZE: 64M
      # PRA (Program Global Area) fuer Stored Procedures
      INIT_PGA_SIZE: 10M
    # user: oracle:oinstall
    container_name: XE
    hostname: XE
    deploy:
      resources:
        limits:
          cpus: "2.0"
          # https://www.esolution.ca/oracle-database-xe-system-requirements
          # TODO https://github.com/gvenzl/oci-oracle-xe/issues/168
          memory: 2048M
    healthcheck:
      # /opt/oracle/healthcheck.sh
      # https://stackoverflow.com/questions/50217637/how-do-i-check-if-oracle-is-up-in-docker
      #test: [ CMD, bash, -c, healthcheck.sh ]
      test:
        [
          CMD,
          bash,
          -c,
          "echo 'SELECT 1 FROM dual;' | sqlplus sys/p@XE as sysdba"
        ]
      interval: 120s
      timeout: 5s
      start_period: 30s

  # ------------------------------------------------------------------------------------
  # f a k e s m t p
  # ------------------------------------------------------------------------------------
  fakesmtp:
    image: gessnerfl/fake-smtp-server:2.0.2
    ports:
      - published: 5025
        target: 5025
      - published: 5080
        target: 5080
      - published: 5081
        target: 5081
    volumes:
      - type: bind
        source: C:/Zimmermann/volumes/fakesmtp
        target: /tmp
    environment:
      TZ: Europe/Berlin
      SPRING_OUTPUT_ANSI_ENABLED: ALWAYS
      SPRING_MAIN_BANNER-MODE: LOG
      SPRING_LAZY-INITIALIZATION: "true"
      SPRING_JPA_OPEN-IN-VIEW: "true"
    container_name: fakesmtp
    hostname: fakesmtp
    cap_drop: [ ALL ]
    #healthcheck:
    #  test: [ CMD, curl, --insecure, --fail, https://localhost:8080/actuator/health/readiness ]
    #  interval: 2m
    #  timeout: 10s
    #  retries: 2
    #  start_period: 1m
    stop_grace_period: 10s
    deploy:
      resources:
        limits:
          cpus: "0.5"
          memory: 768M

  # ------------------------------------------------------------------------------------
  # k u n d e
  # ------------------------------------------------------------------------------------
  kunde:
    image: juergenzimmermann/kunde:2023.1.1
    #image: juergenzimmermann/kunde:2023.1.1-jammy
    #image: juergenzimmermann/kunde:2023.1.1-ubi9
    depends_on:
      postgres:
        condition: service_healthy
      #mysql:
      #  condition: service_healthy
      #oracle:
      #  condition: service_healthy
    ports:
      - published: 8080
        target: 8080
    volumes:
      - type: bind
        source: C:\Zimmermann\volumes\kunde-v2
        target: /tmp
    env_file: [ docker-compose.env ]
    container_name: kunde
    hostname: kunde
    deploy:
      resources:
        limits:
          cpus: "1.0"
          memory: 1024M