Ad Widget

**rondo1** · 18-06-2024, 16:29

Thank you cyber and Markku for your help.

Indeed, grep "ZABBIX_VERSION" include/defines.inc.php showed 6.0.5.

My issue was Docker and how bind mounts work. Here's a snippet of my Docker compose file:

Code:

zabbix-web-nginx-mysql:
  image: zabbix/zabbix-web-nginx-mysql:7.0.0-alpine
  ports:
   - "80:80"
   - "443:443"
  volumes:
   - /etc/localtime:/etc/localtime:rw
   - /etc/timezone:/etc/timezone:rw
   - ./zbx_env/etc/ssl/nginx:/etc/ssl/nginx:rw
   - ./zbx_env/usr/share/zabbix/modules/:/usr/share/zabbix/modules/:rw
   - ./zbx_env/usr/share/zabbix/local/conf/:/usr/share/zabbix/local/conf/:ro
   - ./zbx_env/usr/share/zabbix/:/usr/share/zabbix/:rw
   - ./zbx_env/etc/nginx/:/etc/nginx/:rw

When I would bring the container up, the front end 7.0 would get overwritten by the directories on the host machine. The upgrade happens in the container and not on the host machine. Because of this, the bind mount ./zbx_env/usr/share/zabbix/ was overwriting the container files at/ usr/share/zabbix. The files on the host were still version 6.0.5.

Solution:

Disable the bind mounts.

Code:

	zabbix-web-nginx-mysql:
	 image: zabbix/zabbix-web-nginx-mysql:7.0.0-alpine
	 ports:
	  - "80:80"
	  - "443:443"
	 volumes:
	#   - /etc/localtime:/etc/localtime:rw
	#   - /etc/timezone:/etc/timezone:rw
	#   - ./zbx_env/etc/ssl/nginx:/etc/ssl/nginx:rw
	#   - ./zbx_env/usr/share/zabbix/modules/:/usr/share/zabbix/modules/:rw
	#   - ./zbx_env/usr/share/zabbix/local/conf/:/usr/share/zabbix/local/conf/:ro
	#   - ./zbx_env/usr/share/zabbix/:/usr/share/zabbix/:rw
	#   - ./zbx_env/etc/nginx/:/etc/nginx/:rw

Bring the containers up

Code:

	$ docker-compose -f docker-compose.yaml

Copy the updated directory to the host machine

Code:

	$ docker cp zabbix-docker_zabbix-web-nginx-mysql_1:/usr/share/zabbix/ /path/to/host

Move updated files to the path of the bind mount. In my case it was ./zbx_env/usr/share/zabbix
Code:
```
	$ sudo mv -f * /home/irlocal/zabbix-docker/zbx_env/usr/share/zabbix/
```
Uncomment the bind mounts from the compose file.

Bring the containers back up

Code:

	$ docker-compose -f docker-compose.yaml up -d

**Markku** · 15-06-2024, 21:48

This error shows in the frontend: Database error
The Zabbix database version does not match current requirements. Your database version: 7000000. Required version: 6000000.

This means that your frontend is still at version 6.0.x. You need to upgrade your frontend to 7.0.0.

Markku

**rondo1** · 17-06-2024, 14:57

Thanks. I do not understand how is the front end on version 6.0.x when the Docker image I am using is specifically 7.0.0. Here is my entire compose file (with sensitive info redacted). Can you explain why the front end would still be on 6.0.x? Additionally, there is nothing in the NGINX logs that show any errors.

Code:

