After test environment - now a small live environment

[csaeum]

After the test environment - now a small live environment

With the Docker-compose.yaml from the API repository, it's not difficult to set up a test environment. With this foundation, I wanted to set up a small live environment.

So, the

      DEMO: "yes"
      PRODUCTION: "no"
      SAVE_LOGS: "no"

in:

      DEMO: "no"
      PRODUCTION: "yes"
      SAVE_LOGS: "yes"

then I connected my Traefik and added the MySQL credentials.
Here my complete Stack:

# ========================================
# Tracardi v1.1 - Docker Compose
# Strukturiert für Traefik & Multi-Domain API
# ========================================

services:
# ========================================
# Tracardi API (Backend & Tracking Endpunkt)
# ========================================
  tracardi-api:
    image: tracardi/tracardi-api:1.1.3
    container_name: ${COMPOSE_PROJECT_NAME}-api
    depends_on:
      opensearch: { condition: service_started }
      redis: { condition: service_started }
      sql: { condition: service_healthy }
    environment:
      ELASTIC_HOST: http://opensearch:9200
      REDIS_HOST: redis://redis:6379
      MYSQL_HOST: mysql://${SQL_USER}:${SQL_PASSWORD}@sql:3306/${SQL_DATABASE}
      LOGGING_LEVEL: info
      DEMO: "no"
      PRODUCTION: "yes"
      SAVE_LOGS: "yes"
    networks:
      - default
      - ${PROXY_NETWORK}
    restart: ${RESTART}
    labels:
      - traefik.enable=true
      - traefik.http.routers.${COMPOSE_PROJECT_NAME}-api.rule=${TRACARDI_API_HOST_RULE}
      - traefik.http.routers.${COMPOSE_PROJECT_NAME}-api.entrypoints=websecure-https
      - traefik.http.routers.${COMPOSE_PROJECT_NAME}-api.tls.certresolver=letsEncrypt
      - traefik.http.services.${COMPOSE_PROJECT_NAME}-api.loadbalancer.server.port=80

# ========================================
# Tracardi GUI (Benutzeroberfläche)
# ========================================
  tracardi-gui:
    image: tracardi/tracardi-gui:1.1.2
    container_name: ${COMPOSE_PROJECT_NAME}-gui
    depends_on:
      - tracardi-api
    networks:
      - default
      - ${PROXY_NETWORK}
    restart: ${RESTART}
    labels:
      - traefik.enable=true
      - traefik.http.routers.${COMPOSE_PROJECT_NAME}-gui.rule=${TRACARDI_GUI_HOST_RULE}
      - traefik.http.routers.${COMPOSE_PROJECT_NAME}-gui.entrypoints=websecure-https
      - traefik.http.routers.${COMPOSE_PROJECT_NAME}-gui.tls.certresolver=letsEncrypt
      - traefik.http.services.${COMPOSE_PROJECT_NAME}-gui.loadbalancer.server.port=80

# ========================================
# OpenSearch (Datenbank)
# ========================================
  opensearch:
    image: opensearchproject/opensearch:2
    container_name: ${COMPOSE_PROJECT_NAME}-search
    environment:
      - cluster.name=opensearch-cluster
      - node.name=opensearch-node1
      - discovery.type=single-node
      - bootstrap.memory_lock=true
      - "OPENSEARCH_JAVA_OPTS=-Xms512m -Xmx512m"
      - "plugins.security.disabled=true"
      - TZ=${TIMEZONE}
      - compatibility.override_main_response_version=true
      - OPENSEARCH_INITIAL_ADMIN_PASSWORD=${OPENSEARCH_INITIAL_ADMIN_PASSWORD}
    networks:
      default:
        aliases:
          - elastic
          - elasticsearch
          - osearch
          - opensearch
    restart: ${RESTART}
    ulimits:
      memlock:
        soft: -1
        hard: -1
      nofile:
        soft: 65536
        hard: 65536
    volumes:
      - opensearch-data:/usr/share/opensearch/data

# ========================================
# Redis (Caching & Queuing)
# ========================================
  redis:
    image: redis:7-alpine
    container_name: ${COMPOSE_PROJECT_NAME}-redis
    command: ["redis-server", "--requirepass", "${REDIS_PASSWORD}"]
    environment:
      - TZ=${TIMEZONE}
    networks:
      - default
    restart: ${RESTART}
    volumes:
      - redis-data:/data

