Nagios alerts when host has SERVICE DOWNTIME?

[Sagar Bhutani]

Hi,
While scheduling the downtime for multiple devices (Or One device) from Incident Management > Schedule Downtime page, I am not able to see the list of schedule downtimes. I even refreshed multiple times, still it is not visible? Any specific reason for that, please suggest?

Regards,
Sagar

[vtrac]

Hi,
How are you doing?

Can you please run the below command after you have scheduled a downtime on your Nagios XI?

Code: Select all

mysql -uroot -pnagiosxi nagios --table <<< "select * from nagios_scheduleddowntime;"

You should see something like this:
[root@vt-nagiosxi-62 ~]# mysql -uroot -pnagiosxi nagios --table <<< "select * from nagios_scheduleddowntime;"

Code: Select all

+----------------------+-------------+---------------+-----------+---------------------+--------------+-----------------------------+----------------------+-----------------+----------+----------+----------------------+---------------------+-------------+---------------------+------------------------+
| scheduleddowntime_id | instance_id | downtime_type | object_id | entry_time          | author_name  | comment_data                | internal_downtime_id | triggered_by_id | is_fixed | duration | scheduled_start_time | scheduled_end_time  | was_started | actual_start_time   | actual_start_time_usec |
+----------------------+-------------+---------------+-----------+---------------------+--------------+-----------------------------+----------------------+-----------------+----------+----------+----------------------+---------------------+-------------+---------------------+------------------------+
|                    1 |           1 |             2 |       185 | 2021-05-17 13:17:58 | Nagios Admin | Test1 Monday Host down time |                   18 |               0 |        1 |     3600 | 2021-05-17 15:00:00  | 2021-05-17 16:00:00 |           0 | 1970-01-01 00:00:01 |                      0 |
+----------------------+-------------+---------------+-----------+---------------------+--------------+-----------------------------+----------------------+-----------------+----------+----------+----------------------+---------------------+-------------+---------------------+------------------------+

Please check database log "/var/log/mariadb/mariadb.log" and see if it is crashed.

If so, please run the below command to fix the DB:

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh

Best Regards,
Vinh