ODBC monitoring error

[Cenzoooo]

Hello,

I can't set up ODBC monitoring for some reason and I am not sure why... In frontend I am getting error: Cannot connect to ODBC DSN: [SQL_ERROR]:[IM002][0][[unixODBC][Driver Manager]Data source name not found, and no default driver specified]
I did everything by the book:

root@zbx_database:~# more /etc/odbc.ini
[test]
Description = MySQL test database
Driver = mysql
DSN = test
Server = 172.16.10.144
User = zabbix
Password =
Port = 3306
Database = zabbix
------------------------
root@zbx_database:~# more /etc/odbcinst.ini
[mysql]
Description = ODBC for MySQL
Driver = /home/zabbix/mysql-connector-odbc-8.0.13-linux-ubuntu18.04-x86-64bit/lib/libmyodbc8w.so
Setup = /home/zabbix/mysql-connector-odbc-8.0.13-linux-ubuntu18.04-x86-64bit/lib/libmyodbc8w.so
FileUsage = 1

---------------------------------
root@zbx_database:/home/zabbix/mysql-connector-odbc-8.0.13-linux-ubuntu18.04-x86-64bit/lib# ls -l
total 13168
-rw-r--r-- 1 7161 31415 6013680 Sep 26 17:38 libmyodbc8S.so
-rw-r--r-- 1 7161 31415 7464712 Sep 26 17:38 libmyodbc8w.so

-------------------------------
root@zbx_database:~# isql -v test zabbix
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>


Configuration of an item is in attachement. What am I doing wrong?

[ArtursL]

Hi,
Have you tried troubleshooting ODBC via isql, for example?
You should be able to connect with the following command:
isql "DSN" "USER" PASSWORD"

[Semiadmin]

I'm not sure that's your only problem but ODBC LLD key must be db.odbc.discovery[something,test], not db.odbc.discovery[,test]

[clauclauds]

hey is this solve the problem? because i have same issues

[Singularity]

Can you post your item key here. I had the same problem, found out the issue was with the item key parameter. I was passing incorrect macro value in my key.

[pauliusbau]

Hi.
Had same issue. In my case SElinux was blocking access to odbc.ini:


Fixed it by executing these commands:

tail /var/log/audit/audit.log | audit2allow -M mypol
semodule -i mypol.pp