version: '3.5'
services:
 zabbix-server:
  image: zabbix/zabbix-server-mysql:7.0.0-alpine
  ports:
   - "10051:10051"
  volumes:
   - /etc/localtime:/etc/localtime:ro
   - /etc/timezone:/etc/timezone:ro
   - ./zbx_env/usr/lib/zabbix/alertscripts:/usr/lib/zabbix/alertscripts:ro
   - ./zbx_env/usr/lib/zabbix/externalscripts:/usr/lib/zabbix/externalscripts:ro
   - ./zbx_env/var/lib/zabbix/export:/var/lib/zabbix/export:rw
   - ./zbx_env/var/lib/zabbix/modules:/var/lib/zabbix/modules:ro
   - ./zbx_env/var/lib/zabbix/enc:/var/lib/zabbix/enc:ro
   - ./zbx_env/var/lib/zabbix/ssh_keys:/var/lib/zabbix/ssh_keys:ro
   - ./zbx_env/var/lib/zabbix/mibs:/var/lib/zabbix/mibs:rw
   - ./zbx_env/var/lib/zabbix/ssl:/var/lib/zabbix/ssl:ro
   - snmptraps:/var/lib/zabbix/snmptraps:rw
  env_file:
   - ./env_vars/.env_db_mysql
   - ./env_vars/.env_srv
  secrets:
   - [B]REDACTED[/B]
  depends_on:
   - mysql-server
   - zabbix-agent
  networks:
   zbx_net_backend:
     aliases:
      - zabbix-server
      - zabbix-server-mysql
      - zabbix-server-alpine-mysql
      - zabbix-server-mysql-alpine
     ipv4_address: [B]REDACTED[/B]
   zbx_net_frontend:
  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 MySQL database support"
   com.zabbix.company: "Zabbix LLC"
   com.zabbix.component: "zabbix-server"
   com.zabbix.dbtype: "mysql"
   com.zabbix.os: "alpine"
  logging:
   options:
    max-size: "10m"

 zabbix-web-nginx-mysql:
  image: zabbix/zabbix-web-nginx-mysql:7.0.0-alpine
  ports:
   - "80:80"
   - "443:443"
  volumes:
   - /etc/localtime:/etc/localtime:ro
   - /etc/timezone:/etc/timezone:ro
   - ./zbx_env/etc/ssl/nginx:/etc/ssl/nginx:ro
   - ./zbx_env/usr/share/zabbix/modules/:/usr/share/zabbix/modules/:ro
#   - ./zbx_env/usr/share/zabbix/local/conf/:/usr/share/zabbix/local/conf/:ro
   - ./zbx_env/usr/share/zabbix/:/usr/share/zabbix/:ro
   - ./zbx_env/etc/nginx/:/etc/nginx/:ro
  env_file:
   - ./env_vars/.env_db_mysql
   - ./env_vars/.env_web
  secrets:
   - [B]REDACTED[/B]
  depends_on:
   - zabbix-agent
   - mysql-server
   - zabbix-server
  networks:
   zbx_net_backend:
    aliases:
     - zabbix-web-nginx-mysql
     - zabbix-web-nginx-alpine-mysql
     - zabbix-web-nginx-mysql-alpine
   zbx_net_frontend:
  stop_grace_period: 10s
  sysctls:
   - net.core.somaxconn=65535
  labels:
   com.zabbix.description: "Zabbix frontend on Nginx web-server with MySQL database support"
   com.zabbix.company: "Zabbix LLC"
   com.zabbix.component: "zabbix-frontend"
   com.zabbix.webserver: "nginx"
   com.zabbix.dbtype: "mysql"
   com.zabbix.os: "alpine"

 zabbix-agent:
  image: zabbix/zabbix-agent2:7.0.0-alpine
  ports:
   - "10050:10050"
  volumes:
   - /etc/localtime:/etc/localtime:ro
   - /etc/timezone:/etc/timezone:ro
   - ./zbx_env/etc/zabbix/zabbix_agentd.d:/etc/zabbix/zabbix_agentd.d:ro
   - ./zbx_env/var/lib/zabbix/modules:/var/lib/zabbix/modules:ro
   - ./zbx_env/var/lib/zabbix/enc:/var/lib/zabbix/enc:ro
   - ./zbx_env/var/lib/zabbix/ssh_keys:/var/lib/zabbix/ssh_keys:ro
  env_file:
   - ./env_vars/.env_agent
  privileged: true
  pid: "host"
  networks:
   zbx_net_backend:
    aliases:
     - zabbix-agent
     - zabbix-agent-passive
     - zabbix-agent-alpine
    ipv4_address: [B]REDACTED[/B]
  stop_grace_period: 5s
  labels:
   com.zabbix.description: "Zabbix agent"
   com.zabbix.company: "Zabbix LLC"
   com.zabbix.component: "zabbix-agentd"
   com.zabbix.os: "alpine"
  tty: true

 zabbix-snmptraps:
  image: zabbix/zabbix-snmptraps:7.0.0-alpine
  ports:
   - "162:1162/udp"
  volumes:
   - snmptraps:/var/lib/zabbix/snmptraps
   - ./zbx_env/var/lib/zabbix/mibs:/var/lib/zabbix/mibs:rw
   - ./zbx_env/var/lib/zabbix/snmptraps:/etc/snmp
  networks:
   zbx_net_frontend:
    aliases:
     - zabbix-snmptraps
   zbx_net_backend:
  stop_grace_period: 5s
  depends_on:
    - zabbix-agent
  labels:
   com.zabbix.description: "Zabbix snmptraps"
   com.zabbix.company: "Zabbix LLC"
   com.zabbix.component: "snmptraps"
   com.zabbix.os: "alpine"

 mysql-server:
  image: mysql:8.0.30
  command:
   - mysqld
   - --character-set-server=utf8mb4
   - --collation-server=utf8mb4_bin
   - --default-authentication-plugin=mysql_native_password
   - --skip-character-set-client-handshake
   - --binlog_expire_logs_seconds=259200
   - --log_bin_trust_function_creators=1
  volumes:
   - /home/irlocal/zabbix-docker/zbx_env/var/lib/mysql:/var/lib/mysql:rw
   - /home/irlocal/zabbix-docker/zbx_env/etc/mysql/conf.d/docker.cnf:/etc/mysql/conf.d/docker.cnf:rw
  env_file:
   - ./env_vars/.env_db_mysql
  secrets:
   - [B]REDACTED[/B]
  stop_grace_period: 1m
  depends_on:
    - zabbix-agent
  networks:
   zbx_net_backend:
    aliases:
     - mysql-server
     - zabbix-database
     - mysql-database

