Page 1 of 1

Scheduled downtime duration

Posted: Thu Oct 11, 2018 2:36 am
by atsb
Hello!

About nagios XI environment
1) Linux Distribution and version? Centos7
2) 32 or 64bit? 64bit
3) VMware Image or Manual Install of XI? Manual install
4) Are there special configurations on your system, ie; is Gnome installed? Are you using a proxy? Are you using SSL? SSL
5) NagiosXI version: 5.5.4

I have noticed a bug in scheduled downtime duration, it shows duration 9h 6m 7s when it should be 24hours. Example:
nagios-scheduled-downtime.png
I hope that this is only visual bug.

Thanks!

Re: Scheduled downtime duration

Posted: Thu Oct 11, 2018 8:12 am
by scottwilkerson
We have seen this a couple times, would it be possible for you to run the following and post the output (obfuscate sensitive info)

Code: Select all

http://YOUR_HOST/nagiosxi/includes/components/xicore/downtime.php?cmd=getdowntimes
I'm most interested in seeing the start time stop time and duration returned

Thanks!

Re: Scheduled downtime duration

Posted: Thu Oct 11, 2018 8:32 am
by scottwilkerson
looking into this further is is a bug in ndo2db, which can be resolved by running the following

Code: Select all

echo "ALTER TABLE nagios_scheduleddowntime MODIFY COLUMN duration int(11);"|mysql -pnagiosxi nagios
This will not fix the column for previously scheduled downtimes, but will fix them in the future.

This is just a display bug.

Re: Scheduled downtime duration

Posted: Fri Oct 12, 2018 1:15 am
by atsb
I tested and your suggestion works.

Thanks!

Re: Scheduled downtime duration

Posted: Fri Oct 12, 2018 7:41 am
by scottwilkerson
atsb wrote:I tested and your suggestion works.

Thanks!
great! Locking thread