DB monitoring cant see received value in the GUI

[nodo2003]

Hello,

Ive faced to the following issue, cant see received value in the GUI
currently we are monitor many DBs , but problem with one only

no errors in the log file, item is supported

tried to connect via isql, everything is OK

SQL> select to_char(sysdate,'HH24:MI:SS') from dual;
+------------------------------+
| TO_CHAR(SYSDATE,'HH24:MI:SS')|
+------------------------------+
| 12:11:52                     |
+------------------------------+
SQLRowCount returns -1
1 rows fetched

After that, for interest I had added another DB. It's ok (an - it worked)

Also, in the tcpdump everything is good, we are receiving values from DB without problem

CentOS release 6.6 (Final)
Zabbix 2.4.6
unixODBC 2.2.14

Please suggest what can I check and where

Thank you in advance.

[batchenr]

Hello,

Ive faced to the following issue, cant see received value in the GUI
currently we are monitor many DBs , but problem with one only

no errors in the log file, item is supported

tried to connect via isql, everything is OK

SQL> select to_char(sysdate,'HH24:MI:SS') from dual;
+------------------------------+
| TO_CHAR(SYSDATE,'HH24:MI:SS')|
+------------------------------+
| 12:11:52                     |
+------------------------------+
SQLRowCount returns -1
1 rows fetched

After that, for interest I had added another DB. It's ok (an - it worked)

Also, in the tcpdump everything is good, we are receiving values from DB without problem

CentOS release 6.6 (Final)
Zabbix 2.4.6
unixODBC 2.2.14

Please suggest what can I check and where

Thank you in advance.

you mean that in the latest data when you choose the hostname of this DB server you dont see anything ?

can you post a screenshot ?

[nodo2003]

Hi,

you mean that in the latest data when you choose the hostname of this DB server you dont see anything ?

yes, I dont see nothing

can you post a screenshot ?

screenshot of what? item config?

[batchenr]

Hi,


yes, I dont see nothing


screenshot of what? item config?

of latest data page

[nodo2003]

of latest data page

anything else?

[nodo2003]

Any ideas?

[batchenr]

Any ideas?

do you have some info on /var/log/agent log and server log ?

[nodo2003]

hi,

there is nothing important for now.
today Ive reconfigured item with mistakes, after that reconfigure correctly in the log I saw only this

2578:20170215:160632.068 item "PS:db.odbc.select[PS_XXX,MYDB]" became supported

item is in normal state again but no value shown

[batchenr]

hi,

there is nothing important for now.
today Ive reconfigured item with mistakes, after that reconfigure correctly in the log I saw only this

2578:20170215:160632.068 item "PS:db.odbc.select[PS_XXX,MYDB]" became supported

item is in normal state again but no value shown

that means that the item wasnt supported. now wait a few minutes it will get some data.

[nodo2003]

yes I know,I changed it intentionally, it was the reason why I changed item configuration to get incorrect info and after that change to correct
but there is no value shown.

today I`ll run tcpdump one more time, and will provide trace to show you that Im receiving values from DB

[nodo2003]

sorry for my late response, screens of tcpdump attached.
as you can see everything correct, no delay or any other issue, but received value still not shown in zabbix GUI

[nodo2003]

Dear all,

No idea ?