[ZBXNEXT-2303] Database monitor items without DSN in odbc.ini Created: 2014 May 15  Updated: 2014 May 19  Resolved: 2014 May 19

Status: Closed
Project: ZABBIX FEATURE REQUESTS
Component/s: Server (S)
Affects Version/s: 2.2.1
Fix Version/s: None

Type: New Feature Request Priority: Minor
Reporter: v99glu Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: dsn, odbc
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Zabbix 2.2.1
unixODBC 3.2.3


Issue Links:
Duplicate
duplicates ZBXNEXT-1961 Database monitor ODBC connections sho... Closed

 Description   

In accordance with Zabbix documentation we have item key "db.odbc.select[unique_description,data_source_name]" to query a database via ODBC.
But in a case of LLD of databases on a host we haven't got a DSN on a Zabbix-server corresponding to discovered database. So, we need to add the DSN into odbc.ini and only after that we can use "db.odbc.select" to query discovered database. Therefore we lose a benefit of LLD.
It would be very useful if we can place a connection string like "DRIVER=

{Oracle 12c ODBC Driver}

;Server=

{HOST.CONN}

:

{#PORT}

/

{#SERVICE_NAME}

;UID=user;PWD=pass;" as a parameter "data_source_name" for an item prototype. It would allow us to avoid of using odbc.ini at all.
unixODBC (ver. 2.3.1 and above) lets use a connection string instead of DSN name for isql utility (-k option). It is desired to see similar feature in a future release of Zabbix.

As www.unixodbc.org state, function SQLDriverConnect must be used to allow such functionality.



 Comments   
Comment by Marc [ 2014 May 19 ]

Sounds similar to ZBXNEXT-1961, doesn't it?

Comment by v99glu [ 2014 May 19 ]

Yes, it does. Both requests are about the same subject.
I just was more particular.
Is it possible to merge these requests?

Comment by richlv [ 2014 May 19 ]

let's keep all discussion in ZBXNEXT-1961

Generated at Thu Mar 28 19:56:42 EET 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.