Nagios Support Forum

Finally, now I have two solutions to check blocking sessions in Oracle database. SQL query: SELECT s1.username || '@' || s1.machine || ' ( SID=' || s1.sid || ' ) is blocking ' || s2.username || '@' || s2.machine || ' ( SID=' || s2.sid || ' ) ' AS blocking_status FROM v$lock l1, v$session s1, v$lock ...

Can you run the command from the CLI the same way you do in Nagios with this at the beginning /usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/admin Then, also, if that works, I would add the fol...

Hi everyone! Problem: Nagios web-gui don't see plugin output from sqlplus, but everything works fine in command line. I try to use plugin check_sql_query ( https://exchange.nagios.org/directory/Plugins/Databases/Oracle/check_sql_query/details ) to check blocking SQL sessions in my Oracle 11gR2 datab...

So there are no options to hide nonessesary hosts from statusmap?

Thank you very much, ssax!
It works on 4.0.8 too. =)

You may close the thread.

Hello. I trying to display onhover popup with Service Notes in the same way as Host Address displayed when you point mouse on a HostName: http://s017.radikal.ru/i408/1609/ba/e6686fd8db3f.jpg I've found in status.c where it coded and can to display there Service Description popup (for test): /* servi...

Lets make the request (export to csv for given hostgroup/servicegroup and All hostgroups/servicegroups) and close the thread.
Thank you.

Close it, of course.
Thanks!

Clearly. Feature request it's long. Easier way is to parse html. Just Grab needed service-group report and parse it: /nagios/cgi-bin/avail.cgi?show_log_entries=&servicegroup=my-service-group&timeperiod=last7days&smon=9&sday=1&syear=2016&shour=0&smin=0&ssec=0&emon=...

I glad to hear you, lmiltchev . I agree with you. I only confused how "encoding = utf8" changes behavior plugin output? When utf8 is enabled, then input russian chars processed well by the script, but output is broken. Wnen utf8 is disabled, then input russian chars not recognized properly...