# ========================================
# MariaDB (Relationale Daten)
# ========================================
  sql:
    image: mariadb:11.4
    container_name: ${COMPOSE_PROJECT_NAME}-sql
    deploy:
      resources:
        limits:
          cpus: "2.0"
          memory: "8G"
    environment:
      - MYSQL_ROOT_PASSWORD=${SQL_ROOT_PASSWORD}
      - MYSQL_DATABASE=${SQL_DATABASE}
      - MYSQL_USER=${SQL_USER}
      - MYSQL_PASSWORD=${SQL_PASSWORD}
      - MARIADB_AUTO_UPGRADE=1
      - MYSQL_CHARSET=utf8mb4
      - TZ=${TIMEZONE}
      # Erlaubt dem Root-Benutzer die Anmeldung von anderen Containern
      - MYSQL_ROOT_HOST=%
    healthcheck:
      interval: 10s
      retries: 20
      start_period: 30s
      test: ["CMD-SHELL", "mariadb-admin ping -uroot -p\"${SQL_ROOT_PASSWORD}\" || exit 1"]
      timeout: 5s
    networks:
      default:
        aliases:
          - mysql
    restart: ${RESTART}
    volumes:
      - sql-data:/var/lib/mysql
      - ./configs/sql/custom.cnf:/etc/mysql/mariadb.conf.d/99-custom.cnf:ro
      - ./configs/sql/mariadb_init:/docker-entrypoint-initdb.d

# ========================================
# Tracardi Worker (Hintergrund-Aufgaben)
# ========================================
  tracardi-worker:
    image: tracardi/update-worker:1.1.2
    container_name: ${COMPOSE_PROJECT_NAME}-worker
    depends_on:
      tracardi-api: { condition: service_started }
    environment:
      ELASTIC_HOST: http://elasticsearch:9200
      REDIS_HOST: redis://redis:6379
      MYSQL_HOST: mysql://${SQL_USER}:${SQL_PASSWORD}@sql:3306/${SQL_DATABASE}
    networks:
      - default
    restart: ${RESTART}

# ========================================
# APM Server (Performance Monitoring)
# ========================================
  tracardi-apm-server:
    image: tracardi/apm:1.1.2
    container_name: ${COMPOSE_PROJECT_NAME}-apm-server
    depends_on:
      - opensearch
      - redis
      - sql
    environment:
      ELASTIC_HOST: http://elasticsearch:9200
      REDIS_HOST: redis://redis:6379
      MYSQL_HOST: mysql://${SQL_USER}:${SQL_PASSWORD}@sql:3306/${SQL_DATABASE}
      MODE: "worker"
      PAUSE: 15
    networks:
      - default
    restart: ${RESTART}

# ========================================
# Datenbank Backup
# ========================================
  sqlbackup:
    image: fradelg/mysql-cron-backup:latest
    container_name: ${COMPOSE_PROJECT_NAME}-sqlbackup
    depends_on:
      sql:
        condition: service_started
    environment:
      TZ: ${TIMEZONE}
      MYSQL_HOST: sql
      MYSQL_USER: root
      MYSQL_PASS: ${SQL_ROOT_PASSWORD}
      MAX_BACKUPS: 12
      INIT_BACKUP: 1
      CRON_TIME: "3 */6 * * *"
      GZIP_LEVEL: 9
    networks:
      - default
    restart: ${RESTART}
    volumes:
      - ${BACKUPVOLUME}/${COMPOSE_PROJECT_NAME}:/backup

# ========================================
# Networks
# ========================================
networks:
  default:
    driver: bridge
  traefik_proxy_network:
    external: true
    name: ${PROXY_NETWORK}

# ========================================
# Volumes
# ========================================
volumes:
  opensearch-data:
    driver: local
    driver_opts:
      device: ${PWD}/volumes/search
      o: bind
      type: none

  redis-data:
    driver: local
    driver_opts:
      device: ${PWD}/volumes/redis
      o: bind
      type: none

  sql-data:
    driver: local
    driver_opts:
      device: ${PWD}/volumes/sql
      o: bind
      type: none

