Zabbix, ODBC, data monitoring in a table in Mysql database?

Question

MySQL

Dear hello!
the crux of the matter is this!
I created a Data Element in Zabbix and with the help of a SQL query I will determine what value it has, I have only two of them 1 or 0.
During the test, all this element screams everything works fine, but there is no data.

Answer 1

before setting up Zabbix, you need to install and configure unixODBC and ODBC drivers for the required DBMS in the system.
First, you get the command to work isql -v TEST
. Then you set up environment variables for the zabbix daemon.
And only then you pick the zabbix frontend . Keep
useful links:
https://www.zabbix. com/documentation/3.4/manual/co...
https://habr.com/en/post/226365/