Nagios XI version: 5.6.12
Hi,
We are finding that comments entered for Scheduled Downtime for Hosts and Services are not visible in the XI GUI, they are only visible if the Host/Service is viewed thru Nagios Core.
Is there some configuration setting that controls this, which we can change to make the Comment appear in the XI GUI?
Thanks.
Otto
Scheduled Downtime Comment only visible thru Core
Re: Scheduled Downtime Comment only visible thru Core
Please send me a copy of your profile, you can download it from Admin > System Profile > Download Profile button.
Additionally, please send the output of these commands (as root):
- NOTE: You may need to adjust the -h 127.0.0.1, the -uroot, and -pnagiosxi in the command if your DB is offloaded to another server and/or you've changed the root mysql password
Once you've grabbed the info above, if any of them say NULL in the output it means they are crashed and you'll need to repair the databases:
Additionally, please send the output of these commands (as root):
- NOTE: You may need to adjust the -h 127.0.0.1, the -uroot, and -pnagiosxi in the command if your DB is offloaded to another server and/or you've changed the root mysql password
Code: Select all
echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --tableCode: Select all
cd /usr/local/nagiosxi/scripts
./repair_databases.shRe: Scheduled Downtime Comment only visible thru Core
Please find the profile attached.
The DB check output is below
I can't see any NULL values
Moderator's Note: The profile has been shared with the support team but has been removed from the public forum.
The DB check output is below
I can't see any NULL values
Code: Select all
+--------------------------------------------+------------+
| Table | Size in MB |
+--------------------------------------------+------------+
| nagios_acknowledgements | 0.06 |
| nagios_commands | 0.02 |
| nagios_commenthistory | 1.14 |
| nagios_comments | 0.01 |
| nagios_configfiles | 0.00 |
| nagios_configfilevariables | 0.01 |
| nagios_conninfo | 0.12 |
| nagios_contact_addresses | 0.00 |
| nagios_contact_notificationcommands | 0.04 |
| nagios_contactgroup_members | 0.01 |
| nagios_contactgroups | 0.00 |
| nagios_contactnotificationmethods | 11.18 |
| nagios_contactnotifications | 12.12 |
| nagios_contacts | 0.01 |
| nagios_contactstatus | 0.01 |
| nagios_customvariables | 0.23 |
| nagios_customvariablestatus | 0.24 |
| nagios_dbversion | 0.00 |
| nagios_downtimehistory | 0.21 |
| nagios_eventhandlers | 0.01 |
| nagios_externalcommands | 0.02 |
| nagios_flappinghistory | 0.18 |
| nagios_host_contactgroups | 0.03 |
| nagios_host_contacts | 0.00 |
| nagios_host_parenthosts | 0.03 |
| nagios_hostchecks | 0.00 |
| nagios_hostdependencies | 0.00 |
| nagios_hostescalation_contactgroups | 0.00 |
| nagios_hostescalation_contacts | 0.00 |
| nagios_hostescalations | 0.00 |
| nagios_hostgroup_members | 0.07 |
| nagios_hostgroups | 0.00 |
| nagios_hosts | 0.15 |
| nagios_hoststatus | 0.37 |
| nagios_instances | 0.00 |
| nagios_logentries | 196.60 |
| nagios_notifications | 7.63 |
| nagios_objects | 0.41 |
| nagios_processevents | 0.30 |
| nagios_programstatus | 0.00 |
| nagios_runtimevariables | 0.00 |
| nagios_scheduleddowntime | 0.00 |
| nagios_service_contactgroups | 0.12 |
| nagios_service_contacts | 0.00 |
| nagios_service_parentservices | 0.00 |
| nagios_servicechecks | 0.00 |
| nagios_servicedependencies | 0.00 |
| nagios_serviceescalation_contactgroups | 0.00 |
| nagios_serviceescalation_contacts | 0.00 |
| nagios_serviceescalations | 0.00 |
| nagios_servicegroup_members | 0.00 |
| nagios_servicegroups | 0.00 |
| nagios_services | 0.60 |
| nagios_servicestatus | 1.67 |
| nagios_statehistory | 21.07 |
| nagios_systemcommands | 0.03 |
| nagios_timedeventqueue | 0.00 |
| nagios_timedevents | 0.00 |
| nagios_timeperiod_timeranges | 0.03 |
| nagios_timeperiods | 0.01 |
| tbl_command | 0.06 |
| tbl_contact | 0.03 |
| tbl_contactgroup | 0.03 |
| tbl_contacttemplate | 0.03 |
| tbl_domain | 0.03 |
| tbl_host | 0.19 |
| tbl_hostdependency | 0.03 |
| tbl_hostescalation | 0.03 |
| tbl_hostextinfo | 0.03 |
| tbl_hostgroup | 0.03 |
| tbl_hosttemplate | 0.03 |
| tbl_info | 0.17 |
| tbl_lnkContactToCommandHost | 0.02 |
| tbl_lnkContactToCommandService | 0.02 |
| tbl_lnkContactToContactgroup | 0.02 |
| tbl_lnkContactToContacttemplate | 0.02 |
| tbl_lnkContactToVariabledefinition | 0.02 |
| tbl_lnkContactgroupToContact | 0.02 |
| tbl_lnkContactgroupToContactgroup | 0.02 |
| tbl_lnkContacttemplateToCommandHost | 0.02 |
| tbl_lnkContacttemplateToCommandService | 0.02 |
| tbl_lnkContacttemplateToContactgroup | 0.02 |
| tbl_lnkContacttemplateToContacttemplate | 0.02 |
| tbl_lnkContacttemplateToVariabledefinition | 0.02 |
| tbl_lnkHostToContact | 0.02 |
| tbl_lnkHostToContactgroup | 0.05 |
| tbl_lnkHostToHost | 0.05 |
| tbl_lnkHostToHostgroup | 0.08 |
| tbl_lnkHostToHosttemplate | 0.05 |
| tbl_lnkHostToVariabledefinition | 0.05 |
| tbl_lnkHostdependencyToHost_DH | 0.02 |
| tbl_lnkHostdependencyToHost_H | 0.02 |
| tbl_lnkHostdependencyToHostgroup_DH | 0.02 |
| tbl_lnkHostdependencyToHostgroup_H | 0.02 |
| tbl_lnkHostescalationToContact | 0.02 |
| tbl_lnkHostescalationToContactgroup | 0.02 |
| tbl_lnkHostescalationToHost | 0.02 |
| tbl_lnkHostescalationToHostgroup | 0.02 |
| tbl_lnkHostgroupToHost | 0.02 |
| tbl_lnkHostgroupToHostgroup | 0.02 |
| tbl_lnkHosttemplateToContact | 0.02 |
| tbl_lnkHosttemplateToContactgroup | 0.02 |
| tbl_lnkHosttemplateToHost | 0.02 |
| tbl_lnkHosttemplateToHostgroup | 0.02 |
| tbl_lnkHosttemplateToHosttemplate | 0.02 |
| tbl_lnkHosttemplateToVariabledefinition | 0.02 |
| tbl_lnkServiceToContact | 0.02 |
| tbl_lnkServiceToContactgroup | 0.13 |
| tbl_lnkServiceToHost | 0.13 |
| tbl_lnkServiceToHostgroup | 0.02 |
| tbl_lnkServiceToServicegroup | 0.02 |
| tbl_lnkServiceToServicetemplate | 0.14 |
| tbl_lnkServiceToVariabledefinition | 0.11 |
| tbl_lnkServicedependencyToHost_DH | 0.02 |
| tbl_lnkServicedependencyToHost_H | 0.02 |
| tbl_lnkServicedependencyToHostgroup_DH | 0.02 |
| tbl_lnkServicedependencyToHostgroup_H | 0.02 |
| tbl_lnkServicedependencyToService_DS | 0.02 |
| tbl_lnkServicedependencyToService_S | 0.02 |
| tbl_lnkServicedependencyToServicegroup_DS | 0.02 |
| tbl_lnkServicedependencyToServicegroup_S | 0.02 |
| tbl_lnkServiceescalationToContact | 0.02 |
| tbl_lnkServiceescalationToContactgroup | 0.02 |
| tbl_lnkServiceescalationToHost | 0.02 |
| tbl_lnkServiceescalationToHostgroup | 0.02 |
| tbl_lnkServiceescalationToService | 0.02 |
| tbl_lnkServiceescalationToServicegroup | 0.02 |
| tbl_lnkServicegroupToService | 0.02 |
| tbl_lnkServicegroupToServicegroup | 0.02 |
| tbl_lnkServicetemplateToContact | 0.02 |
| tbl_lnkServicetemplateToContactgroup | 0.02 |
| tbl_lnkServicetemplateToHost | 0.02 |
| tbl_lnkServicetemplateToHostgroup | 0.02 |
| tbl_lnkServicetemplateToServicegroup | 0.02 |
| tbl_lnkServicetemplateToServicetemplate | 0.02 |
| tbl_lnkServicetemplateToVariabledefinition | 0.02 |
| tbl_lnkTimeperiodToTimeperiod | 0.02 |
| tbl_logbook | 0.02 |
| tbl_mainmenu | 0.02 |
| tbl_permission | 0.02 |
| tbl_permission_inactive | 0.02 |
| tbl_service | 1.52 |
| tbl_servicedependency | 0.03 |
| tbl_serviceescalation | 0.03 |
| tbl_serviceextinfo | 0.03 |
| tbl_servicegroup | 0.03 |
| tbl_servicetemplate | 0.03 |
| tbl_session | 0.02 |
| tbl_session_locks | 0.02 |
| tbl_settings | 0.03 |
| tbl_submenu | 0.02 |
| tbl_timedefinition | 0.06 |
| tbl_timeperiod | 0.03 |
| tbl_user | 0.03 |
| tbl_variabledefinition | 0.22 |
| xi_auditlog | 6.23 |
| xi_auth_tokens | 1.58 |
| xi_cmp_trapdata | 0.03 |
| xi_cmp_trapdata_log | 0.03 |
| xi_commands | 0.02 |
| xi_eventqueue | 0.03 |
| xi_events | 0.14 |
| xi_meta | 1.52 |
| xi_mibs | 0.05 |
| xi_options | 0.03 |
| xi_sessions | 0.03 |
| xi_sysstat | 0.03 |
| xi_usermeta | 0.44 |
| xi_users | 0.06 |
+--------------------------------------------+------------+Re: Scheduled Downtime Comment only visible thru Core
Please edit this file:
/usr/local/nagiosxi/html/config.inc.php
Change this:
To this:
Then test again.
/usr/local/nagiosxi/html/config.inc.php
Change this:
Code: Select all
$cfg['use_https'] = false;Code: Select all
$cfg['use_https'] = true;Re: Scheduled Downtime Comment only visible thru Core
No, this did not help.
See attached screenshots showing what we see in XI GUI vs Core
See attached screenshots showing what we see in XI GUI vs Core
You do not have the required permissions to view the files attached to this post.
Re: Scheduled Downtime Comment only visible thru Core
I'm able to replicate this on my system as a bug, I've created a bug report here so development can fix it:
NEW TASK ID 15190 created - Nagios XI Bug Report: XI - Scheduled Downtime comments not showing in XI interface
It's currently only possible to see it in the Nagios Core interface as you've found.
NEW TASK ID 15190 created - Nagios XI Bug Report: XI - Scheduled Downtime comments not showing in XI interface
It's currently only possible to see it in the Nagios Core interface as you've found.
Re: Scheduled Downtime Comment only visible thru Core
I see, thank you for confirming
Looking forward to see this fixed in a future release.
Looking forward to see this fixed in a future release.
-
scottwilkerson
- DevOps Engineer
- Posts: 19396
- Joined: Tue Nov 15, 2011 3:11 pm
- Location: Nagios Enterprises
- Contact:
Re: Scheduled Downtime Comment only visible thru Core
Great!ottow wrote:I see, thank you for confirming
Looking forward to see this fixed in a future release.
Locking thread