-
Type:
New Feature Request
-
Resolution: Unresolved
-
Priority:
Medium
-
None
-
Affects Version/s: None
-
Component/s: Agent (G), Agent2 (G)
-
None
It would be better to have a native ODBC capabilities on Zabbix Agent/Agent2.
Although we have plugins for Zabbix Agent2 but it doesn't have capability to create a custom DB check (query) through Zabbix UI as like it has for ODBC type item.
For such cases, we need to have a custom scripts files created in the target device and then restart the Zabbix Agent and then configure the Corresponding items in Zabbix UI.
Option 1:
We can have a additional item key's for custom DB metrics which allows to pass the Query in Zabbix UI as its done for ODBC items?
Type -> Zabbix Agent, Key -> mysql.odbc.get[]/mssql.odbc.get[], Type of information -> JSON and have a box for query.
Option 2:
A complete native ODBC feasibility built in Zabbix Agent2 (as like docker monitoring feasibility with Zabbix Agent2). Which has functionality like ODBC item type on Zabbix Agent2 without any additional configurations at target devices.
Type -> Zabbix Agent
Key -> mysql.odbc.get[] , mssql.odbc.get[] , postgres.odbc.get[] , oracle.odbc.get[]
Type of information -> JSON
Query box -> <TO WRITE THE QUERY>
I personally would like to have a Option 2 as preferred one.
Why this request?
With current Zabbix Agent2 plugins
1. there is no direct item for custom queries
2. Need to touch/access the target device and write queries in files and restart the Zabbix agent2
With current ODBC approach
1. Need to whitelist Zabbix Server/proxy IP's in Database level (eg: create user 'username'@'<ZABBIX_SERVER_IP>' identified by 'password'; )
2. Need to open DB specific port on network from Zabbix Proxy/server to the target machine.
3. installation & configuration of ODBC drivers on Zabbix Server/Proxy.
Putting forward this request as I see Native SNMP trap collector in 8.4 Roadmap so why not native ODBC on Zabbix Agent2?