Page 1 of 3
Host State report empty
Posted: Thu Oct 07, 2021 4:00 am
by 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
Re: Host State report empty
Posted: Thu Oct 07, 2021 4:40 pm
by 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
Re: Host State report empty
Posted: Thu Oct 07, 2021 10:05 pm
by sacom01
sent you!
pls check ib.
thank you.
Re: Host State report empty
Posted: Fri Oct 08, 2021 2:15 pm
by 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:
Re: Host State report empty
Posted: Sun Oct 10, 2021 9:43 pm
by sacom01
i will try upgrade new version for nagios xi.
sent file to your ib.
thank you.
Re: Host State report empty
Posted: Mon Oct 11, 2021 5:45 pm
by 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.
Re: Host State report empty
Posted: Thu Oct 21, 2021 3:12 am
by 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
Re: Host State report empty
Posted: Thu Oct 21, 2021 2:25 pm
by 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.
Re: Host State report empty
Posted: Thu Oct 21, 2021 8:21 pm
by sacom01
no check in box "Use patched jQuery 1.x to render PDF/JPG reports" but issue still happen bro.
Re: Host State report empty
Posted: Fri Oct 22, 2021 3:25 pm
by 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