Notification SQL error ndoutils

[nagios-retail]

Hello,

We are getting the following error within the Notification screen:

SQL Error [ndoutils] : Incorrect file format 'nagios_contactnotificationmethods'

Nagios is version 5.8.7
CentOS Linux 7.9.2009

[tgriep]

The MYSQL table is corrupted and needs to be repaired.

Run these commands to stop the processes, clean and repair the SQL database and to restart the processes. Run them all as root in a ssh session on the Nagios server.

Code: Select all

systemctl stop npcd
systemctl stop nagios
systemctl stop crond
pkill -9 -u nagios
echo "truncate table xi_events; truncate table xi_meta; truncate table xi_eventqueue;" | mysql -u root -pnagiosxi nagiosxi
mysqlcheck -f -r -u root -pnagiosxi --all-databases --use-frm
systemctl restart mariadb
rm -f /usr/local/nagios/var/rw/nagios.cmd
rm -f /usr/local/nagios/var/nagios.lock
rm -f /var/run/nagios.lock
rm -f /usr/local/nagios/var/ndo.sock
rm -f /usr/local/nagios/var/ndo2db.lock
rm -f /var/lib/mrtg/mrtg_l
rm -f /usr/local/nagiosxi/var/*.lock
rm -f /usr/local/nagiosxi/tmp/*.lock
for i in `ipcs -q | grep nagios |awk '{print $2}'`; do ipcrm -q $i; done
pkill python
systemctl restart httpd
systemctl start nagios
systemctl start npcd
systemctl start crond

Then see if the message is gone in the XI interface.

Thank you.

[benjaminsmith]

Hi,

Let's go ahead and run a repair on the database as a first step and let me know if that resolves the issue. Please log in to the CLI and run the following command as root.

Code: Select all

mysqlcheck -r -f -u root -pnagiosxi --use_frm --all-databases

If that does not take care of it, let's get a fresh system profile to review. Thanks, Benjamin
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

[nagios-retail]

Hello,

Notifications are back up after running the commands from the first post.
Had to preform this on 2 Nagios servers.

Thx for the help.

[benjaminsmith]

Hi,

That's good to hear and appreciate the follow-up.

We'll go ahead and close this out, but feel free to open another if you have any new questions.

--Benjamin