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

zabbix
Nurin Izzati Jafri picture Nurin Izzati Jafri · Sep 25, 2020 · Viewed 8.5k times · Source

OS: Debian10 App: Zabbix4.0 Installed app:Mariadb,Apache2,php

I got this error after I input this command in mysql.

create database zabbix character set utf8 collate utf8_bin;

and when I tried to restart zabbix-server,

zabbix-server.service: Can't open PID file /run/zabbix/zabbix_server..

Any idea regarding this error?

enter image description here

Answer

Reset picture Reset · Mar 29, 2021

This message means you don't have schema just run zcat /usr/share/doc/zabbix-server-mysql/create.sql.gz | mysql -uzabbix -p zabbix after that enter password wait around 10-30sec when import schema will be done for Ubuntu run:

systemctl restart zabbix-server zabbix-agent httpd php-fpm
systemctl enable zabbix-server zabbix-agent httpd php-fpm

Then go to http://server_ip_or_name/zabbix and complete setup.

Related questions

Zabbix server is not running: the information displayed may not be current

So all of a sudden, after a week of using it, I get an error message on my zabbix server gui (http://localhost/zabbix/.) The error says: Zabbix server is not running: the information displayed may not be current. Any …

Read More
Zabbix can't get value from Agent (Interrupted system call)

I have problem with the setup of zabbix agent on my Ubuntu 10.04 (lucid) server. I have zabbix server on other server and I configured hosts in server and agent how it should be (used zabbix manual), but Zabbix server cannot …

Read More
What's the difference between Prometheus and Zabbix?

Just as the title said, can you tell me the differences between Prometheus and Zabbix?

Read More