Conclusion:
The GUI is accessible, but when I try to connect the API, it's "dead."
I get this message!

  File "/src/tracardi/service/cache/load_settings.py", line 3, in <module>
    from tracardi.service.storage.mysql.service.configuration_service import ConfigurationService
  File "/src/tracardi/service/storage/mysql/service/configuration_service.py", line 4, in <module>
    from tracardi.service.storage.mysql.service.table_service import TableService
  File "/src/tracardi/service/storage/mysql/service/table_service.py", line 25, in <module>
    engine = client.get_engine_for_database()
  File "/src/tracardi/service/storage/mysql/engine.py", line 37, in get_engine_for_database
    self.engines[mysql.mysql_database] = create_async_engine(
  File "/opt/venv/lib/python3.10/site-packages/sqlalchemy/ext/asyncio/engine.py", line 117, in create_async_engine
    sync_engine = _create_engine(url, **kw)
  File "<string>", line 2, in create_engine
  File "/opt/venv/lib/python3.10/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
  File "/opt/venv/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 548, in create_engine
    u = _url.make_url(url)
  File "/opt/venv/lib/python3.10/site-packages/sqlalchemy/engine/url.py", line 838, in make_url
    return _parse_url(name_or_url)
  File "/opt/venv/lib/python3.10/site-packages/sqlalchemy/engine/url.py", line 901, in _parse_url
    return URL.create(name, **components)  # type: ignore
  File "/opt/venv/lib/python3.10/site-packages/sqlalchemy/engine/url.py", line 205, in create
    cls._assert_port(port),
  File "/opt/venv/lib/python3.10/site-packages/sqlalchemy/engine/url.py", line 215, in _assert_port
    return int(port)
ValueError: invalid literal for int() with base 10: ''
2025-10-08 06:23:46,816 [INFO] EVENT_TO_PROFILE_COPY_CACHE_TTL=83.0627229203129 | tracardi.config | config.py | 48
2025-10-08 06:23:46,816 [INFO] SOURCE_CACHE_TTL=75.04979084272969 | tracardi.config | config.py | 49
2025-10-08 06:23:46,816 [WARNING] Security risk. Env AUTO_PROFILE_MERGING is too short. It must be at least 20 chars long. | tracardi.config | config.py | 313
2025-10-08 06:23:46,817 [INFO] Redis at redis://redis:6379 connected. | tracardi.service.storage.redis.driver.redis_client | redis_client.py | 21
Traceback (most recent call last):
  File "/opt/venv/bin/uvicorn", line 8, in <module>
    sys.exit(main())
  File "/opt/venv/lib/python3.10/site-packages/click/core.py", line 1161, in __call__
    return self.main(*args, **kwargs)
  File "/opt/venv/lib/python3.10/site-packages/click/core.py", line 1082, in main
    rv = self.invoke(ctx)
  File "/opt/venv/lib/python3.10/site-packages/click/core.py", line 1443, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/opt/venv/lib/python3.10/site-packages/click/core.py", line 788, in invoke
    return __callback(*args, **kwargs)
  File "/opt/venv/lib/python3.10/site-packages/uvicorn/main.py", line 412, in main
    run(
  File "/opt/venv/lib/python3.10/site-packages/uvicorn/main.py", line 579, in run
    server.run()
  File "/opt/venv/lib/python3.10/site-packages/uvicorn/server.py", line 65, in run
    return asyncio.run(self.serve(sockets=sockets))
  File "/usr/local/lib/python3.10/asyncio/runners.py", line 44, in run
    return loop.run_until_complete(main)
  File "uvloop/loop.pyx", line 1518, in uvloop.loop.Loop.run_until_complete
  File "/opt/venv/lib/python3.10/site-packages/uvicorn/server.py", line 69, in serve
    await self._serve(sockets)
  File "/opt/venv/lib/python3.10/site-packages/uvicorn/server.py", line 76, in _serve
    config.load()
  File "/opt/venv/lib/python3.10/site-packages/uvicorn/config.py", line 434, in load
    self.loaded_app = import_from_string(self.app)
  File "/opt/venv/lib/python3.10/site-packages/uvicorn/importer.py", line 19, in import_from_string
    module = importlib.import_module(module_str)
  File "/usr/local/lib/python3.10/importlib/__init__.py", line 126, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 1050, in _gcd_import
  File "<frozen importlib._bootstrap>", line 1027, in _find_and_load
  File "<frozen importlib._bootstrap>", line 1006, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 688, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 883, in exec_module
  File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
  File "/src/app/main.py", line 8, in <module>
    from app.middleware.context import ContextRequestMiddleware
  File "/src/app/middleware/context.py", line 10, in <module>
    from tracardi.service.logger_manager import save_logs
  File "/src/tracardi/service/logger_manager.py", line 2, in <module>
    from tracardi.exceptions.log_controller import log_controller
  File "/src/tracardi/exceptions/log_controller.py", line 5, in <module>
    from tracardi.cluster_config import is_save_logs_on
  File "/src/tracardi/cluster_config.py", line 1, in <module>
    from tracardi.service.cluster.settings import GlobalSettings
  File "/src/tracardi/service/cluster/settings.py", line 15, in <module>
    from tracardi.service.cache.load_settings import load_global_settings_by_key
  File "/src/tracardi/service/cache/load_settings.py", line 3, in <module>
    from tracardi.service.storage.mysql.service.configuration_service import ConfigurationService
  File "/src/tracardi/service/storage/mysql/service/configuration_service.py", line 4, in <module>
    from tracardi.service.storage.mysql.service.table_service import TableService
  File "/src/tracardi/service/storage/mysql/service/table_service.py", line 25, in <module>
    engine = client.get_engine_for_database()
  File "/src/tracardi/service/storage/mysql/engine.py", line 37, in get_engine_for_database
    self.engines[mysql.mysql_database] = create_async_engine(
  File "/opt/venv/lib/python3.10/site-packages/sqlalchemy/ext/asyncio/engine.py", line 117, in create_async_engine
    sync_engine = _create_engine(url, **kw)
  File "<string>", line 2, in create_engine
  File "/opt/venv/lib/python3.10/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
  File "/opt/venv/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 548, in create_engine
    u = _url.make_url(url)
  File "/opt/venv/lib/python3.10/site-packages/sqlalchemy/engine/url.py", line 838, in make_url
    return _parse_url(name_or_url)
  File "/opt/venv/lib/python3.10/site-packages/sqlalchemy/engine/url.py", line 901, in _parse_url
    return URL.create(name, **components)  # type: ignore
  File "/opt/venv/lib/python3.10/site-packages/sqlalchemy/engine/url.py", line 205, in create
    cls._assert_port(port),
  File "/opt/venv/lib/python3.10/site-packages/sqlalchemy/engine/url.py", line 215, in _assert_port
    return int(port)
ValueError: invalid literal for int() with base 10: ''

As far as I can see, it's having problems with the MySQL port, right?
Can anyone help me here?

[csaeum]

Okay, that's my current docker-compose.yaml.

I've now reached the install, and it's accepting my user and installation token.

It seems to save the user, and then I'm asked for the installation token again.

I have to say, it's difficult to install with the "poor" documentation.

We'll see, maybe we can solve the problem ;)

# ========================================
# Tracardi v1.1 - Docker Compose
# Strukturiert für Traefik & Multi-Domain API
# ========================================

services:
# ========================================
# Tracardi API (Backend & Tracking Endpunkt)
# ========================================
  tracardi-api:
    image: tracardi/tracardi-api:1.1.3
    container_name: ${COMPOSE_PROJECT_NAME}-api
    depends_on:
      opensearch: { condition: service_started }
      redis: { condition: service_started }
      sql: { condition: service_healthy }
    environment:
      # Sicherheit
      AUTO_PROFILE_MERGING: ${AUTO_PROFILE_MERGING_KEY}
      INSTALLATION_TOKEN: ${INSTALLATION_TOKEN}
      USE_X_FORWARDED_IP: X-Forwarded-For

      # Datenbanken
      ELASTIC_HOST: http://opensearch:9200
      REDIS_HOST: redis://redis:6379
      MYSQL_DATABASE: ${SQL_DATABASE}
      MYSQL_HOST: sql
      MYSQL_PASSWORD: ${SQL_PASSWORD}
      MYSQL_PORT: 3306
      MYSQL_USERNAME: ${SQL_USER}
      # MySQL Performance
      MYSQL_POOL_SIZE: 15
      MYSQL_POOL_MAX_OVERFLOW: 10
      MYSQL_POOL_TIMEOUT: 10
      MYSQL_RECYCLE: 3600

      # Daten-Partitionierung
#      EVENT_PARTITIONING: quarter
#      PROFILE_PARTITIONING: quarter
#      SESSION_PARTITIONING: quarter
#      LOG_PARTITIONING: month

      # Monitoring
      LOGGING_LEVEL: info
#      PERFORMANCE_TRACKING: "yes"
      SERVER_LOGGING_LEVEL: info

      # Grunddaten für Produktion
      DEMO: "no"
      PRODUCTION: "yes"
      SAVE_LOGS: "yes"
    networks:
      - default
      - ${PROXY_NETWORK}
    restart: ${RESTART}
    labels:
      - traefik.enable=true
      - traefik.http.routers.${COMPOSE_PROJECT_NAME}-api.rule=${TRACARDI_API_HOST_RULE}
      - traefik.http.routers.${COMPOSE_PROJECT_NAME}-api.entrypoints=websecure-https
      - traefik.http.routers.${COMPOSE_PROJECT_NAME}-api.tls.certresolver=letsEncrypt
      - traefik.http.services.${COMPOSE_PROJECT_NAME}-api.loadbalancer.server.port=80

# ========================================
# Tracardi GUI (Benutzeroberfläche)
# ========================================
  tracardi-gui:
    image: tracardi/tracardi-gui:1.1.2
    container_name: ${COMPOSE_PROJECT_NAME}-gui
    depends_on:
      - tracardi-api
    networks:
      - default
      - ${PROXY_NETWORK}
    restart: ${RESTART}
    labels:
      - traefik.enable=true
      - traefik.http.routers.${COMPOSE_PROJECT_NAME}-gui.rule=${TRACARDI_GUI_HOST_RULE}
      - traefik.http.routers.${COMPOSE_PROJECT_NAME}-gui.entrypoints=websecure-https
      - traefik.http.routers.${COMPOSE_PROJECT_NAME}-gui.tls.certresolver=letsEncrypt
      - traefik.http.services.${COMPOSE_PROJECT_NAME}-gui.loadbalancer.server.port=80

# ========================================
# OpenSearch (Datenbank)
# ========================================
  opensearch:
    image: opensearchproject/opensearch:2
    container_name: ${COMPOSE_PROJECT_NAME}-search
    environment:
      - cluster.name=opensearch-cluster
      - node.name=opensearch-node1
      - discovery.type=single-node
      - bootstrap.memory_lock=true
      - "OPENSEARCH_JAVA_OPTS=-Xms1g -Xmx1g"
      - "plugins.security.disabled=true"
      - TZ=${TIMEZONE}
      - compatibility.override_main_response_version=true
      - OPENSEARCH_INITIAL_ADMIN_PASSWORD=${OPENSEARCH_INITIAL_ADMIN_PASSWORD}
    networks:
      default:
        aliases:
          - elastic
          - elasticsearch
          - osearch
          - opensearch
    restart: ${RESTART}
    ulimits:
      memlock:
        soft: -1
        hard: -1
      nofile:
        soft: 65536
        hard: 65536
    volumes:
      - opensearch-data:/usr/share/opensearch/data

# ========================================
# Redis (Caching & Queuing)
# ========================================
  redis:
    image: redis:7-alpine
    container_name: ${COMPOSE_PROJECT_NAME}-redis
#   command: ["redis-server", "--requirepass", "${REDIS_PASSWORD}", "--maxmemory", "256mb", "--maxmemory-policy", "allkeys-lru"]
    command: ["redis-server", "--maxmemory", "512mb", "--maxmemory-policy", "allkeys-lru"]
    environment:
      - TZ=${TIMEZONE}
    networks:
      - default
    restart: ${RESTART}
    volumes:
      - redis-data:/data

# ========================================
# MariaDB (Relationale Daten)
# ========================================
  sql:
    image: mariadb:11.4
    container_name: ${COMPOSE_PROJECT_NAME}-sql
    deploy:
      resources:
        limits:
          cpus: "2.0"
          memory: "8G"
    environment:
      - MYSQL_ROOT_PASSWORD=${SQL_ROOT_PASSWORD}
      - MYSQL_DATABASE=${SQL_DATABASE}
      - MYSQL_USER=${SQL_USER}
      - MYSQL_PASSWORD=${SQL_PASSWORD}
      - MARIADB_AUTO_UPGRADE=1
      - MYSQL_CHARSET=utf8mb4
      - TZ=${TIMEZONE}
      # Erlaubt dem Root-Benutzer die Anmeldung von anderen Containern
      - MYSQL_ROOT_HOST=%
    healthcheck:
      interval: 10s
      retries: 20
      start_period: 30s
      test: ["CMD-SHELL", "mariadb-admin ping -uroot -p\"${SQL_ROOT_PASSWORD}\" || exit 1"]
      timeout: 5s
    networks:
      default:
        aliases:
          - mysql
    restart: ${RESTART}
    volumes:
      - sql-data:/var/lib/mysql
      - ./configs/sql/custom.cnf:/etc/mysql/mariadb.conf.d/99-custom.cnf:ro

# ========================================
# Tracardi Worker (Hintergrund-Aufgaben)
# ========================================
  tracardi-worker:
    image: tracardi/update-worker:1.1.2
    container_name: ${COMPOSE_PROJECT_NAME}-worker
    depends_on:
      tracardi-api: { condition: service_started }
    environment:
      AUTO_PROFILE_MERGING: ${AUTO_PROFILE_MERGING_KEY}
      ELASTIC_HOST: http://elasticsearch:9200
      REDIS_HOST: redis://redis:6379
      MYSQL_DATABASE: ${SQL_DATABASE}
      MYSQL_HOST: sql
      MYSQL_PASSWORD: ${SQL_PASSWORD}
      MYSQL_PORT: 3306
      MYSQL_USERNAME: ${SQL_USER}
    networks:
      - default
    restart: ${RESTART}

# ========================================
# APM Server (Performance Monitoring)
# ========================================
  tracardi-apm-server:
    image: tracardi/apm:1.1.2
    container_name: ${COMPOSE_PROJECT_NAME}-apm-server
    depends_on:
      - opensearch
      - redis
      - sql
    environment:
      ELASTIC_HOST: http://elasticsearch:9200
      REDIS_HOST: redis://redis:6379
      MYSQL_DATABASE: ${SQL_DATABASE}
      MYSQL_HOST: sql
      MYSQL_PASSWORD: ${SQL_PASSWORD}
      MYSQL_PORT: 3306
      MYSQL_USERNAME: ${SQL_USER}
      MODE: "worker"
      PAUSE: 15
    networks:
      - default
    restart: ${RESTART}

# ========================================
# Datenbank Backup
# ========================================
  sqlbackup:
    image: fradelg/mysql-cron-backup:latest
    container_name: ${COMPOSE_PROJECT_NAME}-sqlbackup
    depends_on:
      sql:
        condition: service_started
    environment:
      TZ: ${TIMEZONE}
      MYSQL_HOST: sql
      MYSQL_USER: root
      MYSQL_PASS: ${SQL_ROOT_PASSWORD}
      MAX_BACKUPS: 12
      INIT_BACKUP: 1
      CRON_TIME: "3 */6 * * *"
      GZIP_LEVEL: 9
    networks:
      - default
    restart: ${RESTART}
    volumes:
      - ${BACKUPVOLUME}/${COMPOSE_PROJECT_NAME}:/backup

# ========================================
# Networks
# ========================================
networks:
  default:
    driver: bridge
  traefik_proxy_network:
    external: true
    name: ${PROXY_NETWORK}

# ========================================
# Volumes
# ========================================
volumes:
  opensearch-data:
    driver: local
    driver_opts:
      device: ${PWD}/volumes/search
      o: bind
      type: none

  redis-data:
    driver: local
    driver_opts:
      device: ${PWD}/volumes/redis
      o: bind
      type: none

  sql-data:
    driver: local
    driver_opts:
      device: ${PWD}/volumes/sql
      o: bind
      type: none

[csaeum]

Okay, I was able to solve it!!
Finally, it was OpenSearch. Now it works with ElasticSearch!

my .env:

# ========================================
# Tracardi v1.x Stack Konfiguration
# ========================================

# Projekt-Name (wird für Container- und Netzwerk-Namen verwendet)
COMPOSE_PROJECT_NAME=tracardi

# Backup-Verzeichnis
BACKUPVOLUME=/Daten/Backup

# --- Traefik & Domain Konfiguration ---
# Domain für die grafische Benutzeroberfläche (GUI) - Nur für Sie zugänglich
TRACARDI_GUI_HOST_RULE=Host(`tracardi.domai1.de`) || Host(`tracardi.domain2.de`)

# Traefik Routing-Regel für die API-Endpunkte.
# Fügen Sie hier alle Ihre API-Domains mit || getrennt hinzu.
TRACARDI_API_HOST_RULE=Host(`api.domain.de`) || Host(`api.domain.de`)

# Installation Token (für Setup/Installation)
# Erzeugen Sie einen mit: openssl rand -base64 32
INSTALLATION_TOKEN=Token

# Spezieller Schlüssel NUR für die Funktion des automatischen Profil-Mergings
# Erzeugen Sie einen mit: openssl rand -base64 32
AUTO_PROFILE_MERGING_KEY=Token

# MariaDB Konfiguration
SQL_DATABASE=TracardiDB
SQL_USER=TracardiUser
SQL_PASSWORD=Password
SQL_ROOT_PASSWORD=Password

# Netzwerk Konfiguration
PROXY_NETWORK=traefik_proxy_network

# Docker Restart Policy
RESTART=unless-stopped

# Timezone für alle Container
TIMEZONE=Europe/Berlin

my docker-compose.yaml

# ========================================
# Tracardi v1.1 - Docker Compose
# Strukturiert für Traefik & Multi-Domain API
# ========================================

services:
# ========================================
# Tracardi API (Backend & Tracking Endpunkt)
# ========================================
  tracardi-api:
    image: tracardi/tracardi-api:1.1.3
    container_name: ${COMPOSE_PROJECT_NAME}-api
    depends_on:
      elasticsearch: { condition: service_started }
      redis: { condition: service_started }
      sql: { condition: service_healthy }
    environment:
      # Sicherheit
      AUTO_PROFILE_MERGING: ${AUTO_PROFILE_MERGING_KEY}
      INSTALLATION_TOKEN: ${INSTALLATION_TOKEN}
      USE_X_FORWARDED_IP: X-Forwarded-For

      # Datenbanken
      ELASTIC_HOST: http://elasticsearch:9200
      REDIS_HOST: redis://redis:6379
      MYSQL_DATABASE: ${SQL_DATABASE}
      MYSQL_HOST: sql
      MYSQL_PASSWORD: ${SQL_PASSWORD}
      MYSQL_PORT: 3306
      MYSQL_USERNAME: ${SQL_USER}
      # MySQL Performance
#      MYSQL_POOL_SIZE: 20
#      MYSQL_POOL_MAX_OVERFLOW: 15
#      MYSQL_POOL_TIMEOUT: 60
#      MYSQL_RECYCLE: 3600
#      MYSQL_POOL_PRE_PING: "yes"

      # Daten-Partitionierung
      EVENT_PARTITIONING: quarter
      PROFILE_PARTITIONING: quarter
      SESSION_PARTITIONING: quarter
      LOG_PARTITIONING: month

      # Monitoring
      LOGGING_LEVEL: info
#      PERFORMANCE_TRACKING: "yes"
      SERVER_LOGGING_LEVEL: info

      # Grunddaten für Produktion
      DEMO: "no"
      PRODUCTION: "yes"
      SAVE_LOGS: "yes"
    networks:
      - default
      - ${PROXY_NETWORK}
    restart: ${RESTART}
    labels:
      - traefik.enable=true
      - traefik.http.routers.${COMPOSE_PROJECT_NAME}-api.rule=${TRACARDI_API_HOST_RULE}
      - traefik.http.routers.${COMPOSE_PROJECT_NAME}-api.entrypoints=websecure-https
      - traefik.http.routers.${COMPOSE_PROJECT_NAME}-api.tls.certresolver=letsEncrypt
      - traefik.http.services.${COMPOSE_PROJECT_NAME}-api.loadbalancer.server.port=80

# ========================================
# Tracardi GUI (Benutzeroberfläche)
# ========================================
  tracardi-gui:
    image: tracardi/tracardi-gui:1.1.2
    container_name: ${COMPOSE_PROJECT_NAME}-gui
    environment:
      - PUBLIC_URL=/
      - API_URL=//thor.web-seo-consulting.eu
    depends_on:
      - tracardi-api
    networks:
      - default
      - ${PROXY_NETWORK}
    restart: ${RESTART}
    labels:
      - traefik.enable=true
      - traefik.http.routers.${COMPOSE_PROJECT_NAME}-gui.rule=${TRACARDI_GUI_HOST_RULE}
      - traefik.http.routers.${COMPOSE_PROJECT_NAME}-gui.entrypoints=websecure-https
      - traefik.http.routers.${COMPOSE_PROJECT_NAME}-gui.tls.certresolver=letsEncrypt
      - traefik.http.services.${COMPOSE_PROJECT_NAME}-gui.loadbalancer.server.port=80

# ========================================
# OpenSearch (Datenbank)
# ========================================
  elasticsearch:
    image: docker.elastic.co/elasticsearch/elasticsearch:8.11.1
    container_name: ${COMPOSE_PROJECT_NAME}-search
    environment:
      - discovery.type=single-node
      - xpack.security.enabled=false
      - "ES_JAVA_OPTS=-Xms1g -Xmx1g"
      - TZ=${TIMEZONE}
    networks:
      default:
        aliases:
          - elastic
          - elasticsearch
          - osearch
          - opensearch
    restart: ${RESTART}
    ulimits:
      memlock:
        soft: -1
        hard: -1
      nofile:
        soft: 65536
        hard: 65536
    volumes:
      - search-data:/usr/share/opensearch/data

# ========================================
# Redis (Caching & Queuing)
# ========================================
  redis:
    image: redis:7-alpine
    container_name: ${COMPOSE_PROJECT_NAME}-redis
#   command: ["redis-server", "--requirepass", "${REDIS_PASSWORD}", "--maxmemory", "256mb", "--maxmemory-policy", "allkeys-lru"]
    command: ["redis-server", "--maxmemory", "512mb", "--maxmemory-policy", "allkeys-lru"]
    environment:
      - TZ=${TIMEZONE}
    networks:
      - default
    restart: ${RESTART}
    volumes:
      - redis-data:/data

# ========================================
# MariaDB (Relationale Daten)
# ========================================
  sql:
    image: mariadb:11.4
    container_name: ${COMPOSE_PROJECT_NAME}-sql
    deploy:
      resources:
        limits:
          cpus: "2.0"
          memory: "8G"
    environment:
      - MYSQL_ROOT_PASSWORD=${SQL_ROOT_PASSWORD}
      - MYSQL_DATABASE=${SQL_DATABASE}
      - MYSQL_USER=${SQL_USER}
      - MYSQL_PASSWORD=${SQL_PASSWORD}
      - MARIADB_AUTO_UPGRADE=1
      - MYSQL_CHARSET=utf8mb4
      - TZ=${TIMEZONE}
      # Erlaubt dem Root-Benutzer die Anmeldung von anderen Containern
      - MYSQL_ROOT_HOST=%
    healthcheck:
      interval: 10s
      retries: 20
      start_period: 30s
      test: ["CMD-SHELL", "mariadb-admin ping -uroot -p\"${SQL_ROOT_PASSWORD}\" || exit 1"]
      timeout: 5s
    networks:
      default:
        aliases:
          - mysql
    restart: ${RESTART}
    volumes:
      - sql-data:/var/lib/mysql
 #     - ./configs/sql/custom.cnf:/etc/mysql/mariadb.conf.d/99-custom.cnf:ro

# ========================================
# Tracardi Worker (Hintergrund-Aufgaben)
# ========================================
  tracardi-worker:
    image: tracardi/update-worker:1.1.2
    container_name: ${COMPOSE_PROJECT_NAME}-worker
    depends_on:
      tracardi-api: { condition: service_started }
    environment:
      AUTO_PROFILE_MERGING: ${AUTO_PROFILE_MERGING_KEY}
      ELASTIC_HOST: http://elasticsearch:9200
      REDIS_HOST: redis://redis:6379
      MYSQL_DATABASE: ${SQL_DATABASE}
      MYSQL_HOST: sql
      MYSQL_PASSWORD: ${SQL_PASSWORD}
      MYSQL_PORT: 3306
      MYSQL_USERNAME: ${SQL_USER}
    networks:
      - default
    restart: ${RESTART}

# ========================================
# APM Server (Performance Monitoring)
# ========================================
  tracardi-apm-server:
    image: tracardi/apm:1.1.2
    container_name: ${COMPOSE_PROJECT_NAME}-apm-server
    depends_on:
      - elasticsearch
      - redis
      - sql
    environment:
      ELASTIC_HOST: http://elasticsearch:9200
      REDIS_HOST: redis://redis:6379
      MYSQL_DATABASE: ${SQL_DATABASE}
      MYSQL_HOST: sql
      MYSQL_PASSWORD: ${SQL_PASSWORD}
      MYSQL_PORT: 3306
      MYSQL_USERNAME: ${SQL_USER}
      MODE: "worker"
      PAUSE: 15
    networks:
      - default
    restart: ${RESTART}

# ========================================
# Datenbank Backup
# ========================================
  sqlbackup:
    image: fradelg/mysql-cron-backup:latest
    container_name: ${COMPOSE_PROJECT_NAME}-sqlbackup
    depends_on:
      sql:
        condition: service_started
    environment:
      TZ: ${TIMEZONE}
      MYSQL_HOST: sql
      MYSQL_USER: root
      MYSQL_PASS: ${SQL_ROOT_PASSWORD}
      MAX_BACKUPS: 12
      INIT_BACKUP: 1
      CRON_TIME: "3 */6 * * *"
      GZIP_LEVEL: 9
    networks:
      - default
    restart: ${RESTART}
    volumes:
      - ${BACKUPVOLUME}/${COMPOSE_PROJECT_NAME}:/backup

# ========================================
# Networks
# ========================================
networks:
  default:
    driver: bridge
  traefik_proxy_network:
    external: true
    name: ${PROXY_NETWORK}

# ========================================
# Volumes
# ========================================
volumes:
  search-data:
    driver: local
    driver_opts:
      device: ${PWD}/volumes/search
      o: bind
      type: none

  redis-data:
    driver: local
    driver_opts:
      device: ${PWD}/volumes/redis
      o: bind
      type: none

  sql-data:
    driver: local
    driver_opts:
      device: ${PWD}/volumes/sql
      o: bind
      type: none

my my.cnf

# ========================================
# Tracardi-optimierte MariaDB Configuration
# configs/sql/custom.cnf
# ========================================

[mysqld]
# ========================================
# Basic Settings
# ========================================
bind-address = 0.0.0.0
default_time_zone = '+00:00'

# WICHTIG: Packet Size erhöhen
max_allowed_packet = 512M              # Erhöht von 256M

# Connection Timeouts (WICHTIG gegen Aborted Connections!)
wait_timeout = 28800                   # 8 Stunden
interactive_timeout = 28800            # 8 Stunden
connect_timeout = 60                   # 60 Sekunden für Connect
net_read_timeout = 300                 # 5 Minuten für Reads
net_write_timeout = 300                # 5 Minuten für Writes

# ========================================
# Character Set
# ========================================
character_set_server = utf8mb4
collation_server = utf8mb4_unicode_ci

# ========================================
# Performance (Tracardi optimiert)
# ========================================
innodb_buffer_pool_size = 2G
innodb_flush_log_at_trx_commit = 2
innodb_log_file_size = 512M
innodb_log_buffer_size = 16M
innodb_io_capacity = 400
innodb_io_capacity_max = 800
max_connections = 200

# ========================================
# Thread Pool (gegen Connection-Probleme)
# ========================================
thread_handling = pool-of-threads
thread_pool_size = 8
thread_pool_max_threads = 500

# Table Cache
table_open_cache = 4000
table_definition_cache = 2000

# Temporary Tables
tmp_table_size = 128M                  # Erhöht von 64M
max_heap_table_size = 128M             # Erhöht von 64M

# ========================================
# Docker & Security
# ========================================
skip_name_resolve
innodb_file_per_table = 1
innodb_flush_method = O_DIRECT

# SQL Mode
sql_mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

# ========================================
# Logging (optional - nur bei Problemen aktivieren)
# ========================================
# log_warnings = 2                     # Mehr Details in Logs
# slow_query_log = 1
# slow_query_log_file = /var/lib/mysql/slow.log
# long_query_time = 2

If anyone has any suggestions to improve it, I'm open to anything!