Good morning team,
We pulled the trigger this morning and updated our production XI servers to 5.7.3 after having it installed on our test server for a couple of weeks.
One thing that I'm still working out is when I make changes to hosts and services in CCM, those changes are not being reflected on the main Home page. For example, if a DNS Resolution check is reporting critical, I'll fix it in CCM and apply the change. When I run the check manually from CCM it reports back OK, but when I go back to the Home screen it still shows critical even if I force it to check again.
This is also happening for hosts and services that I deactivate. They still show on the Home page.
The only thing that seems to resolve it is to reboot the XI server. Almost like the DBs are stuck.
Any ideas?
Thank you!
Changes made in CCM not reflecting on XI Home page
Re: Changes made in CCM not reflecting on XI Home page
One other thing in addition to my initial request. Some of my BPI checks keep switching back and forth from OK to Unknown. I thought I fix it earlier because this has happened in the past, but the issue persists.
There are no errors in the BPI log and I have re-done all of the suggestions from my original support thread: https://support.nagios.com/forum/viewto ... 16&t=55180
There are no errors in the BPI log and I have re-done all of the suggestions from my original support thread: https://support.nagios.com/forum/viewto ... 16&t=55180
Re: Changes made in CCM not reflecting on XI Home page
Please PM me a copy of your profile, you can download it from Admin > System Profile by clicking the Download Profile button.
We may need to downgrade your NDO3 back to NDO2DB (your XI version stays at XI 5.7.3), there is a known issue on some systems running the new NDO3 in XI 5.7+ where the XI web interface doesn't update.
Do the CCM changes show up here in the backend Core interface?
- Just login with your XI credentials
Additionally, please send the output of these commands:
- NOTE: You may need to adjust the -h 127.0.0.1, the -uroot, and -pnagiosxi in the first command if your DB is offloaded to another server and/or you've changed the root mysql password
This next command may fail, that's okay, not all systems run postgresql, send the output anyways:
We may need to downgrade your NDO3 back to NDO2DB (your XI version stays at XI 5.7.3), there is a known issue on some systems running the new NDO3 in XI 5.7+ where the XI web interface doesn't update.
Do the CCM changes show up here in the backend Core interface?
- Just login with your XI credentials
Code: Select all
http://YOURXISERVER/nagios/- NOTE: You may need to adjust the -h 127.0.0.1, the -uroot, and -pnagiosxi in the first 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
echo "SELECT relname as Table, pg_size_pretty(pg_total_relation_size(relid)) As Size, pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as ExternalSize FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;" | psql nagiosxi nagiosxiRe: Changes made in CCM not reflecting on XI Home page
All changes are currently showing up in the console. Overtime, they eventually get applied. I am unsure what the trigger is.
Here's the output from the first command:
Here's the output from the second command:
PM sent with current system profile. Thank you!
Here's the output from the first command:
Code: Select all
root@nagiosxi:/root>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 --table
+--------------------------------------------+------------+
| Table | Size in MB |
+--------------------------------------------+------------+
| nagios_acknowledgements | 0.18 |
| nagios_commands | 0.03 |
| nagios_commenthistory | 160.45 |
| nagios_comments | 0.33 |
| nagios_configfiles | 0.01 |
| nagios_configfilevariables | 0.01 |
| nagios_conninfo | 1.62 |
| nagios_contact_addresses | 0.01 |
| nagios_contact_notificationcommands | 0.03 |
| nagios_contactgroup_members | 0.02 |
| nagios_contactgroups | 0.00 |
| nagios_contactnotificationmethods | 21.63 |
| nagios_contactnotifications | 22.93 |
| nagios_contacts | 0.03 |
| nagios_contactstatus | 0.02 |
| nagios_customvariables | 0.13 |
| nagios_customvariablestatus | 0.14 |
| nagios_dbversion | 0.00 |
| nagios_downtimehistory | 7.77 |
| nagios_eventhandlers | 0.00 |
| nagios_externalcommands | 0.17 |
| nagios_flappinghistory | 4.27 |
| nagios_host_contactgroups | 0.04 |
| nagios_host_contacts | 0.01 |
| nagios_host_parenthosts | 0.00 |
| nagios_hostchecks | 0.00 |
| nagios_hostdependencies | 0.00 |
| nagios_hostescalation_contactgroups | 0.05 |
| nagios_hostescalation_contacts | 0.00 |
| nagios_hostescalations | 0.08 |
| nagios_hostgroup_members | 0.06 |
| nagios_hostgroups | 0.01 |
| nagios_hosts | 0.13 |
| nagios_hoststatus | 0.30 |
| nagios_instances | 0.00 |
| nagios_logentries | 257.65 |
| nagios_notifications | 10.02 |
| nagios_objects | 1.41 |
| nagios_processevents | 0.53 |
| nagios_programstatus | 0.00 |
| nagios_runtimevariables | 0.00 |
| nagios_scheduleddowntime | 0.13 |
| nagios_service_contactgroups | 0.29 |
| nagios_service_contacts | 0.06 |
| nagios_service_parentservices | 0.00 |
| nagios_servicechecks | 0.00 |
| nagios_servicedependencies | 0.00 |
| nagios_serviceescalation_contactgroups | 0.34 |
| nagios_serviceescalation_contacts | 0.00 |
| nagios_serviceescalations | 0.63 |
| nagios_servicegroup_members | 0.05 |
| nagios_servicegroups | 0.00 |
| nagios_services | 0.83 |
| nagios_servicestatus | 1.99 |
| nagios_statehistory | 362.67 |
| nagios_systemcommands | 0.00 |
| nagios_timedeventqueue | 0.00 |
| nagios_timedevents | 0.00 |
| nagios_timeperiod_timeranges | 0.09 |
| nagios_timeperiods | 0.02 |
| tbl_command | 0.05 |
| tbl_contact | 0.04 |
| tbl_contactgroup | 0.01 |
| tbl_contacttemplate | 0.01 |
| tbl_domain | 0.01 |
| tbl_host | 0.10 |
| tbl_hostdependency | 0.01 |
| tbl_hostescalation | 0.01 |
| tbl_hostextinfo | 0.00 |
| tbl_hostgroup | 0.02 |
| tbl_hosttemplate | 0.02 |
| tbl_info | 0.13 |
| tbl_lnkContactToCommandHost | 0.00 |
| tbl_lnkContactToCommandService | 0.00 |
| tbl_lnkContactToContactgroup | 0.00 |
| tbl_lnkContactToContacttemplate | 0.01 |
| tbl_lnkContactToVariabledefinition | 0.00 |
| tbl_lnkContactgroupToContact | 0.01 |
| tbl_lnkContactgroupToContactgroup | 0.00 |
| tbl_lnkContacttemplateToCommandHost | 0.00 |
| tbl_lnkContacttemplateToCommandService | 0.00 |
| tbl_lnkContacttemplateToContactgroup | 0.00 |
| tbl_lnkContacttemplateToContacttemplate | 0.00 |
| tbl_lnkContacttemplateToVariabledefinition | 0.00 |
| tbl_lnkHostToContact | 0.01 |
| tbl_lnkHostToContactgroup | 0.03 |
| tbl_lnkHostToHost | 0.00 |
| tbl_lnkHostToHostgroup | 0.01 |
| tbl_lnkHostToHosttemplate | 0.02 |
| tbl_lnkHostToVariabledefinition | 0.01 |
| tbl_lnkHostdependencyToHost_DH | 0.00 |
| tbl_lnkHostdependencyToHost_H | 0.00 |
| tbl_lnkHostdependencyToHostgroup_DH | 0.00 |
| tbl_lnkHostdependencyToHostgroup_H | 0.00 |
| tbl_lnkHostescalationToContact | 0.00 |
| tbl_lnkHostescalationToContactgroup | 0.00 |
| tbl_lnkHostescalationToHost | 0.00 |
| tbl_lnkHostescalationToHostgroup | 0.00 |
| tbl_lnkHostgroupToHost | 0.02 |
| tbl_lnkHostgroupToHostgroup | 0.00 |
| tbl_lnkHosttemplateToContact | 0.00 |
| tbl_lnkHosttemplateToContactgroup | 0.00 |
| tbl_lnkHosttemplateToHost | 0.00 |
| tbl_lnkHosttemplateToHostgroup | 0.00 |
| tbl_lnkHosttemplateToHosttemplate | 0.01 |
| tbl_lnkHosttemplateToVariabledefinition | 0.00 |
| tbl_lnkServiceToContact | 0.06 |
| tbl_lnkServiceToContactgroup | 0.18 |
| tbl_lnkServiceToHost | 0.11 |
| tbl_lnkServiceToHostgroup | 0.00 |
| tbl_lnkServiceToServicegroup | 0.00 |
| tbl_lnkServiceToServicetemplate | 0.04 |
| tbl_lnkServiceToVariabledefinition | 0.03 |
| tbl_lnkServicedependencyToHost_DH | 0.00 |
| tbl_lnkServicedependencyToHost_H | 0.00 |
| tbl_lnkServicedependencyToHostgroup_DH | 0.00 |
| tbl_lnkServicedependencyToHostgroup_H | 0.00 |
| tbl_lnkServicedependencyToService_DS | 0.00 |
| tbl_lnkServicedependencyToService_S | 0.00 |
| tbl_lnkServicedependencyToServicegroup_DS | 0.02 |
| tbl_lnkServicedependencyToServicegroup_S | 0.02 |
| tbl_lnkServiceescalationToContact | 0.00 |
| tbl_lnkServiceescalationToContactgroup | 0.00 |
| tbl_lnkServiceescalationToHost | 0.00 |
| tbl_lnkServiceescalationToHostgroup | 0.00 |
| tbl_lnkServiceescalationToService | 0.00 |
| tbl_lnkServiceescalationToServicegroup | 0.02 |
| tbl_lnkServicegroupToService | 0.05 |
| tbl_lnkServicegroupToServicegroup | 0.00 |
| tbl_lnkServicetemplateToContact | 0.00 |
| tbl_lnkServicetemplateToContactgroup | 0.00 |
| tbl_lnkServicetemplateToHost | 0.00 |
| tbl_lnkServicetemplateToHostgroup | 0.00 |
| tbl_lnkServicetemplateToServicegroup | 0.00 |
| tbl_lnkServicetemplateToServicetemplate | 0.01 |
| tbl_lnkServicetemplateToVariabledefinition | 0.00 |
| tbl_lnkTimeperiodToTimeperiod | 0.00 |
| tbl_logbook | 0.00 |
| tbl_mainmenu | 0.00 |
| tbl_permission | 0.02 |
| tbl_permission_inactive | 0.02 |
| tbl_service | 0.73 |
| tbl_servicedependency | 0.01 |
| tbl_serviceescalation | 0.01 |
| tbl_serviceextinfo | 0.00 |
| tbl_servicegroup | 0.01 |
| tbl_servicetemplate | 0.03 |
| tbl_session | 0.00 |
| tbl_session_locks | 0.00 |
| tbl_settings | 0.00 |
| tbl_submenu | 0.00 |
| tbl_timedefinition | 0.08 |
| tbl_timeperiod | 0.04 |
| tbl_user | 0.01 |
| tbl_variabledefinition | 0.08 |
| xi_auditlog | 0.08 |
| xi_auth_tokens | 0.03 |
| xi_cmp_trapdata | 0.03 |
| xi_cmp_trapdata_log | 0.03 |
| xi_commands | 0.02 |
| xi_eventqueue | 0.03 |
| xi_events | 0.05 |
| xi_meta | 0.02 |
| xi_mibs | 0.05 |
| xi_options | 0.03 |
| xi_sessions | 0.03 |
| xi_sysstat | 0.03 |
| xi_usermeta | 0.05 |
| xi_users | 0.03 |
+--------------------------------------------+------------+
Code: Select all
root@nagiosxi:/root> echo "SELECT relname as Table, pg_size_pretty(pg_total_relation_size(relid)) As Size, pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as ExternalSize FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;" | psql nagiosxi nagiosxi
table | size | externalsize
--------------------------+------------+--------------
xi_meta | 39 MB | 13 MB
xi_auditlog | 10008 kB | 5904 kB
xi_events | 6352 kB | 6088 kB
xi_usermeta | 2536 kB | 1648 kB
xi_options | 144 kB | 112 kB
xi_users | 120 kB | 64 kB
xi_commands | 104 kB | 96 kB
xi_sysstat | 96 kB | 72 kB
xi_mibs | 72 kB | 64 kB
xi_cmp_nagiosbpi_backups | 64 kB | 56 kB
xi_eventqueue | 56 kB | 48 kB
xi_sessions | 48 kB | 40 kB
xi_auth_tokens | 40 kB | 40 kB
xi_cmp_trapdata | 24 kB | 24 kB
xi_deploy_agents | 16 kB | 16 kB
xi_deploy_jobs | 16 kB | 16 kB
xi_cmp_trapdata_log | 16 kB | 16 kB
xi_cmp_favorites | 16 kB | 16 kB
xi_cmp_ccm_backups | 8192 bytes | 8192 bytes
xi_incidents | 8192 bytes | 8192 bytes
(20 rows)
Re: Changes made in CCM not reflecting on XI Home page
Please do this to downgrade NDO3 back to NDO2DB and it should resolve your issues:
Then edit your /usr/local/nagios/etc/nagios.cfg and change this line:
To:
Then start the nagios service:
Now apply configuration and validate that they show up.
Code: Select all
systemctl stop nagios
cd /tmp
rm -rf /tmp/nagiosxi
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.6.14.tar.gz
tar zxf xi-5.6.14.tar.gz
cd /tmp/nagiosxi
./init.sh
cd /tmp/nagiosxi/subcomponents/ndoutils
./install
systemctl enable ndo2db
systemctl start ndo2dbCode: Select all
broker_module=/usr/local/nagios/bin/ndo.so /usr/local/nagios/etc/ndo.cfgCode: Select all
broker_module=/usr/local/nagios/bin/ndomod.o config_file=/usr/local/nagios/etc/ndomod.cfgCode: Select all
systemctl start nagiosRe: Changes made in CCM not reflecting on XI Home page
That did the trick. What's the plan for future updates? Will we need to downgrade NDO every time?
Re: Changes made in CCM not reflecting on XI Home page
The XI 5.7+ NDO3 to NDO2DB downgraded systems should stay downgraded in the upcoming XI 5.7.4 release (I labbed it up and validated that it does stay downgraded, this is what development wants). The XI version will change but you will still be on the old NDO2DB until development is satisfied with the new NDO3 functionality enough to release an updated version that will re-upgrade you again.Will we need to downgrade NDO every time?
Re: Changes made in CCM not reflecting on XI Home page
Ok. That's good to hear. You can lock this thread. Thank you for your assistance as always.