Is there a way to configure {$MYSQL.DSN} without odbc.ini entry? Not necessary need to be using {$MYSQL.DSN}, but where can I only use connection string without odbc.ini in host configuration page from zabbix?
Something like {$MYSQL.DSN} = db.odbc.select[,"DRIVER={MariaDB};SERVER=192.168.0.112;DATABASE=teste;USER=danilo;PASSWORD=test123;OPTION=3;"]
Yes, it is possible since version 5.0 of Zabbix: https://www.zabbix.com/documentation/5.0/en/manual/introduction/whatsnew500#odbc-monitoring-without-dsn
An example of what a connection string would look like in the item key in Zabbix (always try to use user macros to configure values such as the database name, MySQL server address, username and password):
db.odbc.get[your_sql_query,,"Driver=/usr/local/lib/libmyodbc8w.so;Database={$MYSQL.DATABASE};Server={$MYSQL.SERVER};Port={$MYSQL.PORT}"]
It seems that the official Zabbix documentation doesn t provide a very clear example of how to do this, but if you search on this page for "db.odbc.get" you will find an example.
MySQL documentation on how to install the ODBC connector.
Below is an example of how the ODBC driver can be installed in the official zabbix-server Docker image (in this example, Zabbix was running on an Ubuntu 22.04 64-bit ARM architecture):
tar zxvf mysql-connector-odbc-8.1.0-linux-glibc2.28-aarch64.tar.gz
cp bin/* /usr/local/bin
cp lib/* /usr/local/lib
myodbc-installer -a -d -n "MySQL ODBC 8.1 Unicode Driver" -t "Driver=/usr/local/lib/libmyodbc8w.so"
myodbc-installer -d -l
And of course, don t forget that when configuring your Zabbix Server (or Zabbix Proxy) you need to have at least 1 instance of the ODBC poller (StartODBCPollers parameter)
Is there a way to configure {$MYSQL.DSN} without odbc.ini entry? Not necessary need to be using {$MYSQL.DSN}, but where can I only use connection string without odbc.ini in host configuration page ...
I have an item setup to monitor fatal errors, and I want to add another item so that it calculates the count of the fatal errors and graphs them. Using this key: log["/d2/httpd/logs/myDomain-...
Anybody knows open source alternatives to zabbix to monitor website, performance, simulate get, post support authentification, https... Other tools nagios/frontends to nagios, cacti, etc are perfect ...
We have a web system like this: 10 servers with files and one front server which serves the web. We need to see the whole picture of what s going on with them. What monitoring system would you ...
Here is my goal: I would like to be able to report various metrics to zabbix so that we can display the graphs on a web page. These metrics include: latency per soap service submission various ...
Short background: I need to monitor the permissions on a unix file (a directory) with ZABBIX to see if/when they change. ZABBIX doesn t have any built in like vfs.file.mode[xxxx] for this, so I had to ...
In Zabbix, there is a well documented (although in Draft status) API for instantiating targets and controlling them. Does such an API exist in Nagios? The need for this is a cloud-based ...
I want to develop a monitoring tool to monitor active directory like (solar wind,op manager etc). For this purpose,I have chosen Zabbix(an open source tool) to monitor AD and provide me real time ...