No update nagiosxi, monitoring engine not running

[hdurans]

Hi,

I need your help,

today the nagios xi don't refresh de monitoring engine status, when I see in nagioscore it's running and update the lastcheck in all services, but don't update information over nagiosxi all services are frozen.

I repair the databases and in this moment don't show errors.


please, need your help to solve this problem quicky.


Thanks

[benjaminsmith]

Hi @hdurans,

Did you start noticing this behavior after upgrading? If so, let's go ahead and downgrade the backend database service to the previous version. For a standard installation with a local database, the steps are as follows.

Take a backup before making any changes.

Code: Select all

systemctl stop nagios
cd /tmp
rm -rf /tmp/nagiosxi
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.6.14.tar.gz
tar zxf xi-5.6.14.tar.gz
cd /tmp/nagiosxi/subcomponents/ndoutils
./install
systemctl enable ndo2db

Then edit your /usr/local/nagios/etc/nagios.cfg and make sure this line is uncommented:

Code: Select all

broker_module=/usr/local/nagios/bin/ndomod.o config_file=/usr/local/nagios/etc/ndomod.cfg

Make sure this line is commented:

Code: Select all

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

Then start the nagios service:

Code: Select all

systemctl start nagios

If the database has been offloaded, let me know and I can provide those steps. If this does not resolve the issue, please send me the system profile to further troubleshoot. 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

[hdurans]

Hi,

thanks for your help Benjamin

I'm using ndo2db and the database is offloaded

I send profile to MP

[benjaminsmith]

Hi,

Thanks for the profile. There are some PHP errors related to processing passive checks but I don't think that is causing the issue with the check results. The monitoring engine was running when you downloaded the profile.

Please try running a full restart and let me know if you notice any improvement.

Code: Select all

systemctl stop crond
systemctl stop npcd
systemctl stop nagios
systemctl stop ndo2db
pkill -9 -u nagios
for i in $(ipcs -q | grep nagios |awk '{print $2}'); do ipcrm -q $i; done
rm -rf /usr/local/nagiosxi/var/dbmaint.lock
rm -rf /usr/local/nagiosxi/var/event_handler.lock
rm -rf /usr/local/nagiosxi/scripts/reconfigure_nagios.lock
systemctl start ndo2db
systemctl start nagios
systemctl start npcd
systemctl start crond

Also, the nagios log was not included in the profile for some reason. Please attach it to the ticket.

Code: Select all

/usr/local/nagios/var/nagios.log

Even though the database seems ok, it would helpful to review that log as well.

Best Regards,
Benjamin

[hdurans]

Hi,

I executed all steps but don´t fix the issue.

add nagios.log

thanks

[tgriep]

Lets enable debugging for the ndo2db daemon so we can check it for errors.

Edit the /usr/local/nagios/etc/ndo2db.cfg file and change the following from

Code: Select all

debug_level=0

to

Code: Select all

debug_level=2

Save the change and run this as root to restart the processes.

Code: Select all

systemctl stop nagios
systemctl restart ndo2db
systemctl start nagios

If the status is not updating after 10 minutes, get this file and post it here.

Code: Select all

/usr/local/nagios/var/ndo2db.debug

You are running a remote MYSQL database so a root shell on the MYSQL server and run the following commands.
Replace <password> with the MYSQL root password.

Code: Select all

Get the /tmp/info.txt file and upload it to the ticket.
mysql -u root -p<password> -e "show global status like '%used_connections%'; show variables like 'max_connections';" >/tmp/info.txt
echo "SELECT table_schema as 'Database', table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC;" |mysql -t -u root -p<password>  >>/tmp/info.txt

What OS and release is the remote MYSQL server running?

[hdurans]

Hi,

Thanks for your help,

I found the issue it was someone or something to change configurations of ndo2db.

now the Nagios is working fine.


Thanks again.

[scottwilkerson]

Hi,

Thanks for your help,

I found the issue it was someone or something to change configurations of ndo2db.

now the Nagios is working fine.


Thanks again.

Great!

Locking thread