search

zabbix / zabbix-docker

Official Zabbix Dockerfiles
https://www.zabbix.com
GNU Affero General Public License v3.0
2.36k stars 1.37k forks source link

Unable to determine current Zabbix database version: the table "dbversion" was not found. #1102

Closed jiriks74 closed 11 months ago

jiriks74 commented 11 months ago
SUMMARY

I'm having trouble starting up the Zabbix stack on my Raspberry Pi. I've setup the docker-compose.yml file with multiple example files:

docker-compose_v3_alpine_mysql_latest.yaml
docker-compose_v3_alpine_pgsql_latest.yaml
docker-compose_v3_ubuntu_mysql_latest.yaml
docker-compose_v3_ubuntu_pgsql_latest.yaml

I've copied and renamed the example file to docker-compose.yml and I've copied the env_vars diectory as well only changing the passwords. The other thing I changed were the ports for the web server from 80 to 8880 and from 443 to 4443 - I've changed it through docker - I haven't modified any Zabbix settings.

OS / ENVIRONMENT / Used docker-compose files

OS: Debian 11 - Bullseye Docker: 24.0.7, build afdd53b

CONFIGURATION

I've changed:

docker-compose.yml ```yaml version: '3.5' services: zabbix-server: image: zabbix/zabbix-server-mysql:centos-6.4-latest ports: - "10051:10051" volumes: - /etc/localtime:/etc/localtime:ro - /etc/timezone:/etc/timezone:ro - dbsocket:/var/run/mysqld/ - ./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/dbscripts:/var/lib/zabbix/dbscripts: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:ro - snmptraps:/var/lib/zabbix/snmptraps:rw 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_vars/.env_db_mysql - ./env_vars/.env_srv secrets: - MYSQL_USER - MYSQL_PASSWORD - MYSQL_ROOT_USER - MYSQL_ROOT_PASSWORD # - client-key.pem # - client-cert.pem # - root-ca.pem depends_on: - mysql-server networks: zbx_net_backend: aliases: - zabbix-server - zabbix-server-mysql - zabbix-server-centos-mysql - zabbix-server-mysql-centos zbx_net_frontend: # devices: # - "/dev/ttyUSB0:/dev/ttyUSB0" stop_grace_period: 30s sysctls: - net.ipv4.ip_local_port_range=1024 64999 - 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: "centos" zabbix-proxy-sqlite3: image: zabbix/zabbix-proxy-sqlite3:centos-6.4-latest profiles: - all ports: - "10061:10051" volumes: - /etc/localtime:/etc/localtime:ro - /etc/timezone:/etc/timezone:ro - ./zbx_env/usr/lib/zabbix/externalscripts:/usr/lib/zabbix/externalscripts: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 - ./zbx_env/var/lib/zabbix/mibs:/var/lib/zabbix/mibs:ro - snmptraps:/var/lib/zabbix/snmptraps:rw ulimits: nproc: 65535 nofile: soft: 20000 hard: 40000 deploy: resources: limits: cpus: '0.70' memory: 512M reservations: cpus: '0.3' memory: 256M env_file: - ./env_vars/.env_prx - ./env_vars/.env_prx_sqlite3 depends_on: - zabbix-java-gateway - zabbix-snmptraps networks: zbx_net_backend: aliases: - zabbix-proxy-sqlite3 - zabbix-proxy-centos-sqlite3 - zabbix-proxy-sqlite3-centos zbx_net_frontend: stop_grace_period: 30s labels: com.zabbix.description: "Zabbix proxy with SQLite3 database support" com.zabbix.company: "Zabbix LLC" com.zabbix.component: "zabbix-proxy" com.zabbix.dbtype: "sqlite3" com.zabbix.os: "centos" zabbix-proxy-mysql: image: zabbix/zabbix-proxy-mysql:centos-6.4-latest profiles: - all ports: - "10071:10051" volumes: - /etc/localtime:/etc/localtime:ro - /etc/timezone:/etc/timezone:ro - dbsocket:/var/run/mysqld/ - ./zbx_env/usr/lib/zabbix/externalscripts:/usr/lib/zabbix/externalscripts: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 - ./zbx_env/var/lib/zabbix/mibs:/var/lib/zabbix/mibs:ro - snmptraps:/var/lib/zabbix/snmptraps:rw ulimits: nproc: 65535 nofile: soft: 20000 hard: 40000 deploy: resources: limits: cpus: '0.70' memory: 512M reservations: cpus: '0.3' memory: 256M env_file: - ./env_vars/.env_db_mysql_proxy - ./env_vars/.env_prx - ./env_vars/.env_prx_mysql depends_on: - mysql-server - zabbix-java-gateway - zabbix-snmptraps secrets: - MYSQL_USER - MYSQL_PASSWORD - MYSQL_ROOT_USER - MYSQL_ROOT_PASSWORD # - client-key.pem # - client-cert.pem # - root-ca.pem networks: zbx_net_backend: aliases: - zabbix-proxy-mysql - zabbix-proxy-centos-mysql - zabbix-proxy-mysql-centos zbx_net_frontend: stop_grace_period: 30s labels: com.zabbix.description: "Zabbix proxy with MySQL database support" com.zabbix.company: "Zabbix LLC" com.zabbix.component: "zabbix-proxy" com.zabbix.dbtype: "mysql" com.zabbix.os: "centos" zabbix-web-apache-mysql: image: zabbix/zabbix-web-apache-mysql:centos-6.4-latest profiles: - all ports: - "8081:8080" - "8443:8443" volumes: - /etc/localtime:/etc/localtime:ro - /etc/timezone:/etc/timezone:ro - dbsocket:/var/run/mysqld/ - ./zbx_env/etc/ssl/apache2:/etc/ssl/apache2:ro - ./zbx_env/usr/share/zabbix/modules/:/usr/share/zabbix/modules/:ro deploy: resources: limits: cpus: '0.70' memory: 512M reservations: cpus: '0.5' memory: 256M env_file: - ./env_vars/.env_db_mysql - ./env_vars/.env_web secrets: - MYSQL_USER - MYSQL_PASSWORD # - client-key.pem # - client-cert.pem # - root-ca.pem depends_on: - mysql-server - zabbix-server healthcheck: test: ["CMD", "curl", "-f", "http://localhost:8080/ping"] interval: 10s timeout: 5s retries: 3 start_period: 30s networks: zbx_net_backend: aliases: - zabbix-web-apache-mysql - zabbix-web-apache-centos-mysql - zabbix-web-apache-mysql-centos zbx_net_frontend: stop_grace_period: 10s sysctls: - net.core.somaxconn=65535 labels: com.zabbix.description: "Zabbix frontend on Apache web-server with MySQL database support" com.zabbix.company: "Zabbix LLC" com.zabbix.component: "zabbix-frontend" com.zabbix.webserver: "apache2" com.zabbix.dbtype: "mysql" com.zabbix.os: "centos" zabbix-web-nginx-mysql: image: zabbix/zabbix-web-nginx-mysql:centos-6.4-latest ports: - "8880:8080" - "4443:8443" volumes: - /etc/localtime:/etc/localtime:ro - /etc/timezone:/etc/timezone:ro - dbsocket:/var/run/mysqld/ - ./zbx_env/etc/ssl/nginx:/etc/ssl/nginx:ro - ./zbx_env/usr/share/zabbix/modules/:/usr/share/zabbix/modules/:ro deploy: resources: limits: cpus: '0.70' memory: 512M reservations: cpus: '0.5' memory: 256M env_file: - ./env_vars/.env_db_mysql - ./env_vars/.env_web secrets: - MYSQL_USER - MYSQL_PASSWORD # - client-key.pem # - client-cert.pem # - root-ca.pem depends_on: - mysql-server - zabbix-server healthcheck: test: ["CMD", "curl", "-f", "http://localhost:8080/ping"] interval: 10s timeout: 5s retries: 3 start_period: 30s networks: zbx_net_backend: aliases: - zabbix-web-nginx-mysql - zabbix-web-nginx-centos-mysql - zabbix-web-nginx-mysql-centos 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: "centos" zabbix-agent: image: zabbix/zabbix-agent:centos-6.4-latest profiles: - full - all 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 deploy: resources: limits: cpus: '0.2' memory: 128M reservations: cpus: '0.1' memory: 64M mode: global env_file: - ./env_vars/.env_agent privileged: true pid: "host" networks: zbx_net_backend: aliases: - zabbix-agent - zabbix-agent-passive - zabbix-agent-centos stop_grace_period: 5s labels: com.zabbix.description: "Zabbix agent" com.zabbix.company: "Zabbix LLC" com.zabbix.component: "zabbix-agentd" com.zabbix.os: "centos" zabbix-java-gateway: image: zabbix/zabbix-java-gateway:centos-6.4-latest profiles: - full - all ports: - "10052:10052" deploy: resources: limits: cpus: '0.5' memory: 512M reservations: cpus: '0.25' memory: 256M env_file: - ./env_vars/.env_java networks: zbx_net_backend: aliases: - zabbix-java-gateway - zabbix-java-gateway-centos stop_grace_period: 5s labels: com.zabbix.description: "Zabbix Java Gateway" com.zabbix.company: "Zabbix LLC" com.zabbix.component: "java-gateway" com.zabbix.os: "centos" zabbix-snmptraps: image: zabbix/zabbix-snmptraps:centos-6.4-latest profiles: - full - all ports: - "162:1162/udp" volumes: - snmptraps:/var/lib/zabbix/snmptraps:rw deploy: resources: limits: cpus: '0.5' memory: 256M reservations: cpus: '0.25' memory: 128M networks: zbx_net_frontend: aliases: - zabbix-snmptraps zbx_net_backend: stop_grace_period: 5s labels: com.zabbix.description: "Zabbix snmptraps" com.zabbix.company: "Zabbix LLC" com.zabbix.component: "snmptraps" com.zabbix.os: "centos" zabbix-web-service: image: zabbix/zabbix-web-service:centos-6.4-latest profiles: - full - all ports: - "10053:10053" volumes: - ./zbx_env/var/lib/zabbix/enc:/var/lib/zabbix/enc:ro security_opt: - seccomp:./env_vars/chrome_dp.json deploy: resources: limits: cpus: '0.5' memory: 512M reservations: cpus: '0.25' memory: 256M env_file: - ./env_vars/.env_web_service networks: zbx_net_backend: aliases: - zabbix-web-service - zabbix-web-service-centos stop_grace_period: 5s labels: com.zabbix.description: "Zabbix web service" com.zabbix.company: "Zabbix LLC" com.zabbix.component: "web-service" com.zabbix.os: "centos" mysql-server: image: mysql:8.0-oracle command: - mysqld - --character-set-server=utf8mb4 - --collation-server=utf8mb4_bin # Only during upgrade from versions prior 6.4 # - --log_bin_trust_function_creators=1 # Use TLS encryption for connections to database # - --require-secure-transport # - --ssl-ca=/run/secrets/root-ca.pem # - --ssl-cert=/run/secrets/server-cert.pem # - --ssl-key=/run/secrets/server-key.pem volumes: - ./zbx_env/var/lib/mysql:/var/lib/mysql:rw - dbsocket:/var/run/mysqld/ env_file: - ./env_vars/.env_db_mysql secrets: - MYSQL_USER - MYSQL_PASSWORD - MYSQL_ROOT_PASSWORD # - server-key.pem # - server-cert.pem # - root-ca.pem stop_grace_period: 1m networks: zbx_net_backend: aliases: - mysql-server - zabbix-database - mysql-database db_data_mysql: image: busybox volumes: - ./zbx_env/var/lib/mysql:/var/lib/mysql: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 volumes: snmptraps: dbsocket: secrets: MYSQL_USER: file: ./env_vars/.MYSQL_USER MYSQL_PASSWORD: file: ./env_vars/.MYSQL_PASSWORD MYSQL_ROOT_USER: file: ./env_vars/.MYSQL_ROOT_USER MYSQL_ROOT_PASSWORD: file: ./env_vars/.MYSQL_ROOT_PASSWORD # client-key.pem: # file: ./env_vars/.ZBX_DB_KEY_FILE # client-cert.pem: # file: ./env_vars/.ZBX_DB_CERT_FILE # root-ca.pem: # file: ./env_vars/.ZBX_DB_CA_FILE # server-cert.pem: # file: ./env_vars/.DB_CERT_FILE # server-key.pem: # file: ./env_vars/.DB_KEY_FILE ```
STEPS TO REPRODUCE
git clone https://github.com/zabbix/zabbix-docker
cp -r zabbix-docker/env_vars .
cp zabbix-docker/docker-compose_v3_alpine_mysql_latest.yaml docker-compose.yml
docker compose --profile full up -d
EXPECTED RESULTS

Zabbix successfully initializing with the default config

ACTUAL RESULTS

Error when opening the Zabbix web interface

Screenshot ![image](https://github.com/zabbix/zabbix-docker/assets/54378412/7457c4c1-02d8-4134-87cb-e6ffaeba291a)
ADITIONAL INFORMATION

I've executed the commands below

git clone https://github.com/zabbix/zabbix-docker
cp -r zabbix-docker/env_vars .
cp zabbix-docker/docker-compose_v3_alpine_mysql_latest.yaml docker-compose.yml
docker compose --profile full up -d

changing only the ports from 80:80 to 8880:8080 and from 443:443 to 4443:8443. Still the same issue.

Setup recording

asciicast

jiriks74 commented 11 months ago

Dropping zabbix and zabbix_proxy databases and running docker compose restart zabbix-server zabbix-web-nginx-mysql didn't help either.

jiriks74 commented 11 months ago

After creating the recording I now get Unable to select configuration.

jiriks74 commented 11 months ago

Ok, fixed it. I deleted the database and the user and then waited for an hour. I think that it should be mentioned in the logs and documentation that the process takes a long time.