networks:
  zbx_net_frontend:
    driver: bridge
    driver_opts:
      com.docker.network.enable_ipv6: "false"
    ipam:
      driver: default
      config:
      - subnet: [B]REDACTED[/B]
  zbx_net_backend:
    driver: bridge
    driver_opts:
      com.docker.network.enable_ipv6: "false"
    internal: true
    ipam:
      driver: default
      config:
      - subnet: [B]REDACTED[/B]

volumes:
  snmptraps:
  ldapconfig:
secrets:
  [B]REDACTED[/B]

Nginx front end logs. The GET request at the end of the logs returns the database error in the browser.

Code:

$ docker logs -f zabbix-docker_zabbix-web-nginx-mysql_1
** Deploying Zabbix web-interface (Nginx) with MySQL database
********************
* DB_SERVER_HOST: mysql-server
* DB_SERVER_PORT: 3306
* DB_SERVER_DBNAME: zabbix
********************
**** MySQL server is not available. Waiting 5 seconds...
** Adding Zabbix virtual host (HTTP)
**** Impossible to enable SSL support for Nginx. Certificates are missed.
** Preparing Zabbix frontend configuration file
########################################################
** Executing supervisord
2024-06-17 12:50:11,563 INFO Included extra file "/etc/supervisor/conf.d/supervisord_zabbix.conf" during parsing
2024-06-17 12:50:11,563 INFO Included extra file "/etc/supervisor/conf.d/supervisord_zabbix.conf" during parsing
2024-06-17 12:50:11,575 INFO RPC interface 'supervisor' initialized
2024-06-17 12:50:11,575 INFO RPC interface 'supervisor' initialized
2024-06-17 12:50:11,576 INFO supervisord started with pid 1
2024-06-17 12:50:11,576 INFO supervisord started with pid 1
2024-06-17 12:50:12,580 INFO spawned: 'nginx' with pid 19
2024-06-17 12:50:12,580 INFO spawned: 'nginx' with pid 19
2024-06-17 12:50:12,585 INFO spawned: 'php-fpm83' with pid 20
2024-06-17 12:50:12,585 INFO spawned: 'php-fpm83' with pid 20
2024/06/17 12:50:12 [warn] 19#19: the "user" directive makes sense only if the master process runs with super-user privileges, ignored in /etc/nginx/nginx.conf:1
nginx: [warn] the "user" directive makes sense only if the master process runs with super-user privileges, ignored in /etc/nginx/nginx.conf:1
2024/06/17 12:50:12 [warn] 19#19: the "listen ... http2" directive is deprecated, use the "http2" directive instead in /etc/nginx/nginx.conf:78
nginx: [warn] the "listen ... http2" directive is deprecated, use the "http2" directive instead in /etc/nginx/nginx.conf:78
[17-Jun-2024 12:50:12] NOTICE: fpm is running, pid 20
[17-Jun-2024 12:50:12] NOTICE: ready to handle connections
2024-06-17 12:50:14,769 INFO success: nginx entered RUNNING state, process has stayed up for > than 2 seconds (startsecs)
2024-06-17 12:50:14,769 INFO success: nginx entered RUNNING state, process has stayed up for > than 2 seconds (startsecs)
2024-06-17 12:50:14,769 INFO success: php-fpm83 entered RUNNING state, process has stayed up for > than 2 seconds (startsecs)
2024-06-17 12:50:14,769 INFO success: php-fpm83 entered RUNNING state, process has stayed up for > than 2 seconds (startsecs)
192.168.8.30 - - [17/Jun/2024:12:50:28 +0000] "GET /zabbix.php?action=problem.view HTTP/2.0" 500 0 "https://zabbix.net.local/actionconf.php?action=action.massdisable&eventsource=0&g_actionid[]=3" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:126.0) Gecko/20100101 Firefox/126.0" "-"

