xi last check not updating

infofedsec · Post by **infofedsec** » Mon Aug 16, 2021 4:08 pm

My X I last check, plus the status information are not updating. Its correct in core and i've run the suggested actions from https://support.nagios.com/kb/article.php?id=19 . attached is my system profile

Moderator's Note: The profile has been shared with the support team but has been removed from the public forum.

ssax · Post by **ssax** » Tue Aug 17, 2021 10:29 am

I am seeing this:

Code: Select all

    <p><pre>SQL Error [nagiosxi] : MySQL server has gone away</pre></p>

Edit your /etc/my.cnf and make sure these (or higher) are set under the [mysqld] section:

Code: Select all

max_allowed_packet=512M
max_connections=800

Then, to the main issue, edit this file:

Code: Select all

/usr/local/nagios/etc/nagios.cfg

Uncomment this line:

Code: Select all

#broker_module=/usr/local/nagios/bin/ndo.so /usr/local/nagios/etc/ndo.cfg

So it looks like this:

Code: Select all

broker_module=/usr/local/nagios/bin/ndo.so /usr/local/nagios/etc/ndo.cfg

Then restart these services:

Code: Select all

systemctl restart mariadb nagios httpd crond

Then apply configuration and validate.

Additionally, please send the output of this command:
- NOTE: You may need to adjust the -h 127.0.0.1, the -uroot, and -pnagiosxi in the 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

Nagios Support Forum

xi last check not updating

xi last check not updating

Re: xi last check not updating