Not receiving Nagios XI Alert Notifications

[Branigan]

Hi Team,

Kindly require assistance with the below.

Not receiving Nagios XI Alert Notifications, last Notification had been received on the 9th of Jan 2020 at 16:11
Nothing that I am aware of has changed on the system.

Should I attempt to "Test Email Notification" I receive a successful response.
However Warning or Critical Alerts are not received.
This is not being blocked either. Unsure at this point what the cause of this issue might be.
Nagios XI is licensed and has been upgraded to Version 5.6.9

[mbellerue]

Hi @Branigan, welcome to the forum!

Can you PM your system profile over to me? You can get it from Admin -> System Profile -> Download Profile

I will take a look at it and see if I can find out why you're not getting notifications.

[lmiltchev]

Can you PM me your latest profile?

Admin > System Config > System Profile > Download Profile, save, and PM me the profile.zip file.

[Branigan]

Hi @Branigan, welcome to the forum!

Can you PM your system profile over to me? You can get it from Admin -> System Profile -> Download Profile

I will take a look at it and see if I can find out why you're not getting notifications.

------------------------------------------------------------------------------------------------------------

Hi There, Thank you.

I will PM that to you now.

Regards
Branigan.

[Branigan]

Can you PM me your latest profile?

Admin > System Config > System Profile > Download Profile, save, and PM me the profile.zip file.

---------------------------------------------------------------------------------------------------------------------------------------------------

Hi lmiltchev,

Thank you, will PM to you now as well.

Regards
Branigan.

[lmiltchev]

I believe, the issues is caused by the xi_eventqueue db table being crashed. You have many entries in the mysql log as the one below:

200115 8:55:01 [ERROR] /usr/libexec/mysqld: Table './nagiosxi/xi_eventqueue' is marked as crashed and should be repaired

Please run the repair on the database:

Code: Select all

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

to see if this is going to fix the problem. Read more on the issue here:

https://support.nagios.com/kb/article/n ... es-24.html
and here:
https://assets.nagios.com/downloads/nag ... tabase.pdf

FYI, one of the users, listed in the PDF file (mvnx.monitor) has an invalid email... at least I believe it is invalid... Please check it out to make sure it is not a mistake.

[Branigan]

I believe, the issues is caused by the xi_eventqueue db table being crashed. You have many entries in the mysql log as the one below:

200115 8:55:01 [ERROR] /usr/libexec/mysqld: Table './nagiosxi/xi_eventqueue' is marked as crashed and should be repaired

Please run the repair on the database:

Code: Select all

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

to see if this is going to fix the problem. Read more on the issue here:

https://support.nagios.com/kb/article/n ... es-24.html
and here:
https://assets.nagios.com/downloads/nag ... tabase.pdf

FYI, one of the users, listed in the PDF file (mvnx.monitor) has an invalid email... at least I believe it is invalid... Please check it out to make sure it is not a mistake.

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Thank you kindly for the assistance @lmiltchev, Issue resolved.
I had initially only run the "/usr/local/nagiosxi/scripts/repairmysql.sh nagios" command.

Our site did experience a Power Outage prior to this issue so it makes sense.

The mvnx.monitor account was added for testing purposes. Intentionally did not add a valid email address.

[scottwilkerson]

Great!

Locking thread