Upgrade 5.6.7 to 5.7.5 Importing into the CCM failed!
Posted: Tue Dec 01, 2020 2:32 pm
While testing a manual upgrade (via terminal) of XI 5.6.7 to 5.7.5 we received an error "Importing into the CCM failed! message."
Below is the output.
This appears to be caused by a failure to import on the NSClient. There is a configwizard-nsclient.cfg in the /usr/local/nagios/etc/import/ directory currently.
Also, I compared the list of Configuration Wizards on this 5.7.5 XI Host vs a 5.6.7 XI Host. The upgraded host now has a Wizard named "NSClient++" which appears deprecated, where as the 5.6.7 host do not have this Wizard. So I'm unsure why it was imported to begin with.
Update 1: Another issue discovered when attempting to add a test for monitoring results in the following error. A quick Google search indicates the previous failure may cause this too.
This upgrade was ran on Dev in an effort to upgrade our Prod environment in the near future, I'm looking to make the transition smooth as possible.
Please advise on the issue above along with any other known gotchas, thank you.
Below is the output.
Code: Select all
--- ccm_import.php -------------------
> Setting import directory: /usr/local/nagios/etc/import/
> Importing config files into the CCM
- Importing: /usr/local/nagios/etc/import/configwizard-bpiwizard.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-capacity-planning.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-check_sla.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-check_xi_deface.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-dnsquery.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-docker.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-domain_expiration.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-ec2.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-email-delivery.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-exchange.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-folder_watch.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-ftpserver.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-hyperv.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-java_as.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-json.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-ldapserver.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-linux-server.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-linuxsnmp.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-mailserver.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-mongodb_database.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-mongodb_server.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-mountpoint.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-mssql_server.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-mssqldatabase.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-mssqlquery.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-mysqlquery.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-mysqlserver.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-nagioslogserver.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-nagiostats.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-nagiosxiserver.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-ncpa_agent.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-nna.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-nsclient.cfg .. ERROR
Field 'service_description' doesn't have a default value<span class="greenmessage">Entry name::xiwizard_bpi_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_bpi_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_bpi inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry command_name::check_capacity_planning inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_check_sla2 inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_sla2 inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_check_deface_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_check_deface_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_deface inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_service_dnsquery inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_dnsquery_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_dnsquery_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_docker inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_domain_expiration_host_v2 inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_domain_expiration_service_v2 inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_domain_v2 inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_ec2_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_ec2_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_ec2 inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry command_name::check_email_delivery inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_exchange_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_exchange_ping_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_exchange_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_exchange_rbl inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_check_file_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_file_service inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_check_file_sa_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_file_size_age inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry command_name::check_ftp_fully inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_ftpserver_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_ftpserver_transfer_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_ftpserver_server_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_hyperv inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_java_as_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_java_as_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_java_as inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_java_weblogic_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_java_weblogic inside tbl_command successfully inserted</span><br>Entry name::xiwizard_json_host inside tbl_hosttemplate could not be inserted: 1<br>Entry name::xiwizard_json_service inside tbl_servicetemplate could not be inserted: 1<br><span class="greenmessage">Entry command_name::check_json inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_service_ldap inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_ldapserver_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_ldapserver_ldap_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_service_snmp_linux_load inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_service_snmp_linux_process inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_service_snmp_linux_storage inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_linuxsnmp_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_linuxsnmp_load inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_linuxsnmp_process inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_linuxsnmp_storage inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mailserver_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mailserver_ping_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mailserver_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_mailserver_rbl inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mongodbdatabase_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mongodbdatabase_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_mongodb_database inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mongodbserver_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mongodbserver_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_mongodb_server inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mountpoint_check inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mountpoint_check_table inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_mountpoint inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mssqlserver_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mssqlserver_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_mssql_server2 inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mssqldatabase_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mssqldatabase_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_mssql_database2 inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mssqlquery_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mssqlquery_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_mssql_query inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mysqlquery_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mysqlquery_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_mysql_query inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mysqlserver_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_mysqlserver_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_mysql_health inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_service_nagioslogserver inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_nagioslogserver_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_nagioslogserver_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_nagiostats_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_nagiosxi_performance inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_nagiosxiserver_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_nagiosxiserver_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_nagiosxiserver_http_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_nagiosxiserver_ping_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_nagiosxiserver inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_ncpa_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_ncpa_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_ncpa inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_nna_host inside tbl_hosttemplate successfully inserted</span><br><span class="greenmessage">Entry name::xiwizard_nna_service inside tbl_servicetemplate successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_nna inside tbl_command successfully inserted</span><br><span class="greenmessage">Entry command_name::check_xi_service_nsclient inside tbl_command successfully inserted</span><br>Entry name::xiwizard_nsclient_host inside tbl_hosttemplate could not be inserted: 1<br>Entry name::xiwizard_nsclient_ping_service inside tbl_servicetemplate could not be inserted: 1<br>Entry name::xiwizard_nsclient_service inside tbl_servicetemplate could not be inserted: 1<br>
- Importing: /usr/local/nagios/etc/import/configwizard-oraclequery.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-oracleserverspace.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-oracletablespace.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-passivecheck.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-passiveobject.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-postgresdb.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-postgresquery.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-postgresserver.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-radiusserver.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-s3.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-snmptrap.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-solaris.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-sshproxy.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-switch.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-tftp.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-vmware.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-watchguard.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-websensor.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-websiteurl.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-windowssnmp.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-windowswmi.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/configwizard-xml.cfg .. SUCCESS
- Importing: /usr/local/nagios/etc/import/xi_timeperiod_24x7.cfg .. SUCCESS
--------------------------------------
Importing into the CCM failed!Also, I compared the list of Configuration Wizards on this 5.7.5 XI Host vs a 5.6.7 XI Host. The upgraded host now has a Wizard named "NSClient++" which appears deprecated, where as the 5.6.7 host do not have this Wizard. So I'm unsure why it was imported to begin with.
Update 1: Another issue discovered when attempting to add a test for monitoring results in the following error. A quick Google search indicates the previous failure may cause this too.
Code: Select all
Domain Expiration Monitoring Wizard
Backend login to the Core Config Manager failed.
Configuration Error
An error occurred while attempting to apply your configuration to the monitoring engine. Contact your Nagios administrator if this problem persists.This upgrade was ran on Dev in an effort to upgrade our Prod environment in the near future, I'm looking to make the transition smooth as possible.
Please advise on the issue above along with any other known gotchas, thank you.