Host missing from Host Status

[CameronWP]

Hi:

I updated our Nagios instance to 5.5.2 last night and it all seemed to go OK. Today I attempted to add a new server for monitoring and applying the configuration worked as expected. The problem is that it isn't appearing in the program anywhere except in the configuration area. I have attached some screenshots to demonstrate the issue.

[npolovenko]

Hi, @CameronWP. Sounds like you may have a database corruption. Please run the following script to repair the broken tables:

/usr/local/nagiosxi/scripts/repair_databases.sh

If this doesn't work let's restart all the key processes:

service nagios stop
service ndo2db stop
service mysqld stop
service crond stop
service httpd stop
killall -9 nagios
killall -9 ndo2db
rm -f /usr/local/nagios/var/rw/nagios.cmd
rm -f /usr/local/nagios/var/nagios.lock
rm -f /usr/local/nagios/var/ndo.sock
rm -f /usr/local/nagios/var/ndo2db.lock
rm -f /usr/local/nagiosxi/var/reconfigure_nagios.lock
for i in `ipcs -q | grep nagios |awk '{print $2}'`; do ipcrm -q $i; done
service mysqld start
service ndo2db start
service nagios start
service httpd start
service crond start

Let me know if this fixes your issue.

[CameronWP]

Thanks for the response. Interestingly, your set of steps resolved my other issue where I couldn't set downtimes but it hasn't resolved my ability to add a new host. I removed the old one completely and re-added it after performing the recommended steps and it still isn't appearing. Thanks!

[npolovenko]

@CameronWP , Glad we fixed the other issue Looks like I'd need to see your System Profile.
To send us your system profile. Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and upload it to a cloud storage of your choice. You can share a link with me in a personal message.
After you upload the profile please post something in this thread to bring it up in the support queue.

[CameronWP]

Hi:

I have attached it here. Thanks!

[npolovenko]

@CameronWP , Thank you. Are you able to see this new host in the CCM? Please open a console session to the Nagios server, then sign in as the nagios user and run the following command:

su - nagios
/usr/local/nagiosxi/scripts/reconfigure_nagios.sh

And show me the output.

[CameronWP]

Checked 397 hosts.
Checked 38 host groups.
Checked 0 service groups.
Checked 28 contacts.
Checked 8 contact groups.
Checked 366 commands.
Checked 34 time periods.
Checked 0 host escalations.
Checked 0 service escalations.
Checking for circular paths...
Checked 397 hosts
Checked 0 service dependencies
Checked 0 host dependencies
Checked 34 timeperiods
Checking global event handlers...
Checking obsessive compulsive processor commands...
Checking misc settings...

Total Warnings: 231
Total Errors: 0

Things look okay - No serious problems were detected during the pre-flight check
> Return Code: 0
--------------------------------------

The warnings are related to some printer hosts we don't want to be notified about. Otherwise it appears as it should. FYI, our ability to set downtimes has stopped working again overnight. Thanks for your help!

[scottwilkerson]

I see the host OSC-TCBORD01 as part of the configuration, can you click the magnifying glass upper right and enter that to see if it shows up

[CameronWP]

I know this is bizarre but although it appears in the configuration listing and in CCM it isn't appearing in the interface.

It should be in between these two servers:

Missing1.JPG

Also, this count should 397 not 396 as shown:

Missing2.JPG

Here is the result of a search:

Missing3.JPG

[scottwilkerson]

Wow that is weird. Lets do the following:

CCM -> Tools -> Config File Management
Delete Files
Write Configs

Then re-create the missing host
Apply configuration