[ZBX-11480] ODBC item unsupported after upgrading to 3.2 Created: 2016 Nov 14 Updated: 2017 May 30 Resolved: 2016 Nov 14 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Proxy (P), Server (S) |
| Affects Version/s: | 3.2.0, 3.2.1 |
| Fix Version/s: | None |
| Type: | Incident report | Priority: | Major |
| Reporter: | Cristian Mammoli | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Server: Centos 7 |
||
| Issue Links: |
|
||||||||
| Description |
|
I had an ODBC discovery configured this way: db.odbc.discovery[{$BAREOS_DBDSN}.discovery,{$BAREOS_DBDSN}]
Query: select name as client,clientid from client;
Discovered items: db.odbc.select[{$BAREOS_DBDSN}.{#CLIENT}.jobstatus,{$BAREOS_DBDSN}]
Query: select jobstatus from job where clientid={#CLIENTID} and type='B' order by endtime desc limit 1;
After upgrading to 3.2.0 all the discovered items went unsupported with the following error: Cannot execute ODBC query:[SQL_ERROR]:[07002][32][The # of binded parameters < the # of parameter markers]| odbc.ini is configured this way: [bareos-srvbkp] Description = PostgreSQL connection to XXXXXXX Driver = PostgreSQL Database = bareos Servername = 10.254.99.100 UserName = bareos Password = XXXXXXX Port = 5432 #Protocol = 9.3 ReadOnly = No RowVersioning = No ShowSystemTables = No ConnSettings = |
| Comments |
| Comment by Glebs Ivanovskis (Inactive) [ 2016 Nov 14 ] |
|
Closing as duplicate of |