Nagios Support Forum

A series of steps have led me to the solution. Root Cause I am thinking was package/upgrade process issue. Saying that, I took the below action to resolve the issue. The final step and most difficult to solve, was a couple missing maridb columns missing in the service and host status tables.

1) Reinstall ndo component (NDO-3)
2) Verify broker_module is properly configured located in /usr/local/nagios/etc/nagios.cfg
3) Verify the check tables are present when NDO-3 error is present and last_checked date/time is not updating
"[1624345100] NDO-3: Unable to prepare statement for query (27): Unknown column 'check_options' in 'field list'"

Please do this:
- NOTE: You may need to adjust the -h 127.0.0.1, the -uroot, and -pnagiosxi in the command if your DB is contained/stored on another server and/or you've changed the root mysql password

CODE: SELECT ALL
mysql -h 127.0.0.1 -uroot -pnagiosxi nagios -e "ALTER TABLE nagios_hoststatus ADD check_options smallint(6) NOT NULL default '0' AFTER check_type;"
mysql -h 127.0.0.1 -uroot -pnagiosxi nagios -e "ALTER TABLE nagios_servicestatus ADD check_options smallint(6) NOT NULL default '0' AFTER check_type;"
systemctl restart nagios


https://support.nagios.com/forum/viewtopic.php?f=16&t=62834&start=10

Hi Bwick05,

We're glad it is working.

Thanks for sharing your solution!

I am closing this thread, feel free to start another if something
else comes up.