Database errors appear while accessing the Zabbix web frontend by its IP address. How do I fix this?
A Zabbix database is created during the installation of a Zabbix virtual appliance. During the initialization process the web frontend displays "Database error" messages multiple times.


You must wait for 10-20 minutes for the database creation to complete and to redirect you to the login page. The web frontend operates normally once the initialization process is complete.
Do not turn off the virtual machine during the database creation process. If the virtual machine is turned off or runs into errors, perform the following steps to reinitialize the virtual appliance manually:
- Open the virtual appliance and log in with the default Zabbix credentials:
Appliance login:
root
Password:
zabbix
- Execute the following command in the command prompt:
Important:
- Ensure you have a stable internet connection before executing the command.
- The command execution removes and downloads all the virtual appliance packages again.
- All existing Zabbix data is permanently removed and cannot be recovered.
- Do not execute the reset command in a production environment.
[root@appliance ~] /opt/zabbix/scripts/zbx_init.sh --force
Wait for database reinitialization process to finish. The process might take 10-20 minutes depending on the virtual machine computing power.
- Enter the following command to check the status of the virtual appliance:
[root@appliance ~] systemctl status
Appliance status during initialization: starting
Appliance status after initialization: runningPerform a graceful shutdown once the status is “running” so that the virtual appliance can save the necessary configuration in the virtual machine.
- Enter the following command to perform a graceful shutdown:
[root@appliance ~] shutdown -h now
- Start the virtual appliance again. The Zabbix web frontend is displayed normally once all the services are online. The start up process might take approximately 10 minutes.
Reference:
For details on using the virtual appliance, see the Zabbix user manual:
https://www.zabbix.com/documentation/current/manual/appliance