-
Incident report
-
Resolution: Duplicate
-
Trivial
-
None
-
3.2.3
-
None
-
RHEL6 - 2.6.32-642.13.1.el6.x86_64 with RHSCL repo.
PostgreSQL 9.4.9
After upgrade zabbix from version 2.4.7 to 3.2.3 ODBC dircovering doesn't works.
In frontend view discoveru rule makes unsupported
In zabbix server log i can see
17476:20170131:184454.041 odbc_DBfetch() fetched [0 col (-10)]: '{'
From isql CLI all worksas expected
+---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> select '{"data":[', (SELECT STUFF((SELECT ',' + '{"{#DBNAME}":"' + [Name] + '"}' FROM master..sysdatabases ORDER BY [Name] FOR XML PATH('')), 1, 1, '')) ,']}' FOR XML PATH('') +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | XML_F52E2B61-18A1-11d1-B105-00805F49916B | +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | {"data":[{"{#DBNAME}":"confluence_it"},{"{#DBNAME}":"icap_it"},{"{#DBNAME}":"jira_it"},{"{#DBNAME}":"master"},{"{#DBNAME}":"model"},{"{#DBNAME}":"msdb"},{"{#DBNAME}":"tempdb"}]} | +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ SQLRowCount returns 1 1 rows fetched
my /etc/odbc.ini
[CBR4T] Driver = FreeTDS Server = fsrumosdt0031 PORT = 1442 TDS_Version = 8.0
my locale
locale LANG=en_US.UTF-8 LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=
sorry for english mistakes and thanks in advance
- duplicates
-
-
- Closed
-