Host State report empty

[sacom01]

hi,
i have 60 hosts-client in Nagios xi, some of it show empty report in Host State thought services work fine. This issue random for aix or redhat.
some of it have data but very few data.
how to check this?
thank you

[ssax]

Please PM me a copy of your profile.zip, you can download it from Admin > System Profile by clicking the Download Profile button.

Additionally, please send the output of this command:
- NOTE: You may need to adjust the -h 127.0.0.1, the -uroot, and -pnagiosxi in the command if your DB is offloaded to another server and/or you've changed the root mysql password

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table

One thing to note is that the State History report doesn't log every check, only State Changes, this is done to reduce disk usage, you can enable State Stalking on the hosts/services to have it log more:

https://assets.nagios.com/downloads/nag ... lking.html

[sacom01]

sent you!
pls check ib.
thank you.

[ssax]

I would upgrade from XI 5.8.1 to the latest (5.8.6) as early XI 5.8 had a few bugs related to DB communication and I think that is what is going on here if you don't have any crashed DB tables:

https://www.nagios.com/downloads/nagios-xi/change-log/
https://assets.nagios.com/downloads/nag ... ctions.pdf

What is the output of this command?

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table

Please PM me this file:

Code: Select all

/usr/local/nagios/var/status.dat

[sacom01]

i will try upgrade new version for nagios xi.
sent file to your ib.
thank you.

[ssax]

That info looks good. You can either upgrade to the latest or you can technically downgrade your NDO3 back to NDO2DB and see if that resolves it but I would just upgrade to the latest if you're able as you want to be on NDO3 eventually.

[sacom01]

after upgraded nagios xi from 5.8.1 to 5.8.6, host state report is work fine.
But capacity planning not show data for any host, it's empty.
how to fix this?
thank you

[ssax]

Please go to Admin > Performance Settings > JPEG/PDF Exporting and either check or uncheck the box on that page (whatever is the opposite of what you currently have) and see if that resolves it.

[sacom01]

no check in box "Use patched jQuery 1.x to render PDF/JPG reports" but issue still happen bro.

[ssax]

See any errors in the F12 console tab in firefox when you replicate it?

Any errors in the apache log output if you leave this running while you replicate it?

Code: Select all

tail -Fn0 /var/log/httpd/*error_log