Details Cannot connect to the database.

[paulhung]

I have got with this: Unable to determine current Zabbix database version: the table "dbversion" was not found. I have tried many time, however, I could not fix this.
Please help me to solve this.
(the detail in the image)
Thank you,

Paul,

[cyber]

dbversion is the first table it checks, if it cannot find it, check your DB, if you schema is in place.

[paulhung]

dbversion is the first table it checks, if it cannot find it, check your DB, if you schema is in place.

Thank you. Let me check it.

[paulhung]

dbversion is the first table it checks, if it cannot find it, check your DB, if you schema is in place.

I still get this error:

sudo zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -u zabbix -p <passofzabbix>
Enter password: gzip: /usr/share/doc/zabbix-server-mysql*/create.sql.gz: No such file or directory
ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: NO)

~# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 5841
Server version: 10.11.2-MariaDB-1:10.11.2+maria~ubu2004 mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use zabbix;
Database changed
MariaDB [zabbix]> show tables;
Empty set (0.000 sec)

MariaDB [zabbix]>

Please help!

Thanks,

[Atsushi]

What version and platform of Zabbix are you trying to install? Have you installed the zabbix-sql-scripts package?
Depending on the version, the file to use will be the following path.
/usr/share/zabbix-sql-scripts/mysql/server.sql.gz

Select your Zabbix version and platform on the download page to see the instructions.

https://www.zabbix.com/download

[paulhung]

dbversion is the first table it checks, if it cannot find it, check your DB, if you schema is in place.

Thank you, I missed the schema. Now I have fixed, It is done.

Thanks again.

Paul,

[paulhung]

dbversion is the first table it checks, if it cannot find it, check your DB, if you schema is in place.

By the way, please show me:

Do I just use a zabbix server to monitor all networks and server in my system, or we need both to use zabbix server and zabbix proxy server to monitor a network system?
If I use both, what is the advantage and disadvantage?
When I use both, if a zabbix server down, zabbix proxy server is active. Can I still monitor the services in my networking system? I still confuse this.

Thanks in advanced,

Paul

[cyber]

https://www.zabbix.com/documentation...ction/overview ...
How hard can it be?
Server is a must and proxies are optional. Depending on the size of your environment it may be useful to have proxies to spread the load of polling and leave server to do all the calculation work.
Your proxies will keep polling hosts even if your server is down. When server comes up again, proxies will forward all the data. Of course it is not possible to get any notifications, while server is down...

[paulhung]

https://www.zabbix.com/documentation...ction/overview ...
How hard can it be?
Server is a must and proxies are optional. Depending on the size of your environment it may be useful to have proxies to spread the load of polling and leave server to do all the calculation work.
Your proxies will keep polling hosts even if your server is down. When server comes up again, proxies will forward all the data. Of course it is not possible to get any notifications, while server is down...

Y networking system is small ISP. It has over 20.000 sensors to monitoring. Running both zabbix server and proxy server is better, however, I am a new person approaching the open-source. So it will be difficult for me to troubleshoot if there is something wrong happened .

I will setup both to operate.

Thank you,

Paul,