Page 1 of 1

nagiosxi - Database Backend issue

Posted: Wed Mar 01, 2017 12:02 pm
by mlanghorst
Hello,

I used the source install of 5.4.1 on RHEL7. It was working after installation, worked thru a couple minor issues during the 1hr assitance session.

Now on login, I get the message of degraded operation, showing a red ! for Database Backend. Attempting to use the UI to start it, fails.

Mariadb is running, ndo2db is running. Not sure what logs to look at, or what specifically this is indicating.

Re: nagiosxi - Database Backend issue

Posted: Wed Mar 01, 2017 5:22 pm
by mcapra
There were some ndo2db issues fixed in 5.4.2 that might be related to this problem:

Code: Select all

- Fixed ndoutils segfault issue with patch for ndoutils 2.1.2 -JO, JF
- Fixed issue with ndo2db upstart job conflicting with ndo2db init script [TPS#10882] -JO
Can you edit the following file:

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

And change the debug_level to produce more meaningful output:

Code: Select all

debug_level=1
Then restart the ndo2db service and see if the following log file churns out anything interesting after running for a few minutes:

Code: Select all

/usr/local/nagios/var/ndo2db.debug
If it doesn't have anything interesting or is empty after running for several minutes, can you share the output of:

Code: Select all

service ndo2db status 

Re: nagiosxi - Database Backend issue

Posted: Wed Mar 01, 2017 6:03 pm
by mlanghorst
And change the debug_level to produce more meaningful output:

CODE: SELECT ALL
debug_level=1
I'd tried that, and set debug verbosity to 1 as well. But the nd2odb.debug file is empty still.

Service status:
[root@ftapmon19 etc]# systemctl status ndo2db
● ndo2db.service - Nagios Data Out Daemon
Loaded: loaded (/usr/lib/systemd/system/ndo2db.service; enabled; vendor preset: disabled)
Active: active (running) since Wed 2017-03-01 14:33:40 PST; 27min ago
Docs: http://www.nagios.org/documentation
Process: 5975 ExecStopPost=/bin/rm -f /usr/local/nagios/var/ndo2db.pid (code=exited, status=0/SUCCESS)
Main PID: 5980 (ndo2db)
CGroup: /system.slice/ndo2db.service
├─5980 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg -f
├─6046 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg -f
└─6047 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg -f

Mar 01 14:59:45 ftapmon19 ndo2db[6047]: Trimming timedevents.
Mar 01 14:59:45 ftapmon19 ndo2db[6047]: Trimming systemcommands.
Mar 01 14:59:45 ftapmon19 ndo2db[6047]: Trimming servicechecks.
Mar 01 14:59:45 ftapmon19 ndo2db[6047]: Trimming hostchecks.
Mar 01 14:59:45 ftapmon19 ndo2db[6047]: Trimming eventhandlers.
Mar 01 15:00:48 ftapmon19 ndo2db[6047]: Trimming timedevents.
Mar 01 15:00:48 ftapmon19 ndo2db[6047]: Trimming systemcommands.
Mar 01 15:00:48 ftapmon19 ndo2db[6047]: Trimming servicechecks.
Mar 01 15:00:48 ftapmon19 ndo2db[6047]: Trimming hostchecks.
Mar 01 15:00:48 ftapmon19 ndo2db[6047]: Trimming eventhandlers.

Mariadb, ndo2db both seem to be running. What other logs would this be logged to?

Re: nagiosxi - Database Backend issue

Posted: Wed Mar 01, 2017 8:54 pm
by rkennedy
Did you upgrade to the latest? This was solely a graphical issue, and won't affect your actual installation at all. The error should be fixed in the latest version.

Re: nagiosxi - Database Backend issue

Posted: Wed Mar 01, 2017 9:01 pm
by dwhitfield
rkennedy wrote:Did you upgrade to the latest? This was solely a graphical issue, and won't affect your actual installation at all. The error should be fixed in the latest version.
This is correct, assuming you did not see anything other than the red circle. You haven't said there was anything else, but is there?

Re: nagiosxi - Database Backend issue

Posted: Thu Mar 02, 2017 1:07 pm
by mlanghorst
Correct, right now I'm only seeing the Red ! in the status page, and the warning on login about degraded system.

I'll attempt the upgrade to 5.4.2. Thanks for the info, I've been using Core for quite some time, but not sure yet where the components of XI tie together and their relevant logging.

Re: nagiosxi - Database Backend issue

Posted: Thu Mar 02, 2017 4:37 pm
by mcapra
Let us know if you have additional questions regarding this. If nothing particularly malicious shows up in the ndo2db.debug file, I imagine this is simply a cosmetic bug that was fixed in 5.4.2.