**Markku** · 18-06-2024, 07:21

I don't do docker, it's far too complicated for my static workloads (like Zabbix).

You showed some config file (= "intended state"), but can you show some runtime status command that shows you are actually running a 7.0.0 frontend?

Markku

**cyber** · 18-06-2024, 10:47

Code:

grep "ZABBIX_VERSION" include/defines.inc.php

Should show your GUI version

**rondo1** · 18-06-2024, 16:29

Thank you cyber and Markku for your help.

Indeed, grep "ZABBIX_VERSION" include/defines.inc.php showed 6.0.5.

My issue was Docker and how bind mounts work. Here's a snippet of my Docker compose file:

Code:

zabbix-web-nginx-mysql:
  image: zabbix/zabbix-web-nginx-mysql:7.0.0-alpine
  ports:
   - "80:80"
   - "443:443"
  volumes:
   - /etc/localtime:/etc/localtime:rw
   - /etc/timezone:/etc/timezone:rw
   - ./zbx_env/etc/ssl/nginx:/etc/ssl/nginx:rw
   - ./zbx_env/usr/share/zabbix/modules/:/usr/share/zabbix/modules/:rw
   - ./zbx_env/usr/share/zabbix/local/conf/:/usr/share/zabbix/local/conf/:ro
   - ./zbx_env/usr/share/zabbix/:/usr/share/zabbix/:rw
   - ./zbx_env/etc/nginx/:/etc/nginx/:rw

When I would bring the container up, the front end 7.0 would get overwritten by the directories on the host machine. The upgrade happens in the container and not on the host machine. Because of this, the bind mount ./zbx_env/usr/share/zabbix/ was overwriting the container files at/ usr/share/zabbix. The files on the host were still version 6.0.5.

Solution:

Disable the bind mounts.

Code:

	zabbix-web-nginx-mysql:
	 image: zabbix/zabbix-web-nginx-mysql:7.0.0-alpine
	 ports:
	  - "80:80"
	  - "443:443"
	 volumes:
	#   - /etc/localtime:/etc/localtime:rw
	#   - /etc/timezone:/etc/timezone:rw
	#   - ./zbx_env/etc/ssl/nginx:/etc/ssl/nginx:rw
	#   - ./zbx_env/usr/share/zabbix/modules/:/usr/share/zabbix/modules/:rw
	#   - ./zbx_env/usr/share/zabbix/local/conf/:/usr/share/zabbix/local/conf/:ro
	#   - ./zbx_env/usr/share/zabbix/:/usr/share/zabbix/:rw
	#   - ./zbx_env/etc/nginx/:/etc/nginx/:rw

Bring the containers up

Code:

	$ docker-compose -f docker-compose.yaml

Copy the updated directory to the host machine

Code:

	$ docker cp zabbix-docker_zabbix-web-nginx-mysql_1:/usr/share/zabbix/ /path/to/host

Move updated files to the path of the bind mount. In my case it was ./zbx_env/usr/share/zabbix
Code:
```
	$ sudo mv -f * /home/irlocal/zabbix-docker/zbx_env/usr/share/zabbix/
```
Uncomment the bind mounts from the compose file.

Bring the containers back up

Code:

	$ docker-compose -f docker-compose.yaml up -d

**rondo1** · 18-06-2024, 16:30

binderth, maybe this will help you.

Ad Widget

Upgrading to 7.0 - Database error in frontend, no errors in logs

Upgrading to 7.0 - Database error in frontend, no errors in logs

Comment

Comment

Comment

Comment

Comment

Comment

Comment