Scheduled downtime duration

[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!

[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!

[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.

[atsb]

I tested and your suggestion works.

Thanks!

[scottwilkerson]

I tested and your suggestion works.

Thanks!

great! Locking thread