PostgreSQL server is not available

[peathagore]

Hello,

I tried to upgrade zabbix 5.2 to zabbix 5.4 but I failed and I started from scratch with a normal install 5.4 (The 5.2 was still in progress so no problem)

I am using docker compose and whenI start the entire stack no problem.
And yet the "zabbix-docker_db_data_pgsql_1" is shutting down right after the start witout any error.
The "zabbix-docker_zabbix-server_1" and "zabbix-docker_zabbix-web-nginx-pgsql_1" logs show a "PostgreSQL server is not available. Waiting 5 seconds..."
And "zabbix-docker_postgres-server_1" is waiting for a connection.

I changed all the volumes in "/opt/docker/zabbix/zbx_env/" and I'm using traefik to route my packages. (That's maybe the one I'm using wrong.... :/)

I don't know what I'm doing wrong, I don't know where to look for anymore. Could you giveme a lead ?

Here's the .yaml file. Thanks.

version: '3.5'
services:
zabbix-server:
image: zabbix/zabbix-server-pgsql:ubuntu-5.4-latest
ports:
- "10051:10051"
volumes:
- /etc/localtime:/etc/localtime:ro
- /opt/docker/zabbix/zbx_env/usr/lib/zabbix/alertscripts:/usr/lib/zabbix/alertscripts:ro
- /opt/docker/zabbix/zbx_env/usr/lib/zabbix/externalscripts:/usr/lib/zabbix/externalscripts:ro
- /opt/docker/zabbix/zbx_env/var/lib/zabbix/export:/var/lib/zabbix/export:rw
- /opt/docker/zabbix/zbx_env/var/lib/zabbix/modules:/var/lib/zabbix/modules:ro
- /opt/docker/zabbix/zbx_env/var/lib/zabbix/enc:/var/lib/zabbix/enc:ro
- /opt/docker/zabbix/zbx_env/var/lib/zabbix/ssh_keys:/var/lib/zabbix/ssh_keys:ro
- /opt/docker/zabbix/zbx_env/var/lib/zabbix/mibs:/var/lib/zabbix/mibs:ro
- /opt/docker/zabbix/zbx_env/var/lib/zabbix/snmptraps:/var/lib/zabbix/snmptraps:ro
# - ./.ZBX_DB_CA_FILE:/run/secrets/root-ca.pem:ro
# - ./.ZBX_DB_CERT_FILE:/run/secrets/client-cert.pem:ro
# - ./.ZBX_DB_KEY_FILE:/run/secrets/client-key.pem:ro
ulimits:
nproc: 65535
nofile:
soft: 20000
hard: 40000
deploy:
resources:
limits:
cpus: '0.70'
memory: 1G
reservations:
cpus: '0.5'
memory: 512M
env_file:
- .env_db_pgsql
- .env_srv
secrets:
- POSTGRES_USER
- POSTGRES_PASSWORD
depends_on:
- postgres-server
networks:
zbx_net_backend:
aliases:
- zabbix-server
- zabbix-server-pgsql
- zabbix-server-ubuntu-pgsql
- zabbix-server-pgsql-ubuntu
default:
# devices:
# - "/dev/ttyUSB0:/dev/ttyUSB0"
stop_grace_period: 30s
sysctls:
- net.ipv4.ip_local_port_range=1024 65000
- net.ipv4.conf.all.accept_redirects=0
- net.ipv4.conf.all.secure_redirects=0
- net.ipv4.conf.all.send_redirects=0
labels:
com.zabbix.description: "Zabbix server with PostgreSQL database support"
com.zabbix.company: "Zabbix LLC"
com.zabbix.component: "zabbix-server"
com.zabbix.dbtype: "pgsql"
com.zabbix.os: "ubuntu"


zabbix-web-nginx-pgsql:
image: zabbix/zabbix-web-nginx-pgsql:ubuntu-5.4-latest
ports:
- "8081:8081"
#- "443:8443"
volumes:
- /etc/localtime:/etc/localtime:ro
- /opt/docker/zabbix/zbx_env/etc/ssl/nginx:/etc/ssl/nginx:ro
- /opt/docker/zabbix/zbx_env/usr/share/zabbix/modules/:/usr/share/zabbix/modules/:ro
# - ./.ZBX_DB_CA_FILE:/run/secrets/root-ca.pem:ro
# - ./.ZBX_DB_CERT_FILE:/run/secrets/client-cert.pem:ro
# - ./.ZBX_DB_KEY_FILE:/run/secrets/client-key.pem:ro
deploy:
resources:
limits:
cpus: '0.70'
memory: 512M
reservations:
cpus: '0.5'
memory: 256M
env_file:
- .env_db_pgsql
- .env_web
secrets:
- POSTGRES_USER
- POSTGRES_PASSWORD
depends_on:
- postgres-server
- zabbix-server
healthcheck:
test: ["CMD", "curl", "-f", "http://localhost:8080/"]
interval: 10s
timeout: 5s
retries: 3
start_period: 30s
networks:
zbx_net_backend:
aliases:
- zabbix-web-nginx-pgsql
- zabbix-web-nginx-ubuntu-pgsql
- zabbix-web-nginx-pgsql-ubuntu
default:
stop_grace_period: 10s
sysctls:
- net.core.somaxconn=65535
labels:
- traefik.http.routers.zabbix.rule=Host(`zabbix.aura .local`)
- traefik.http.middlewares.icinga2.compress=true
# - traefik.http.services.glpi.loadbalancer.server.por t=8081
# com.zabbix.description: "Zabbix frontend on Nginx web-server with PostgreSQL database support"
# com.zabbix.company: "Zabbix LLC"
# com.zabbix.component: "zabbix-frontend"
# com.zabbix.webserver: "nginx"
# com.zabbix.dbtype: "pgsql"
# com.zabbix.os: "ubuntu"

