Op Screen: Hosts up 48/49

[cellact]

Hi,
I'm having a weird little issue.
All my hosts are up (Host Status Summary = 49 Up) but the Op Screen insists that one of them is Down and shows 48/49 Up.

Any ideas?

Thanks.

[lmiltchev]

Usually it takes some time before the tactical overview section is updated (Unhandled Hosts down section gets updated first).
Did you try refreshing the page? Did you try using a different browser? What does "Tactical Overview" menu show?

[cellact]

I did try refreshing, logging out and in and from different browers. it comes up the same.

Tactical Overview and Operations Center both show 100% Up.

[scottwilkerson]

Can you run the following from the command line and see if it comes back with a result

Code: Select all

echo "SELECT count(*) as total from nagios_hoststatus WHERE last_hard_state='1';" |  mysql -pnagiosxi nagios

[cellact]

Sure,

Code: Select all

# echo "SELECT count(*) as total from nagios_hoststatus WHERE last_hard_state='1';" |  mysql -pnagiosxi nagios
total
1

I think the last host I changed status to was done via 'submit passive check result'. maybe that helps.

Weird stuff - I just submitted a down state and then again an up state and now it shows 47/49 hosts up!
What's happening?

Thanks

[scottwilkerson]

In XI can you go to Home -> All Host Problems and see if there are any there

The Opscreen only show unhandled hosts in the host view, but lists the total in the Tactical overview

[scottwilkerson]

I am not 100% sure if this is related to your problem but we did find a bug in the code which should display things more accurately.

You can download the new component at
http://assets.nagios.com/downloads/nagi ... screen.zip

Just re-install through Admin -> Manage Components

[cellact]

Hi,
Thanks a lot - that helped me find the wrong line (94) in merlin.php

Code: Select all

$query="SELECT count(*) as total from nagios_hoststatus WHERE last_hard_state='1'";

Should be:

Code: Select all

$query="SELECT count(*) as total from nagios_hoststatus WHERE current_state!=0";

And the same for line 140 (Services)

Cheers!

[scottwilkerson]

That's correct, that was the changes.