Page 1 of 1

Double entries after importing

Posted: Wed Jul 11, 2018 3:34 am
by sltn_support
Hi,

In ccm I imported config files and checked the Overwrite Database option.
But after importing I have double entries for example:


check_vmware_vma-switch-status VMware: Host Switch Status Yes Applied EditCopyDownloadInfoDelete 5699
check_vmware_vma-switch-status VMware: Host Switch Status Yes Applied EditCopyDownloadInfoDelete 6258
check_vmware_vma-status VMware: Host Status Yes Applied EditCopyDownloadInfoDelete 5696
check_vmware_vma-status VMware: Host Status Yes Applied EditCopyDownloadInfoDelete 6255
check_vmware_vma-os-name-version VMware: Host OS Name Version Yes Applied EditCopyDownloadInfoDelete 5695
check_vmware_vma-os-name-version VMware: Host OS Name Version Yes Applied EditCopyDownloadInfoDelete 6254
check_vmware_vma-license-status VMware: Host License Status Yes Applied EditCopyDownloadInfoDelete 5694
check_vmware_vma-license-status VMware: Host License Status Yes Applied EditCopyDownloadInfoDelete 6253
check_vmware_vma-host-vnic-status VMware: Host vNIC Status Yes Applied EditCopyDownloadInfoDelete 5693
check_vmware_vma-host-vnic-status VMware: Host vNIC Status Yes Applied EditCopyDownloadInfoDelete 6252
check_vmware_vma-host-up-down-state VMware: Host Up-Down State Yes Applied EditCopyDownloadInfoDelete 5692
check_vmware_vma-host-up-down-state VMware: Host Up-Down State Yes Applied EditCopyDownloadInfoDelete 6251
check_vmware_vma-host-storage-adapter-performance-vmhba32-vmhba33 VMware: Host Storage Adapter Performance vmhba32 vmhba33 Yes Applied EditCopyDownloadInfoDelete 5691
check_vmware_vma-host-storage-adapter-performance-vmhba32-vmhba33 VMware: Host Storage Adapter Performance vmhba32 vmhba33 Yes Applied EditCopyDownloadInfoDelete 6250
check_vmware_vma-host-storage-adapter-performance-vmhba0 VMware: Host Storage Adapter Performance vmhba0 Yes Applied EditCopyDownloadInfoDelete 5690

Re: Double entries after importing

Posted: Wed Jul 11, 2018 12:52 pm
by cdienger
What version of XI is this and can you PM the imported configs?

Re: Double entries after importing

Posted: Thu Jul 12, 2018 6:14 am
by sltn_support
cdienger wrote:What version of XI is this and can you PM the imported configs?
Currently we are using 5.5

Code: Select all

###############################################################################
#
# Services configuration file
#
# Created by: Nagios CCM 2.7.0
# Date:       2018-07-12 09:09:22
# Version:    Nagios Core 4.x
#
# --- DO NOT EDIT THIS FILE BY HAND ---
# Nagios CCM will overwrite all manual settings during the next update if you
# would like to edit files manually, place them in the 'static' directory or
# import your configs into the CCM by placing them in the 'import' directory.
#
###############################################################################

define service {
    service_description    VMware: Host Switch Status
    use                    st_alert_low,st_check_15-5-6
    hostgroup_name         04_vmware_vsphereesxi_5,04_vmware_vsphereesxi_6,04_vmware_vsphereesxi_6.5,04_vmware_vsphereesxi_6.5_vmhba32-vmhba33
    check_command          check_vmware_vma!$_HOSTVM_VMA$!$_HOSTVM_VCENTER$!Host_Switch_Status!--host $HOSTNOTES$!--perfdata_option post_check:disabled!!!
    process_perf_data      1
    register               1
}


###############################################################################
#
# Services configuration file
#
# END OF FILE
#
###############################################################################

Re: Double entries after importing

Posted: Thu Jul 12, 2018 1:24 pm
by cdienger
I'm not able to reproduce the problem. Are you looking to import more and avoid this going forward or have you imported everything? If the latter, then I would simply delete any duplicates. If the former, try restarting all the services to make sure everything is running normally:

Note you ***must*** use mariadb instead of mysqld in the commands below, ***if*** you have mariadb.
service nagios stop
service ndo2db stop
service mysqld stop
service crond stop
service httpd stop
killall -9 nagios
killall -9 ndo2db
rm -f /usr/local/nagios/var/rw/nagios.cmd
rm -f /usr/local/nagios/var/nagios.lock
rm -f /usr/local/nagios/var/ndo.sock
rm -f /usr/local/nagios/var/ndo2db.lock
rm -f /usr/local/nagiosxi/var/reconfigure_nagios.lock
for i in `ipcs -q | grep nagios |awk '{print $2}'`; do ipcrm -q $i; done
service mysqld start
service ndo2db start
service nagios start
service httpd start
service crond start


It would also be good to run the database repair script: https://assets.nagios.com/downloads/nag ... tabase.pdf