zabbix-agent:
image: zabbix/zabbix-agent:ubuntu-5.4-latest
# profiles:
# - full
# - all
ports:
- "10050:10050"
volumes:
- /etc/localtime:/etc/localtime:ro
- /opt/docker/zabbix/zbx_env/etc/zabbix/zabbix_agentd.d:/etc/zabbix/zabbix_agentd.d:ro
- /opt/docker/zabbix/zbx_env/var/lib/zabbix/modules:/var/lib/zabbix/modules:ro
- /opt/docker/zabbix/zbx_env/var/lib/zabbix/enc:/var/lib/zabbix/enc:ro
- /opt/docker/zabbix/zbx_env/var/lib/zabbix/ssh_keys:/var/lib/zabbix/ssh_keys:ro
deploy:
resources:
limits:
cpus: '0.2'
memory: 128M
reservations:
cpus: '0.1'
memory: 64M
mode: global
env_file:
- .env_agent
privileged: true
pid: "host"
networks:
zbx_net_backend:
aliases:
- zabbix-agent
- zabbix-agent-passive
- zabbix-agent-ubuntu
stop_grace_period: 5s
labels:
com.zabbix.description: "Zabbix agent"
com.zabbix.company: "Zabbix LLC"
com.zabbix.component: "zabbix-agentd"
com.zabbix.os: "ubuntu"

zabbix-web-service:
image: zabbix/zabbix-web-service:ubuntu-5.4-latest
#profiles:
# - full
# - all
ports:
- "10053:10053"
volumes:
- /opt/docker/zabbix/zbx_env/var/lib/zabbix/enc:/var/lib/zabbix/enc:ro
cap_add:
- SYS_ADMIN
deploy:
resources:
limits:
cpus: '0.5'
memory: 512M
reservations:
cpus: '0.25'
memory: 256M
env_file:
- .env_web_service
networks:
zbx_net_backend:
aliases:
- zabbix-web-service
- zabbix-web-service-ubuntu
stop_grace_period: 5s
labels:
com.zabbix.description: "Zabbix web service"
com.zabbix.company: "Zabbix LLC"
com.zabbix.component: "web-service"
com.zabbix.os: "ubuntu"

postgres-server:
image: postgres:13-alpine
# command: -c ssl=on -c ssl_cert_file=/run/secrets/server-cert.pem -c ssl_key_file=/run/secrets/server-key.pem -c ssl_ca_file=/run/secrets/root-ca.pem
volumes:
- /opt/docker/zabbix/zbx_env/var/lib/postgresql/data:/var/lib/postgresql/data:rw

- ./.ZBX_DB_CA_FILE:/run/secrets/root-ca.pem:ro
- ./.ZBX_DB_CERT_FILE:/run/secrets/server-cert.pem:ro
- ./.ZBX_DB_KEY_FILE:/run/secrets/server-key.pem:ro
env_file:
- .env_db_pgsql
secrets:
- POSTGRES_USER
- POSTGRES_PASSWORD
stop_grace_period: 1m
networks:
zbx_net_backend:
aliases:
- postgres-server
- pgsql-server
- pgsql-database

db_data_pgsql:
image: busybox
volumes:
- /opt/docker/zabbix/zbx_env/var/lib/postgresql/data:/var/lib/postgresql/data:rw

# elasticsearch:
# image: elasticsearch
# profiles:
# - full
# - all
# environment:
# - transport.host=0.0.0.0
# - discovery.zen.minimum_master_nodes=1
# networks:
# zbx_net_backend:
# aliases:
# - elasticsearch

networks:
# zbx_net_frontend:
# driver: bridge
# driver_opts:
# com.docker.network.enable_ipv6: "false"
# ipam:
# driver: default
# config:
# - subnet: 172.16.238.0/24
zbx_net_backend:
driver: bridge
driver_opts:
com.docker.network.enable_ipv6: "false"
internal: true
ipam:
driver: default
config:
- subnet: 172.16.239.0/24
default:
driver: bridge
driver_opts:
com.docker.network.enable_ipv6: "false"
external:
name: front

volumes:
snmptraps:

secrets:
MYSQL_USER:
file: ./.MYSQL_USER
MYSQL_PASSWORD:
file: ./.MYSQL_PASSWORD
MYSQL_ROOT_PASSWORD:
file: ./.MYSQL_ROOT_PASSWORD
POSTGRES_USER:
file: ./.POSTGRES_USER
POSTGRES_PASSWORD:
file: ./.POSTGRES_PASSWORD

[peathagore]

I had to uncomment

#DB_SERVER_HOST=postgres-server in .env_db_pgsql....

See ya