Bug in opscreen
Posted: Wed Nov 12, 2014 11:37 am
http://exchange.nagios.org/directory/Ad ... nt/details
I was updating all my components and wizards yesterday, and ran in to a surprise in the opsceen. A bug in the code is preventing any Unhandled service problems from showing up in the list (eek)!
I use this as my main screen, so it caught my eye when I was restarting a server this morning and I didn't see the down services pop up on my opscreen.
Upon digging in to it, I found a bug on line 262 of merlin.php in this bit of the sql query:

I was updating all my components and wizards yesterday, and ran in to a surprise in the opsceen. A bug in the code is preventing any Unhandled service problems from showing up in the list (eek)!
I use this as my main screen, so it caught my eye when I was restarting a server this morning and I didn't see the down services pop up on my opscreen.
Upon digging in to it, I found a bug on line 262 of merlin.php in this bit of the sql query:
Should be:WHERE nagios_servicestatus.scheduled_downtime_depth='0' nagios_servicestatus.problem_has_been_acknowledged='0' AND nagios_servicestatus.current_state!='0' AND nagios_hoststatus.problem_has_been_acknowledged='0' AND nagios_hoststatus.last_hard_state='0' AND nagios_hoststatus.current_state='0'
Once the query is fixed, the opscreen returns to operating like it should. Might want to update that file on the site guysWHERE nagios_servicestatus.scheduled_downtime_depth='0' AND nagios_servicestatus.problem_has_been_acknowledged='0' AND nagios_servicestatus.current_state!='0' AND nagios_hoststatus.problem_has_been_acknowledged='0' AND nagios_hoststatus.last_hard_state='0' AND nagios_hoststatus.current_state='0'