Receiving SQL error

[jfoshier]

I am receiving SQL Error [ndoutils] : Tabe './nagios_hoststatus is marked as crashed and last (automatic?) repair failed.

We are running nagiosxi 5.4.3. I ran a repair as we had a message to perform a repair. I have rebooted the appliance as well and at this time we are not seeing any host etc in Nagiosxi.

[tgriep]

Lets try this process to stop the daemons, repair the MYSQL database and then restart the daemons to see if that fixes the issue for you.
Login to the server as root and run the following.

Code: Select all

service nagios stop
service ndo2db stop
for i in `ipcs -q | grep nagios |awk '{print $2}'`; do ipcrm -q $i; done
mysqlcheck -f -r -u root -pnagiosxi --all-databases
service mysqld restart
service ndo2db start
service nagios start

If after you login to the XI GUI, you do not see any hosts, etc... run the following and post the output.

Code: Select all

chage -l nagios
df -h
df -i
ps -ef --cols=300
/usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg

Thanks.