netrusov / ZabbixDBA

Zabbix Database Monitoring Service (Oracle, Pg, MySQL, MS SQL, DB2, etc.)
MIT License
95 stars 54 forks source link

No data received by Zabbix #92

Closed vlehemonet closed 4 years ago

vlehemonet commented 4 years ago

Hi,

I'm trying to monitor an oracle database for a Zabbix project.

Everything looks correct but i'm unable to see any data in Zabbix.

I can see in the logs ZDBA fetching data on my DB :

[oracle@localhost log]$ tail -f zdba.log [2020/05/24 10:15:28][INFO ] [53] starting thread for database 'IFCE' [2020/05/24 10:16:51][INFO ] [main::stop:70] stopping ZabbixDBA [2020/05/24 10:17:10][INFO ] [27] starting ZabbixDBA (version 3.2.0) [2020/05/24 10:17:10][INFO ] [53] starting thread for database 'IFCE' [2020/05/24 10:20:37][INFO ] [main::stop:70] stopping ZabbixDBA [2020/05/24 10:20:37][INFO ] [27] starting ZabbixDBA (version 3.2.0) [2020/05/24 10:20:37][INFO ] [53] starting thread for database 'IFCE' [2020/05/24 10:35:01][INFO ] [main::stop:70] stopping ZabbixDBA [2020/05/24 10:35:03][INFO ] [27] starting ZabbixDBA (version 3.2.0) [2020/05/24 10:35:03][INFO ] [53] starting thread for database 'IFCE' ^C [oracle@localhost log]$ tail -f IFCE.log [2020/05/24 10:39:04][INFO ] [ZDBA::monitor:151] completed fetching data on 'IFCE' (elapsed 0.082276) [2020/05/24 10:39:34][INFO ] [ZDBA::monitor:151] completed fetching data on 'IFCE' (elapsed 0.077307) [2020/05/24 10:40:04][INFO ] [ZDBA::monitor:151] completed fetching data on 'IFCE' (elapsed 0.084816) [2020/05/24 10:40:34][INFO ] [ZDBA::monitor:151] completed fetching data on 'IFCE' (elapsed 0.078786) [2020/05/24 10:41:04][INFO ] [ZDBA::monitor:151] completed fetching data on 'IFCE' (elapsed 0.077732) [2020/05/24 10:41:34][INFO ] [ZDBA::monitor:151] completed fetching data on 'IFCE' (elapsed 0.081265) [2020/05/24 10:42:04][INFO ] [ZDBA::monitor:151] completed fetching data on 'IFCE' (elapsed 0.0803) [2020/05/24 10:42:34][INFO ] [ZDBA::monitor:151] completed fetching data on 'IFCE' (elapsed 0.075456) [2020/05/24 10:43:04][INFO ] [ZDBA::monitor:151] completed fetching data on 'IFCE' (elapsed 0.10859) [2020/05/24 10:43:35][INFO ] [ZDBA::monitor:151] completed fetching data on 'IFCE' (elapsed 0.078409)

But if i look in Zabiix's latest data I can't see anythings.

zdba

From Zabbix's logs itself I have no errors.

Do you have any hints to troubleshoot this situation ?

Thanks,

vlehemonet commented 4 years ago

Problem solved. I make a mistake in the hostname... Sorry for that.

netrusov commented 4 years ago

yes, looks like that it was hostname issue