Nagios XI system mail alerts get stopped frequently

[mejokj]

Nagios system mail alerts get stopped frequently and we have to manually restart the following services to make it work.

Monitoring Engine
Performance Grapher
Database Backend

I've attached the system profile herewith. Kindly check and update.

Also we found few issues while repairing the database. Please see the issues below. The Nagios XI version is 5.5.2

---------

- recovering (with sort) MyISAM-table 'nagios_timeperiod_timeranges'
Data records: 110
- Fixing index 1
- Fixing index 2
~

===============
REPAIR COMPLETE
===============
DATABASE: nagiosql
TABLE:
/var/lib/mysql/nagiosql ~
No *.MYI files found, skipping nagiosql...
DATABASE: nagiosxi
TABLE:
/var/lib/mysql/nagiosxi ~
No *.MYI files found, skipping nagiosxi...

=======================
nagios database repair succeeded
nagiosql database repair skipped, no *.MYI files found
nagiosxi database repair skipped, no *.MYI files found

[ssax]

Please send me the output of these commands (as root):

Code: Select all

sysctl -p
ulimit -a
su - nagios
ulimit -a

Please send me this file:

Code: Select all

/usr/local/nagiosxi/html/includes/auth.inc.php

Please follow these instructions:

Please go to Admin > Manage Email Settings:
- Make sure Logging is checked
- Click the Update Settings button

Once it fails, please run this command and include the output:
- Additionally, when it's broken, please try to grab a profile before fixing it and attach that

Code: Select all

tail -n50 /var/log/maillog /usr/local/nagiosxi/tmp/phpmailer.log /usr/local/nagiosxi/var/eventman.log

Additionally, please send the output of these commands (as root) so that I can check for some other common issues that could be affecting notifications:
- NOTE: You may need to adjust the -h 127.0.0.1, the -uroot, and -pnagiosxi in the first command if your DB is offloaded to another server and/or you've changed the root mysql password

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table
ls -l /usr/local/nagiosxi/var/
ls -l /usr/local/nagios/var/
ls -l /usr/local/nagios/var/rw

Thank you