Nagios Support Forum

both the UI and the backend API are not displaying the proper count of host/services.

CORE/vshell/ops screen report the correct count of host/services.

I did repair the database, and no meesages are in the mysqld.log file. I just shut it down and repaired it again to be sure. no change.

So a couple of notes on what you sent. ndoutils debugging information will get sent to /usr/local/nagios/var/ndo2db.debug

However, I'm suspicious that the problem will somehow show up in in either /usr/local/nagios/var/nagios.log, or in /var/log/messages/

I would suggest a running tail on both of those files while Applying Configuration in Nagios XI.

(on another shell)

Ok - you were 100% to suspect ndoutils - I did as you asked thinking there would be no difference and after the last publish, it all came back. Problem worked around.

The errors I saw in the /var/log/messages were:

Jun 5 19:43:19 mine ndo2db: Error: mysql_query() failed for 'UPDATE nagios_conninfo SET disconnect_time=NOW(), last_checkin_time=NOW(), data_end_time=FROM_UNIXTIME(0), bytes_processed='0', lines_processed='0', entries_processed='0' WHERE conninfo_id='0''
Jun 5 19:43:19 mine ndo2db: mysql_error: 'MySQL server has gone away'
Jun 5 19:43:19 mine ndo2db: Error: Connection to MySQL database has been lost!

xi UI and the backend.cgi are all fixed and better now. Thank you!
b

Good deal, glad it's working for you!