Applying Configuration deletes all services

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
vistate
Posts: 11
Joined: Tue Aug 22, 2017 10:55 am

Applying Configuration deletes all services

Post by vistate »

Hi there,

we are having an issue where any time we attempt to apply a configuration /usr/local/nagios/etc/services/ is emptied and not populated by any configurations.

We are running Nagios XI 5.4.9
Top
User avatar
tacolover101
Posts: 432
Joined: Mon Apr 10, 2017 11:55 am

Re: Applying Configuration deletes all services

Post by tacolover101 »

does your apache / nagios user have the correct permissions to write back to the folder?

the apply config process runs something like this -
1. delete all files
2. re-write out files from DB
3. restart nagios
Top
vistate
Posts: 11
Joined: Tue Aug 22, 2017 10:55 am

Re: Applying Configuration deletes all services

Post by vistate »

Hi - yes

permissions are correct.

-rwxr-xr-x 1 apache nagios 823 Sep 13 20:37 servicedependencies.cfg
-rwxr-xr-x 1 apache nagios 825 Sep 13 20:37 serviceescalations.cfg
-rwxr-xr-x 1 apache nagios 843 Sep 13 20:37 serviceextinfo.cfg
-rwxr-xr-x 1 apache nagios 12625 Sep 13 20:37 servicegroups.cfg
-rw-rw-r-- 1 apache nagios 7452 Jul 17 2014 servicegroups.cfg.qt
-rwxr-xr-x 1 apache nagios 56918 Sep 13 20:37 servicetemplates.cfg
-rw-rw-r-- 1 apache nagios 23911 May 26 2014 servicetemplates.cfg.qt

if i load from backup config - the files are populated. If I delete the config files from config file management and re-write the configs - i do not see any configs written to /usr/local/nagios/etc/services/
Top
vistate
Posts: 11
Joined: Tue Aug 22, 2017 10:55 am

Re: Applying Configuration deletes all services

Post by vistate »

Write host configurations ...
WARNING! Ghost host config detected! Removing the file example.cfg
Host configuration files successfully written!

Write service configurations ...
Service configuration files successfully written!

Configuration file: hostgroups.cfg successfully written!
Configuration file: servicegroups.cfg successfully written!
Configuration file: hosttemplates.cfg successfully written!
Configuration file: servicetemplates.cfg successfully written!
Configuration file: timeperiods.cfg successfully written!
Configuration file: commands.cfg successfully written!
Configuration file: contacts.cfg successfully written!
Configuration file: contactgroups.cfg successfully written!
Configuration file: contacttemplates.cfg successfully written!
Configuration file: servicedependencies.cfg successfully written!
Configuration file: hostdependencies.cfg successfully written!
Configuration file: serviceescalations.cfg successfully written!
Configuration file: hostescalations.cfg successfully written!
Configuration file: serviceextinfo.cfg successfully written!
Configuration file: hostextinfo.cfg successfully written!

[Wed Sep 13 20:43:31] nagios@******:/usr/local/nagios/etc/services# ll
total 0
Top
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Applying Configuration deletes all services

Post by tgriep »

Can you login to the XI GUI and go to the Configure > Core Config Manager menu and under the CCM Object Summary, what does it show for the number of Hosts and Services?
Please provide a screen capture if possible.
If you go to the Services menu in the CCM, are all of the services Active?

Then run the following on the Nagios Server and post the output.

Code: Select all

grep dbtype  /usr/local/nagiosxi/html/config.inc.php
ps -ef --cols=300
Be sure to check out our Knowledgebase for helpful articles and solutions!
Top
vistate
Posts: 11
Joined: Tue Aug 22, 2017 10:55 am

Re: Applying Configuration deletes all services

Post by vistate »

Code: Select all

grep dbtype  /usr/local/nagiosxi/html/config.inc.php

[Thu Sep 14 14:42:32] root@ngs:/usr/local/nagios/etc/services# grep dbtype  /usr/local/nagiosxi/html/config.inc.php
$cfg['dbtype']=''; // this setting is no longer used - use settings below
                "dbtype" => 'pgsql',
                "dbtype" => 'mysql',
                "dbtype" => 'mysql',
//if (!defined('CFG_ONLY')) { require_once(dirname(__FILE__).'/db/'.$cfg['dbtype'].'.inc.php'); }



[Thu Sep 14 14:42:40] root@sq5vrlngs001:/usr/local/nagios/etc/services# ps -ef --cols=300
UID        PID  PPID  C STIME TTY          TIME CMD
root         1     0  0 Jul20 ?        00:00:04 /sbin/init
root         2     0  0 Jul20 ?        00:00:00 [kthreadd]
root         3     2  0 Jul20 ?        00:01:51 [migration/0]
root         4     2  0 Jul20 ?        00:00:45 [ksoftirqd/0]
root         5     2  0 Jul20 ?        00:00:00 [stopper/0]
root         6     2  0 Jul20 ?        00:00:03 [watchdog/0]
root         7     2  0 Jul20 ?        00:02:06 [migration/1]
root         8     2  0 Jul20 ?        00:00:00 [stopper/1]
root         9     2  0 Jul20 ?        00:00:46 [ksoftirqd/1]
root        10     2  0 Jul20 ?        00:00:03 [watchdog/1]
root        11     2  0 Jul20 ?        00:02:20 [migration/2]
root        12     2  0 Jul20 ?        00:00:00 [stopper/2]
root        13     2  0 Jul20 ?        00:00:46 [ksoftirqd/2]
root        14     2  0 Jul20 ?        00:00:02 [watchdog/2]
root        15     2  0 Jul20 ?        00:02:34 [migration/3]
root        16     2  0 Jul20 ?        00:00:00 [stopper/3]
root        17     2  0 Jul20 ?        00:00:47 [ksoftirqd/3]
root        18     2  0 Jul20 ?        00:00:02 [watchdog/3]
root        19     2  0 Jul20 ?        00:03:14 [migration/4]
root        20     2  0 Jul20 ?        00:00:00 [stopper/4]
root        21     2  0 Jul20 ?        00:00:47 [ksoftirqd/4]
root        22     2  0 Jul20 ?        00:00:02 [watchdog/4]
root        23     2  0 Jul20 ?        00:01:58 [migration/5]
root        24     2  0 Jul20 ?        00:00:00 [stopper/5]
root        25     2  0 Jul20 ?        00:00:46 [ksoftirqd/5]
root        26     2  0 Jul20 ?        00:00:03 [watchdog/5]
root        27     2  0 Jul20 ?        00:02:27 [migration/6]
root        28     2  0 Jul20 ?        00:00:00 [stopper/6]
root        29     2  0 Jul20 ?        00:00:46 [ksoftirqd/6]
root        30     2  0 Jul20 ?        00:00:02 [watchdog/6]
root        31     2  0 Jul20 ?        00:01:46 [migration/7]
root        32     2  0 Jul20 ?        00:00:00 [stopper/7]
root        33     2  0 Jul20 ?        00:00:45 [ksoftirqd/7]
root        34     2  0 Jul20 ?        00:00:02 [watchdog/7]
root        35     2  0 Jul20 ?        00:20:06 [events/0]
root        36     2  0 Jul20 ?        00:02:25 [events/1]
root        37     2  0 Jul20 ?        00:02:25 [events/2]
root        38     2  0 Jul20 ?        00:02:26 [events/3]
root        39     2  0 Jul20 ?        00:02:27 [events/4]
root        40     2  0 Jul20 ?        00:02:32 [events/5]
root        41     2  0 Jul20 ?        00:03:01 [events/6]
root        42     2  0 Jul20 ?        00:05:25 [events/7]
root        43     2  0 Jul20 ?        00:00:00 [events/0]
root        44     2  0 Jul20 ?        00:00:00 [events/1]
root        45     2  0 Jul20 ?        00:00:00 [events/2]
root        46     2  0 Jul20 ?        00:00:00 [events/3]
root        47     2  0 Jul20 ?        00:00:00 [events/4]
root        48     2  0 Jul20 ?        00:00:00 [events/5]
root        49     2  0 Jul20 ?        00:00:00 [events/6]
root        50     2  0 Jul20 ?        00:00:00 [events/7]
root        51     2  0 Jul20 ?        00:00:00 [events_long/0]
root        52     2  0 Jul20 ?        00:00:00 [events_long/1]
root        53     2  0 Jul20 ?        00:00:00 [events_long/2]
root        54     2  0 Jul20 ?        00:00:00 [events_long/3]
root        55     2  0 Jul20 ?        00:00:00 [events_long/4]
root        56     2  0 Jul20 ?        00:00:00 [events_long/5]
root        57     2  0 Jul20 ?        00:00:00 [events_long/6]
root        58     2  0 Jul20 ?        00:00:00 [events_long/7]
root        59     2  0 Jul20 ?        00:00:00 [events_power_ef]
root        60     2  0 Jul20 ?        00:00:00 [events_power_ef]
root        61     2  0 Jul20 ?        00:00:00 [events_power_ef]
root        62     2  0 Jul20 ?        00:00:00 [events_power_ef]
root        63     2  0 Jul20 ?        00:00:00 [events_power_ef]
root        64     2  0 Jul20 ?        00:00:00 [events_power_ef]
root        65     2  0 Jul20 ?        00:00:00 [events_power_ef]
root        66     2  0 Jul20 ?        00:00:00 [events_power_ef]
root        67     2  0 Jul20 ?        00:00:00 [cgroup]
root        68     2  0 Jul20 ?        00:00:26 [khelper]
root        69     2  0 Jul20 ?        00:00:00 [netns]
root        70     2  0 Jul20 ?        00:00:00 [async/mgr]
root        71     2  0 Jul20 ?        00:00:00 [pm]
root        72     2  0 Jul20 ?        00:00:10 [sync_supers]
root        73     2  0 Jul20 ?        00:00:12 [bdi-default]
root        74     2  0 Jul20 ?        00:00:00 [kintegrityd/0]
root        75     2  0 Jul20 ?        00:00:00 [kintegrityd/1]
root        76     2  0 Jul20 ?        00:00:00 [kintegrityd/2]
root        77     2  0 Jul20 ?        00:00:00 [kintegrityd/3]
root        78     2  0 Jul20 ?        00:00:00 [kintegrityd/4]
root        79     2  0 Jul20 ?        00:00:00 [kintegrityd/5]
root        80     2  0 Jul20 ?        00:00:00 [kintegrityd/6]
root        81     2  0 Jul20 ?        00:00:00 [kintegrityd/7]
root        82     2  0 Jul20 ?        00:01:01 [kblockd/0]
root        83     2  0 Jul20 ?        00:00:57 [kblockd/1]
root        84     2  0 Jul20 ?        00:01:01 [kblockd/2]
root        85     2  0 Jul20 ?        00:01:00 [kblockd/3]
root        86     2  0 Jul20 ?        00:00:57 [kblockd/4]
root        87     2  0 Jul20 ?        00:00:56 [kblockd/5]
root        88     2  0 Jul20 ?        00:00:58 [kblockd/6]
root        89     2  0 Jul20 ?        00:00:58 [kblockd/7]
root        90     2  0 Jul20 ?        00:00:00 [kacpid]
root        91     2  0 Jul20 ?        00:00:00 [kacpi_notify]
root        92     2  0 Jul20 ?        00:00:00 [kacpi_hotplug]
root        93     2  0 Jul20 ?        00:00:00 [ata_aux]
root        94     2  0 Jul20 ?        00:00:00 [ata_sff/0]
root        95     2  0 Jul20 ?        00:00:00 [ata_sff/1]
root        96     2  0 Jul20 ?        00:00:00 [ata_sff/2]
root        97     2  0 Jul20 ?        00:00:00 [ata_sff/3]
root        98     2  0 Jul20 ?        00:00:00 [ata_sff/4]
root        99     2  0 Jul20 ?        00:00:00 [ata_sff/5]
root       100     2  0 Jul20 ?        00:00:00 [ata_sff/6]
root       101     2  0 Jul20 ?        00:00:00 [ata_sff/7]
root       102     2  0 Jul20 ?        00:00:00 [ksuspend_usbd]
root       103     2  0 Jul20 ?        00:00:00 [khubd]
root       104     2  0 Jul20 ?        00:00:00 [kseriod]
root       105     2  0 Jul20 ?        00:00:00 [md/0]
root       106     2  0 Jul20 ?        00:00:00 [md/1]
root       107     2  0 Jul20 ?        00:00:00 [md/2]
root       108     2  0 Jul20 ?        00:00:00 [md/3]
root       109     2  0 Jul20 ?        00:00:00 [md/4]
root       110     2  0 Jul20 ?        00:00:00 [md/5]
root       111     2  0 Jul20 ?        00:00:00 [md/6]
root       112     2  0 Jul20 ?        00:00:00 [md/7]
root       113     2  0 Jul20 ?        00:00:00 [md_misc/0]
root       114     2  0 Jul20 ?        00:00:00 [md_misc/1]
root       115     2  0 Jul20 ?        00:00:00 [md_misc/2]
root       116     2  0 Jul20 ?        00:00:00 [md_misc/3]
root       117     2  0 Jul20 ?        00:00:00 [md_misc/4]
root       118     2  0 Jul20 ?        00:00:00 [md_misc/5]
root       119     2  0 Jul20 ?        00:00:00 [md_misc/6]
root       120     2  0 Jul20 ?        00:00:00 [md_misc/7]
root       121     2  0 Jul20 ?        00:00:00 [linkwatch]
root       123     2  0 Jul20 ?        00:00:00 [khungtaskd]
root       124     2  0 Jul20 ?        00:10:26 [kswapd0]
root       125     2  0 Jul20 ?        00:00:00 [ksmd]
root       126     2  0 Jul20 ?        00:17:40 [khugepaged]
root       127     2  0 Jul20 ?        00:00:00 [aio/0]
root       128     2  0 Jul20 ?        00:00:00 [aio/1]
root       129     2  0 Jul20 ?        00:00:00 [aio/2]
root       130     2  0 Jul20 ?        00:00:00 [aio/3]
root       131     2  0 Jul20 ?        00:00:00 [aio/4]
root       132     2  0 Jul20 ?        00:00:00 [aio/5]
root       133     2  0 Jul20 ?        00:00:00 [aio/6]
root       134     2  0 Jul20 ?        00:00:00 [aio/7]
root       135     2  0 Jul20 ?        00:00:00 [crypto/0]
root       136     2  0 Jul20 ?        00:00:00 [crypto/1]
root       137     2  0 Jul20 ?        00:00:00 [crypto/2]
root       138     2  0 Jul20 ?        00:00:00 [crypto/3]
root       139     2  0 Jul20 ?        00:00:00 [crypto/4]
root       140     2  0 Jul20 ?        00:00:00 [crypto/5]
root       141     2  0 Jul20 ?        00:00:00 [crypto/6]
root       142     2  0 Jul20 ?        00:00:00 [crypto/7]
root       149     2  0 Jul20 ?        00:00:00 [kthrotld/0]
root       150     2  0 Jul20 ?        00:00:00 [kthrotld/1]
root       151     2  0 Jul20 ?        00:00:00 [kthrotld/2]
root       152     2  0 Jul20 ?        00:00:00 [kthrotld/3]
root       153     2  0 Jul20 ?        00:00:00 [kthrotld/4]
root       154     2  0 Jul20 ?        00:00:00 [kthrotld/5]
root       155     2  0 Jul20 ?        00:00:00 [kthrotld/6]
root       156     2  0 Jul20 ?        00:00:00 [kthrotld/7]
root       157     2  0 Jul20 ?        00:00:00 [pciehpd]
root       159     2  0 Jul20 ?        00:00:00 [kpsmoused]
root       160     2  0 Jul20 ?        00:00:00 [usbhid_resumer]
root       161     2  0 Jul20 ?        00:00:00 [deferwq]
root       194     2  0 Jul20 ?        00:00:00 [kdmremove]
root       195     2  0 Jul20 ?        00:00:00 [kstriped]
root       226     2  0 Jul20 ?        00:00:00 [ttm_swap]
root       398     2  0 Jul20 ?        00:00:00 [scsi_eh_0]
root       399     2  0 Jul20 ?        00:00:00 [scsi_eh_1]
root       470     2  0 Jul20 ?        00:00:00 [scsi_eh_2]
root       471     2  0 Jul20 ?        00:00:00 [vmw_pvscsi_wq_2]
root       547     2  0 Jul20 ?        00:00:00 [kdmflush]
root       549     2  0 Jul20 ?        00:00:00 [kdmflush]
root       567     2  0 Jul20 ?        00:08:25 [jbd2/dm-1-8]
root       568     2  0 Jul20 ?        00:00:00 [ext4-dio-unwrit]
root       666     1  0 Jul20 ?        00:00:00 /sbin/udevd -d
apache     814  2374  0 11:39 ?        00:00:45 /usr/sbin/httpd
postgres   845  2175  0 11:39 ?        00:00:00 postgres: nagiosxi nagiosxi 127.0.0.1(59232) idle
root       945     2  0 Jul20 ?        00:00:38 [vmmemctl]
root      1026   666  0 Jul20 ?        00:00:00 /sbin/udevd -d
root      1029     2  0 Jul20 ?        00:00:00 [kmpathd/0]
root      1030     2  0 Jul20 ?        00:00:00 [kmpathd/1]
root      1031     2  0 Jul20 ?        00:00:00 [kmpathd/2]
root      1032     2  0 Jul20 ?        00:00:00 [kmpathd/3]
root      1033     2  0 Jul20 ?        00:00:00 [kmpathd/4]
root      1034     2  0 Jul20 ?        00:00:00 [kmpathd/5]
root      1035     2  0 Jul20 ?        00:00:00 [kmpathd/6]
root      1036     2  0 Jul20 ?        00:00:00 [kmpathd/7]
root      1037     2  0 Jul20 ?        00:00:00 [kmpath_handlerd]
root      1043   666  0 Jul20 ?        00:00:00 /sbin/udevd -d
root      1044     2  0 Jul20 ?        00:00:00 [kdmflush]
root      1087     2  0 Jul20 ?        00:00:00 [kjournald]
root      1088     2  0 Jul20 ?        00:06:37 [jbd2/dm-2-8]
root      1089     2  0 Jul20 ?        00:00:00 [ext4-dio-unwrit]
root      1117     2  0 Jul20 ?        00:13:15 [flush-253:1]
root      1118     2  0 Jul20 ?        00:23:39 [flush-253:2]
root      1134     2  0 Jul20 ?        00:00:57 [kauditd]
root      1182     1  0 Jul20 ?        00:01:40 /sbin/multipathd
root      1492     1  0 Jul20 ?        00:25:55 /usr/sbin/vmtoolsd
root      1513     1  0 Jul20 ?        00:00:00 /usr/lib/vmware-vgauth/VGAuthService -s
root      1569     1  0 Jul20 ?        00:18:34 /usr/lib/vmware-caf/pme/bin/ManagementAgentHost
root      1625     1  0 Jul20 ?        00:02:47 auditd
root      1680     1  0 Jul20 ?        01:17:22 /sbin/rsyslogd -i /var/run/syslogd.pid -c 3 -x
root      1715     1  0 Jul20 ?        00:02:42 irqbalance --pid=/var/run/irqbalance.pid
rpc       1737     1  0 Jul20 ?        00:00:04 rpcbind
root      1755     1  0 Jul20 ?        00:02:02 /usr/sbin/sssd -f -D
root      1756  1755  0 Jul20 ?        00:04:09 /usr/libexec/sssd/sssd_be --domain AD --uid 0 --gid 0 --debug-to-files
root      1757  1755  0 Jul20 ?        00:01:32 /usr/libexec/sssd/sssd_nss --uid 0 --gid 0 --debug-to-files
root      1758  1755  0 Jul20 ?        00:00:43 /usr/libexec/sssd/sssd_pam --uid 0 --gid 0 --debug-to-files
root      1759  1755  0 Jul20 ?        00:00:43 /usr/libexec/sssd/sssd_sudo --uid 0 --gid 0 --debug-to-files
root      1760  1755  0 Jul20 ?        00:00:41 /usr/libexec/sssd/sssd_autofs --uid 0 --gid 0 --debug-to-files
rpcuser   1781     1  0 Jul20 ?        00:00:00 rpc.statd
root      1813     1  0 Jul20 ?        00:00:00 /opt/VRTSpbx/bin/pbx_exchange
dbus      1828     1  0 Jul20 ?        00:00:01 dbus-daemon --system
68        1848     1  0 Jul20 ?        00:00:23 hald
root      1849  1848  0 Jul20 ?        00:00:00 hald-runner
root      1881  1849  0 Jul20 ?        00:00:00 hald-addon-input: Listening on /dev/input/event2 /dev/input/event0
68        1905  1849  0 Jul20 ?        00:00:00 hald-addon-acpi: listening on acpi kernel interface /proc/acpi/event
root      1917     1  0 Jul20 ?        00:01:45 automount --pid-file /var/run/autofs.pid
nagios    2034     1  0 Jul20 ?        00:00:02 /usr/local/ncpa/ncpa_listener --start
root      2046     1  0 Jul20 ?        00:08:33 /usr/sbin/snmpd -LS0-4d -Lf /dev/null -p /var/run/snmpd.pid
root      2057     1  1 Jul20 ?        14:31:24 /usr/sbin/snmptrapd -tLsd -p /var/run/snmptrapd.pid
root      2095     1  0 Jul20 ?        00:00:01 /usr/sbin/sshd
root      2108     1  0 Jul20 ?        00:00:00 xinetd -stayalive -pidfile /var/run/xinetd.pid
ntp       2140     1  0 Jul20 ?        00:00:03 ntpd -u ntp:ntp -p /var/run/ntpd.pid -g
postgres  2175     1  0 Jul20 ?        00:06:26 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
root      2218     1  0 Jul20 ?        00:00:10 /usr/openv/netbackup/bin/vnetd -standalone
root      2221     1  0 Jul20 ?        00:00:12 /usr/openv/netbackup/bin/bpcd -standalone
postgres  2244  2175  0 Jul20 ?        00:01:09 postgres: logger process
postgres  2250  2175  0 Jul20 ?        00:06:12 postgres: writer process
postgres  2252  2175  0 Jul20 ?        00:04:43 postgres: wal writer process
postgres  2253  2175  0 Jul20 ?        00:02:35 postgres: autovacuum launcher process
postgres  2255  2175  0 Jul20 ?        00:06:26 postgres: stats collector process
root      2292     1  0 Jul20 ?        00:01:36 sendmail: accepting connections
smmsp     2309     1  0 Jul20 ?        00:00:06 sendmail: Queue runner@00:05:00 for /var/spool/clientmqueue
root      2337     1  0 Jul20 ?        00:00:00 /usr/sbin/abrtd
root      2347     1  0 Jul20 ?        00:03:10 abrt-dump-oops -d /var/spool/abrt -rwx /var/log/messages
root      2374     1  0 Jul20 ?        00:01:29 /usr/sbin/httpd
root      2386     1  0 Jul20 ?        00:02:28 crond
root      2468     1  0 Jul20 ?        01:20:43 splunkd -p 8089 start
root      2479  2468  0 Jul20 ?        00:00:00 [splunkd pid=2468] splunkd -p 8089 start [process-runner]
nagios    2488     1  0 Jul20 ?        00:05:03 /usr/local/nagios/bin/npcd -d -f /usr/local/nagios/etc/pnp/npcd.cfg
root      2555     1  0 Jul20 ?        01:24:55 python /usr/bin/goferd
root      2600     1  0 Jul20 ?        00:00:00 /usr/bin/rhsmcertd
ajaxterm  2666     1  0 Jul20 ?        00:13:16 python /usr/share/ajaxterm/ajaxterm.py --daemon --port=8022 --uid=ajaxterm
root      2936     1  0 Jul20 tty1     00:00:00 /sbin/mingetty /dev/tty1
root      2938     1  0 Jul20 tty2     00:00:00 /sbin/mingetty /dev/tty2
root      2940     1  0 Jul20 tty3     00:00:00 /sbin/mingetty /dev/tty3
root      2942     1  0 Jul20 tty4     00:00:00 /sbin/mingetty /dev/tty4
root      2944     1  0 Jul20 tty5     00:00:00 /sbin/mingetty /dev/tty5
root      2946     1  0 Jul20 tty6     00:00:00 /sbin/mingetty /dev/tty6
root      3853     2  0 Jul20 ?        00:00:00 [rpciod/0]
root      3854     2  0 Jul20 ?        00:00:00 [rpciod/1]
root      3855     2  0 Jul20 ?        00:00:00 [rpciod/2]
root      3856     2  0 Jul20 ?        00:00:00 [rpciod/3]
root      3857     2  0 Jul20 ?        00:00:00 [rpciod/4]
root      3858     2  0 Jul20 ?        00:00:00 [rpciod/5]
root      3859     2  0 Jul20 ?        00:00:00 [rpciod/6]
root      3860     2  0 Jul20 ?        00:00:00 [rpciod/7]
root      3862     2  0 Jul20 ?        00:00:00 [kslowd000]
root      3863     2  0 Jul20 ?        00:00:00 [kslowd001]
root      3864     2  0 Jul20 ?        00:00:00 [nfsiod]
nagios    8942     1  0 Sep13 ?        00:00:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
apache    9980  2374  0 11:45 ?        00:00:31 /usr/sbin/httpd
postgres 10002  2175  0 11:45 ?        00:00:00 postgres: nagiosxi nagiosxi 127.0.0.1(60704) idle
apache   12040  2374  0 Sep13 ?        00:03:02 /usr/sbin/httpd
postgres 12109  2175  0 Sep13 ?        00:00:02 postgres: nagiosxi nagiosxi 127.0.0.1(56546) idle
root     15003     1  0 Sep10 ?        00:04:34 /usr/bin/ruby /usr/bin/puppet agent
root     20124  2095  0 11:31 ?        00:00:00 sshd: ahellin [priv]
ahellin  20287 20124  0 11:31 ?        00:00:00 sshd: ahellin@pts/1
ahellin  20294 20287  0 11:31 pts/1    00:00:00 -bash
root     21653  2386  0 00:05 ?        00:00:00 CROND
root     21662 21653  0 00:05 ?        00:00:00 /bin/bash /opt/admin/bin/statmon.sh
root     21689 21662  0 00:05 ?        00:00:01 /usr/bin/iostat -t -x 15
root     21692 21662  0 00:05 ?        00:00:00 /usr/bin/mpstat -P ALL 15
root     21696 21662  0 00:05 ?        00:00:00 /bin/bash /opt/admin/bin/statmon.sh
root     21701 21662  0 00:05 ?        00:00:02 /bin/bash /opt/admin/bin/statmon.sh
nagios   22541     1  0 14:39 ?        00:00:00 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
nagios   22573 22541  0 14:39 ?        00:00:00 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
root     22597     1  0 14:39 ?        00:00:00 /usr/bin/perl /usr/sbin/snmptt --daemon
snmptt   22598 22597  3 14:39 ?        00:00:06 /usr/bin/perl /usr/sbin/snmptt --daemon
root     23479  2386  0 14:40 ?        00:00:00 CROND
nagios   23495 23479  0 14:40 ?        00:00:00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/dbmaint.php >> /usr/local/nagiosxi/var/dbmaint.log 2>&1
nagios   23503 23495  0 14:40 ?        00:00:00 /usr/bin/php -q /usr/local/nagiosxi/cron/dbmaint.php
postgres 23525  2175  0 14:40 ?        00:00:00 postgres: nagiosxi nagiosxi 127.0.0.1(54488) idle
root     23531  2095  0 11:14 ?        00:00:00 sshd: ahellin [priv]
root     23669     2  0 11:14 ?        00:00:00 [lockd]
ahellin  23675 23531  0 11:14 ?        00:00:00 sshd: ahellin@pts/0
ahellin  23677 23675  0 11:14 pts/0    00:00:00 -bash
root     23737 23677  0 11:14 pts/0    00:00:00 sudo su -
nagios   24352 22541  0 14:40 ?        00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   24353 22541  0 14:40 ?        00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   24354 22541  0 14:40 ?        00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   24355 22541  0 14:40 ?        00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   24356 22541  0 14:40 ?        00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   24357 22541  0 14:40 ?        00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   24358 22541  0 14:40 ?        00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   24359 22541  0 14:40 ?        00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   24360 22541  0 14:40 ?        00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   24361 22541  0 14:40 ?        00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   24362 22541  0 14:40 ?        00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   24363 22541  0 14:40 ?        00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   24364  8942  0 14:40 ?        00:00:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
nagios   24365 24364  0 14:40 ?        00:00:01 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
root     24458 20294  0 11:33 pts/1    00:00:00 sudo su -
root     24493 24458  0 11:33 pts/1    00:00:00 su -
root     24494 24493  0 11:33 pts/1    00:00:00 -bash
apache   24739  2374  0 11:33 ?        00:00:57 /usr/sbin/httpd
postgres 24881  2175  0 11:34 ?        00:00:01 postgres: nagiosxi nagiosxi 127.0.0.1(57800) idle
apache   25081  2374  0 11:34 ?        00:00:56 /usr/sbin/httpd
root     25154 23677  0 11:15 pts/0    00:00:00 sudo su -
root     25155 25154  0 11:15 pts/0    00:00:00 su -
root     25156 25155  0 11:15 pts/0    00:00:00 -bash
postgres 25217  2175  0 11:34 ?        00:00:00 postgres: nagiosxi nagiosxi 127.0.0.1(57868) idle
apache   25502  2374  0 11:34 ?        00:00:56 /usr/sbin/httpd
postgres 25517  2175  0 11:34 ?        00:00:01 postgres: nagiosxi nagiosxi 127.0.0.1(57922) idle
apache   26586  2374  0 10:43 ?        00:01:10 /usr/sbin/httpd
apache   26917  2374  0 11:35 ?        00:00:54 /usr/sbin/httpd
postgres 26996  2175  0 11:35 ?        00:00:00 postgres: nagiosxi nagiosxi 127.0.0.1(58170) idle
root     27298  2386  0 14:42 ?        00:00:00 CROND
root     27299  2386  0 14:42 ?        00:00:00 CROND
root     27301  2386  0 14:42 ?        00:00:00 CROND
root     27302  2386  0 14:42 ?        00:00:00 CROND
root     27303  2386  0 14:42 ?        00:00:00 CROND
nagios   27305 27301  0 14:42 ?        00:00:00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/eventman.php >> /usr/local/nagiosxi/var/eventman.log 2>&1
nagios   27307 27298  0 14:42 ?        00:00:00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/perfdataproc.php >> /usr/local/nagiosxi/var/perfdataproc.log 2>&1
nagios   27308 27299  0 14:42 ?        00:00:00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/feedproc.php >> /usr/local/nagiosxi/var/feedproc.log 2>&1
nagios   27311 27305  0 14:42 ?        00:00:00 /usr/bin/php -q /usr/local/nagiosxi/cron/eventman.php
nagios   27313 27307  0 14:42 ?        00:00:00 /usr/bin/php -q /usr/local/nagiosxi/cron/perfdataproc.php
nagios   27315 27302  0 14:42 ?        00:00:00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/cmdsubsys.php >> /usr/local/nagiosxi/var/cmdsubsys.log 2>&1
nagios   27316 27303  0 14:42 ?        00:00:00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/sysstat.php >> /usr/local/nagiosxi/var/sysstat.log 2>&1
nagios   27319 27308  0 14:42 ?        00:00:00 /usr/bin/php -q /usr/local/nagiosxi/cron/feedproc.php
nagios   27322 27316  0 14:42 ?        00:00:00 /usr/bin/php -q /usr/local/nagiosxi/cron/sysstat.php
nagios   27324 27315  0 14:42 ?        00:00:00 /usr/bin/php -q /usr/local/nagiosxi/cron/cmdsubsys.php
postgres 27339  2175  0 14:42 ?        00:00:00 postgres: nagiosxi nagiosxi 127.0.0.1(54784) idle
postgres 27340  2175  0 14:42 ?        00:00:00 postgres: nagiosxi nagiosxi 127.0.0.1(54788) idle
postgres 27343  2175  0 14:42 ?        00:00:00 postgres: nagiosxi nagiosxi 127.0.0.1(54790) idle
postgres 27350  2175  0 14:42 ?        00:00:00 postgres: nagiosxi nagiosxi 127.0.0.1(54812) idle
postgres 27357  2175  0 14:42 ?        00:00:00 postgres: nagiosxi nagiosxi 127.0.0.1(54824) idle
apache   27385  2374  0 10:44 ?        00:00:38 /usr/sbin/httpd
postgres 27664  2175  0 10:44 ?        00:00:00 postgres: nagiosxi nagiosxi 127.0.0.1(51398) idle
postgres 27713  2175  0 10:44 ?        00:00:01 postgres: nagiosxi nagiosxi 127.0.0.1(51404) idle
root     27794 21696  0 14:42 ?        00:00:00 sleep 60
apache   28846  2374  0 11:36 ?        00:00:48 /usr/sbin/httpd
postgres 28880  2175  0 11:36 ?        00:00:00 postgres: nagiosxi nagiosxi 127.0.0.1(58512) idle
root     28896 21701  0 14:42 ?        00:00:00 vmstat 15 2
root     28897 21701  0 14:42 ?        00:00:00 tail -1
apache   28969  2374  0 10:45 ?        00:00:40 /usr/sbin/httpd
postgres 29043  2175  0 10:45 ?        00:00:00 postgres: nagiosxi nagiosxi 127.0.0.1(51558) idle
root     29098 24494  0 14:43 pts/1    00:00:00 ps -ef --cols=300
You do not have the required permissions to view the files attached to this post.
Last edited by tmcdonald on Tue Sep 19, 2017 10:16 am, edited 1 time in total.
Reason: Please use [code][/code] tags around long output
Top
dwhitfield
Former Nagios Staff
Posts: 4583
Joined: Wed Sep 21, 2016 10:29 am
Location: NoLo, Minneapolis, MN
Contact:
Contact dwhitfield

Re: Applying Configuration deletes all services

Post by dwhitfield »

Please attached your /etc/sudoers. Also, what is the output of sestatus?

Can you PM me your Profile? You can download it by going to Admin > System Config > System Profile and click the ***Download Profile*** button towards the top. If for whatever reason you *cannot* download the profile, please put the output of View System Info (5.3.4+, Show Profile if older) in the thread (that will at least get us some info). This will give us access to many of the logs we would otherwise ask for individually. If security is a concern, you can unzip the profile take out what you like, and then zip it up again. We may end up needing something you remove, but we can ask for that specifically.

You can also generate a profile manually using the script at /usr/local/nagiosxi/html/includes/components/profile/getprofile.sh

That should generate a profile in /usr/local/nagiosxi/var/components/ which you can get off the server with an application such as FileZilla.

After you PM the profile, please update this thread. Updating this thread is the only way for it to show back up on our dashboard.

UPDATE: profile shared with techs
Last edited by dwhitfield on Fri Sep 15, 2017 12:03 pm, edited 1 time in total.
Reason: pm received
Top
vistate
Posts: 11
Joined: Tue Aug 22, 2017 10:55 am

Re: Applying Configuration deletes all services

Post by vistate »

Output of sudoers:

[ahellin@sq5vrlngs001 ~]$ sudo su -
[sudo] password for ahellin:
[Fri Sep 15 09:51:24] root@sq5vrlngs001:~# cat /etc/sudoers\
> ^C
[Fri Sep 15 09:51:29] root@sq5vrlngs001:~# cat /etc/sudoers

Code: Select all

## Sudoers allows particular users to run various commands as
## the root user, without needing the root password.
##
## Examples are provided at the bottom of the file for collections
## of related commands, which can then be delegated out to particular
## users or groups.
##
## This file must be edited with the 'visudo' command.

## Host Aliases
## Groups of machines. You may prefer to use hostnames (perhap using
## wildcards for entire domains) or IP addresses instead.
# Host_Alias     FILESERVERS = fs1, fs2
# Host_Alias     MAILSERVERS = smtp, smtp2

## User Aliases
## These aren't often necessary, as you can use regular groups
## (ie, from files, LDAP, NIS, etc) in this file - just use %groupname
## rather than USERALIAS
# User_Alias ADMINS = jsmith, mikem


## Command Aliases
## These are groups of related commands...

## Networking
#Cmnd_Alias NETWORKING = /sbin/route, /sbin/ifconfig, /bin/ping, /sbin/dhclient, /usr/bin/net, /sbin/iptables, /usr/bin/rfcomm, /usr/bin/wvdial, /sbin/iwconfig, /sbin/mii-tool

## Installation and management of software
#Cmnd_Alias SOFTWARE = /bin/rpm, /usr/bin/up2date, /usr/bin/yum

## Services
#Cmnd_Alias SERVICES = /sbin/service, /sbin/chkconfig

## Updating the locate database
#Cmnd_Alias LOCATE = /usr/bin/updatedb

## Storage
#Cmnd_Alias STORAGE = /sbin/fdisk, /sbin/sfdisk, /sbin/parted, /sbin/partprobe, /bin/mount, /bin/umount

## Delegating permissions
#Cmnd_Alias DELEGATING = /usr/sbin/visudo, /bin/chown, /bin/chmod, /bin/chgrp

## Processes
#Cmnd_Alias PROCESSES = /bin/nice, /bin/kill, /usr/bin/kill, /usr/bin/killall

## Drivers
#Cmnd_Alias DRIVERS = /sbin/modprobe
# Defaults specification

#
# Disable "ssh hostname sudo <cmd>", because it will show the password in clear.
#         You have to run "ssh -t hostname sudo <cmd>".
#
# ###########Defaults    requiretty

Defaults !requiretty

Defaults    env_reset
Defaults    env_keep = "COLORS DISPLAY HOSTNAME HISTSIZE INPUTRC KDEDIR \
                        LS_COLORS MAIL PS1 PS2 QTDIR USERNAME \
                        LANG LC_ADDRESS LC_CTYPE LC_COLLATE LC_IDENTIFICATION \
                        LC_MEASUREMENT LC_MESSAGES LC_MONETARY LC_NAME LC_NUMERIC \
                        LC_PAPER LC_TELEPHONE LC_TIME LC_ALL LANGUAGE LINGUAS \
                        _XKB_CHARSET XAUTHORITY"

## Next comes the main part: which users can run what software on
## which machines (the sudoers file can be shared between multiple
## systems).
## Syntax:
##
##      user    MACHINE=COMMANDS
##
## The COMMANDS section may have other options added to it.
##
## Allow root to run any commands anywhere
root    ALL=(ALL)       ALL

## Allows members of the 'sys' group to run networking, software,
## service management apps and more.
# %sys ALL = NETWORKING, SOFTWARE, SERVICES, STORAGE, DELEGATING, PROCESSES, LOCATE, DRIVERS

## Allows people in group wheel to run all commands
# %wheel        ALL=(ALL)       ALL

## Same thing without a password
# %wheel        ALL=(ALL)       NOPASSWD: ALL

## Allows members of the users group to mount and unmount the
## cdrom as root
# %users  ALL=/sbin/mount /mnt/cdrom, /sbin/umount /mnt/cdrom

## Allows members of the users group to shutdown this system
# %users  localhost=/sbin/shutdown -h now


#sybasease       ALL=(ALL)       ALL
#sybase          ALL=(ALL)       ALL
#uber            ALL=(ALL)       NOPASSWD: ALL


# The following entries were added by hp-smh-templates at
#      Mon Nov 22 23:38:32 EST 2010
# WARNING! Any changes between here and the END marker are managed by hp-health
# and maybe automatically removed.
%hpsmh ALL=NOPASSWD:/etc/init.d/snmpd
%hpsmh ALL=NOPASSWD:/usr/bin/snmptrap
# ---------------------- END --------------------




User_Alias      NAGIOSXI=nagios
User_Alias              NAGIOSXIWEB=apache
NAGIOSXI ALL = NOPASSWD:/etc/init.d/nagios start
NAGIOSXI ALL = NOPASSWD:/etc/init.d/nagios stop
NAGIOSXI ALL = NOPASSWD:/etc/init.d/nagios restart
NAGIOSXI ALL = NOPASSWD:/etc/init.d/nagios reload
NAGIOSXI ALL = NOPASSWD:/etc/init.d/nagios status
NAGIOSXI ALL = NOPASSWD:/etc/init.d/nagios checkconfig
NAGIOSXI ALL = NOPASSWD:/etc/init.d/ndo2db start
NAGIOSXI ALL = NOPASSWD:/etc/init.d/ndo2db stop
NAGIOSXI ALL = NOPASSWD:/etc/init.d/ndo2db restart
NAGIOSXI ALL = NOPASSWD:/etc/init.d/ndo2db reload
NAGIOSXI ALL = NOPASSWD:/etc/init.d/ndo2db status
NAGIOSXI ALL = NOPASSWD:/etc/init.d/npcd start
NAGIOSXI ALL = NOPASSWD:/etc/init.d/npcd stop
NAGIOSXI ALL = NOPASSWD:/etc/init.d/npcd restart
NAGIOSXI ALL = NOPASSWD:/etc/init.d/npcd reload
NAGIOSXI ALL = NOPASSWD:/etc/init.d/npcd status
NAGIOSXI ALL = NOPASSWD:/usr/bin/php /usr/local/nagiosxi/html/includes/components/autodiscovery/scripts/autodiscover_new.php *
NAGIOSXI ALL = NOPASSWD:/usr/local/nagiosxi/html/includes/components/profile/getprofile.sh
NAGIOSXI ALL = NOPASSWD:/usr/local/nagiosxi/scripts/upgrade_to_latest.sh
NAGIOSXI ALL = NOPASSWD:/usr/local/nagiosxi/scripts/change_timezone.sh
NAGIOSXI ALL = NOPASSWD:/usr/local/nagiosxi/scripts/manage_services.sh *
NAGIOSXI ALL = NOPASSWD:/usr/local/nagiosxi/scripts/reset_config_perms.sh
NAGIOSXI ALL = NOPASSWD:/usr/local/nagiosxi/scripts/backup_xi.sh *
NAGIOSXIWEB ALL = NOPASSWD:/usr/bin/tail -100 /var/log/messages
NAGIOSXIWEB ALL = NOPASSWD:/usr/bin/tail -100 /var/log/httpd/error_log
NAGIOSXIWEB ALL = NOPASSWD:/usr/bin/tail -100 /var/log/mysqld.log
NAGIOSXIWEB ALL = NOPASSWD:/usr/bin/php /usr/local/nagiosxi/html/includes/components/autodiscovery/scripts/autodiscover_new.php *
NAGIOSXIWEB ALL = NOPASSWD:/usr/local/nagiosxi/html/includes/components/profile/getprofile.sh
NAGIOSXIWEB ALL = NOPASSWD:/etc/init.d/snmptt restart
NAGIOSXIWEB ALL = NOPASSWD:/usr/local/nagiosxi/scripts/repair_databases.sh
NAGIOSXIWEB ALL = NOPASSWD:/usr/local/nagiosxi/scripts/manage_services.sh *

I will DM you the profile.
Last edited by dwhitfield on Mon Sep 18, 2017 9:12 am, edited 1 time in total.
Reason: code blocks FTW
Top
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Applying Configuration deletes all services

Post by tgriep »

Thanks for the Profile.
I see that the MYSQL database is offloaded to a remote server and if the service table is corrupted on that server, it could cause the issue you are having so if you can someone run a repair on the server for you you you can use the example command and run it from the XI server.

Code: Select all

mysqlcheck -f -r -u nagiosql -pnagios --database nagiosql -h xxx.xxx.xxx.xxx
Replace xxx.xxx.xxx.xxx with the IP address of the MYSQL server.

If that doesn't fix it, cam you email in the MYSQL server config files?
We would need to see the /etc/my.cnf file and the contents of the /etc/my.cnf.d folder if it exists.

I also found this setting in the nagios.cfg file

Code: Select all

cfg_dir=/usr/local/nagios/etc/cisco/ucsObjs
If those checks are static and never changing, try putting them in the /usr/local/nagios/etc/static folder and remove that entry from the nagios.cfg file.
That will remove the chance of one of those checks conflicting with one in the CCM and causing the services to not be written.
Let us know if this fixes the issue.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Top
vistate
Posts: 11
Joined: Tue Aug 22, 2017 10:55 am

Re: Applying Configuration deletes all services

Post by vistate »

Hi I Have PM'd you the mysql configs.
I ran the mysql repair command as requested. There were some errors i will attach output. However nagios.services table was OK.

I have removed the cisco service checks from the nagios.cfg - no difference.

Code: Select all

[root@sq5vrlmysql001 ~]# mysqlcheck -f -r -u nagiosql --all-databases
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.engine_cost
note     : The storage engine for the table doesn't support repair
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.gtid_executed
Warning  : Please do not modify the gtid_executed table. This is a mysql internal system table to store GTIDs for committed transactions. Modifying it can lead to an inconsistent GTID state.
note     : The storage engine for the table doesn't support repair
mysql.help_category
note     : The storage engine for the table doesn't support repair
mysql.help_keyword
note     : The storage engine for the table doesn't support repair
mysql.help_relation
note     : The storage engine for the table doesn't support repair
mysql.help_topic
note     : The storage engine for the table doesn't support repair
mysql.host                                         OK
mysql.innodb_index_stats
note     : The storage engine for the table doesn't support repair
mysql.innodb_table_stats
note     : The storage engine for the table doesn't support repair
mysql.ndb_binlog_index                             OK
mysql.plugin
note     : The storage engine for the table doesn't support repair
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.server_cost
note     : The storage engine for the table doesn't support repair
mysql.servers
note     : The storage engine for the table doesn't support repair
mysql.slave_master_info
note     : The storage engine for the table doesn't support repair
mysql.slave_relay_log_info
note     : The storage engine for the table doesn't support repair
mysql.slave_worker_info
note     : The storage engine for the table doesn't support repair
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone
note     : The storage engine for the table doesn't support repair
mysql.time_zone_leap_second
note     : The storage engine for the table doesn't support repair
mysql.time_zone_name
note     : The storage engine for the table doesn't support repair
mysql.time_zone_transition
note     : The storage engine for the table doesn't support repair
mysql.time_zone_transition_type
note     : The storage engine for the table doesn't support repair
mysql.user                                         OK
nagios.nagios_acknowledgements                     OK
nagios.nagios_commands                             OK
nagios.nagios_commenthistory                       OK
nagios.nagios_comments                             OK
nagios.nagios_configfiles                          OK
nagios.nagios_configfilevariables                  OK
nagios.nagios_conninfo                             OK
nagios.nagios_contact_addresses                    OK
nagios.nagios_contact_notificationcommands         OK
nagios.nagios_contactgroup_members                 OK
nagios.nagios_contactgroups                        OK
nagios.nagios_contactnotificationmethods           OK
nagios.nagios_contactnotifications                 OK
nagios.nagios_contacts                             OK
nagios.nagios_contactstatus                        OK
nagios.nagios_customvariables                      OK
nagios.nagios_customvariablestatus                 OK
nagios.nagios_dbversion                            OK
nagios.nagios_downtimehistory                      OK
nagios.nagios_eventhandlers                        OK
nagios.nagios_externalcommands                     OK
nagios.nagios_flappinghistory                      OK
nagios.nagios_host_contactgroups                   OK
nagios.nagios_host_contacts                        OK
nagios.nagios_host_parenthosts                     OK
nagios.nagios_hostchecks                           OK
nagios.nagios_hostdependencies                     OK
nagios.nagios_hostescalation_contactgroups         OK
nagios.nagios_hostescalation_contacts              OK
nagios.nagios_hostescalations                      OK
nagios.nagios_hostgroup_members                    OK
nagios.nagios_hostgroups                           OK
nagios.nagios_hosts                                OK
nagios.nagios_hoststatus                           OK
nagios.nagios_instances                            OK
nagios.nagios_logentries
Note     : TIME/TIMESTAMP/DATETIME columns of old format have been upgraded to the new format.
Warning  : Incorrect datetime value: '0000-00-00 00:00:00' for column 'logentry_time' at row 1
Error    : Invalid default value for 'logentry_time'
status   : Operation failed
nagios.nagios_notifications
Note     : TIME/TIMESTAMP/DATETIME columns of old format have been upgraded to the new format.
Warning  : Incorrect datetime value: '0000-00-00 00:00:00' for column 'start_time' at row 1
Error    : Invalid default value for 'start_time'
status   : Operation failed
nagios.nagios_objects                              OK
nagios.nagios_processevents
Note     : TIME/TIMESTAMP/DATETIME columns of old format have been upgraded to the new format.
Warning  : Incorrect datetime value: '0000-00-00 00:00:00' for column 'event_time' at row 1
Error    : Invalid default value for 'event_time'
status   : Operation failed
nagios.nagios_programstatus
Note     : TIME/TIMESTAMP/DATETIME columns of old format have been upgraded to the new format.
Warning  : Incorrect datetime value: '0000-00-00 00:00:00' for column 'status_update_time' at row 1
Error    : Invalid default value for 'status_update_time'
status   : Operation failed
nagios.nagios_runtimevariables                     OK
nagios.nagios_scheduleddowntime
Note     : TIME/TIMESTAMP/DATETIME columns of old format have been upgraded to the new format.
Warning  : Incorrect datetime value: '0000-00-00 00:00:00' for column 'entry_time' at row 1
Error    : Invalid default value for 'entry_time'
status   : Operation failed
nagios.nagios_service_contactgroups                OK
nagios.nagios_service_contacts                     OK
nagios.nagios_service_parentservices               OK
nagios.nagios_servicechecks
Note     : TIME/TIMESTAMP/DATETIME columns of old format have been upgraded to the new format.
Warning  : Incorrect datetime value: '0000-00-00 00:00:00' for column 'start_time' at row 1
Error    : Invalid default value for 'start_time'
status   : Operation failed
nagios.nagios_servicedependencies                  OK
nagios.nagios_serviceescalation_contactgroups      OK
nagios.nagios_serviceescalation_contacts           OK
nagios.nagios_serviceescalations                   OK
nagios.nagios_servicegroup_members                 OK
nagios.nagios_servicegroups                        OK
nagios.nagios_services                             OK
nagios.nagios_servicestatus
Note     : TIME/TIMESTAMP/DATETIME columns of old format have been upgraded to the new format.
Warning  : Incorrect datetime value: '0000-00-00 00:00:00' for column 'status_update_time' at row 1
Error    : Invalid default value for 'status_update_time'
status   : Operation failed
nagios.nagios_statehistory
Note     : TIME/TIMESTAMP/DATETIME columns of old format have been upgraded to the new format.
Warning  : Incorrect datetime value: '0000-00-00 00:00:00' for column 'state_time' at row 1
Error    : Invalid default value for 'state_time'
status   : Operation failed
nagios.nagios_systemcommands
Note     : TIME/TIMESTAMP/DATETIME columns of old format have been upgraded to the new format.
Warning  : Incorrect datetime value: '0000-00-00 00:00:00' for column 'start_time' at row 1
Error    : Invalid default value for 'start_time'
status   : Operation failed
nagios.nagios_timedeventqueue
Note     : TIME/TIMESTAMP/DATETIME columns of old format have been upgraded to the new format.
Warning  : Incorrect datetime value: '0000-00-00 00:00:00' for column 'queued_time' at row 1
Error    : Invalid default value for 'queued_time'
status   : Operation failed
nagios.nagios_timedevents
Note     : TIME/TIMESTAMP/DATETIME columns of old format have been upgraded to the new format.
Warning  : Incorrect datetime value: '0000-00-00 00:00:00' for column 'queued_time' at row 1
Error    : Invalid default value for 'queued_time'
status   : Operation failed
nagios.nagios_timeperiod_timeranges                OK
nagios.nagios_timeperiods                          OK
nagiosql.tbl_command                               OK
nagiosql.tbl_contact                               OK
nagiosql.tbl_contactgroup                          OK
nagiosql.tbl_contacttemplate                       OK
nagiosql.tbl_domain                                OK
nagiosql.tbl_host                                  OK
nagiosql.tbl_hostdependency                        OK
nagiosql.tbl_hostescalation                        OK
nagiosql.tbl_hostextinfo                           OK
nagiosql.tbl_hostgroup                             OK
nagiosql.tbl_hosttemplate                          OK
nagiosql.tbl_info                                  OK
nagiosql.tbl_lnkContactToCommandHost               OK
nagiosql.tbl_lnkContactToCommandService            OK
nagiosql.tbl_lnkContactToContactgroup              OK
nagiosql.tbl_lnkContactToContacttemplate           OK
nagiosql.tbl_lnkContactToVariabledefinition        OK
nagiosql.tbl_lnkContactgroupToContact              OK
nagiosql.tbl_lnkContactgroupToContactgroup         OK
nagiosql.tbl_lnkContacttemplateToCommandHost       OK
nagiosql.tbl_lnkContacttemplateToCommandService    OK
nagiosql.tbl_lnkContacttemplateToContactgroup      OK
nagiosql.tbl_lnkContacttemplateToContacttemplate   OK
nagiosql.tbl_lnkContacttemplateToVariabledefinition OK
nagiosql.tbl_lnkHostToContact                      OK
nagiosql.tbl_lnkHostToContactgroup                 OK
nagiosql.tbl_lnkHostToHost                         OK
nagiosql.tbl_lnkHostToHostgroup                    OK
nagiosql.tbl_lnkHostToHosttemplate                 OK
nagiosql.tbl_lnkHostToVariabledefinition           OK
nagiosql.tbl_lnkHostdependencyToHost_DH            OK
nagiosql.tbl_lnkHostdependencyToHost_H             OK
nagiosql.tbl_lnkHostdependencyToHostgroup_DH       OK
nagiosql.tbl_lnkHostdependencyToHostgroup_H        OK
nagiosql.tbl_lnkHostescalationToContact            OK
nagiosql.tbl_lnkHostescalationToContactgroup       OK
nagiosql.tbl_lnkHostescalationToHost               OK
nagiosql.tbl_lnkHostescalationToHostgroup          OK
nagiosql.tbl_lnkHostgroupToHost                    OK
nagiosql.tbl_lnkHostgroupToHostgroup               OK
nagiosql.tbl_lnkHosttemplateToContact              OK
nagiosql.tbl_lnkHosttemplateToContactgroup         OK
nagiosql.tbl_lnkHosttemplateToHost                 OK
nagiosql.tbl_lnkHosttemplateToHostgroup            OK
nagiosql.tbl_lnkHosttemplateToHosttemplate         OK
nagiosql.tbl_lnkHosttemplateToVariabledefinition   OK
nagiosql.tbl_lnkServiceToContact                   OK
nagiosql.tbl_lnkServiceToContactgroup              OK
nagiosql.tbl_lnkServiceToHost                      OK
nagiosql.tbl_lnkServiceToHostgroup                 OK
nagiosql.tbl_lnkServiceToServicegroup              OK
nagiosql.tbl_lnkServiceToServicetemplate           OK
nagiosql.tbl_lnkServiceToVariabledefinition        OK
nagiosql.tbl_lnkServicedependencyToHost_DH         OK
nagiosql.tbl_lnkServicedependencyToHost_H          OK
nagiosql.tbl_lnkServicedependencyToHostgroup_DH    OK
nagiosql.tbl_lnkServicedependencyToHostgroup_H     OK
nagiosql.tbl_lnkServicedependencyToService_DS      OK
nagiosql.tbl_lnkServicedependencyToService_S       OK
nagiosql.tbl_lnkServiceescalationToContact         OK
nagiosql.tbl_lnkServiceescalationToContactgroup    OK
nagiosql.tbl_lnkServiceescalationToHost            OK
nagiosql.tbl_lnkServiceescalationToHostgroup       OK
nagiosql.tbl_lnkServiceescalationToService         OK
nagiosql.tbl_lnkServicegroupToService              OK
nagiosql.tbl_lnkServicegroupToServicegroup         OK
nagiosql.tbl_lnkServicetemplateToContact           OK
nagiosql.tbl_lnkServicetemplateToContactgroup      OK
nagiosql.tbl_lnkServicetemplateToHost              OK
nagiosql.tbl_lnkServicetemplateToHostgroup         OK
nagiosql.tbl_lnkServicetemplateToServicegroup      OK
nagiosql.tbl_lnkServicetemplateToServicetemplate   OK
nagiosql.tbl_lnkServicetemplateToVariabledefinition OK
nagiosql.tbl_lnkTimeperiodToTimeperiod             OK
nagiosql.tbl_logbook                               OK
nagiosql.tbl_mainmenu                              OK
nagiosql.tbl_service                               OK
nagiosql.tbl_servicedependency                     OK
nagiosql.tbl_serviceescalation                     OK
nagiosql.tbl_serviceextinfo                        OK
nagiosql.tbl_servicegroup                          OK
nagiosql.tbl_servicetemplate                       OK
nagiosql.tbl_session                               OK
nagiosql.tbl_session_locks                         OK
nagiosql.tbl_settings                              OK
nagiosql.tbl_submenu                               OK
nagiosql.tbl_timedefinition                        OK
nagiosql.tbl_timeperiod                            OK
nagiosql.tbl_user                                  OK
nagiosql.tbl_variabledefinition                    OK
snmptt.filter                                      OK
snmptt.filter_atom                                 OK
snmptt.snmptt                                      OK
snmptt.snmptt_archive                              OK
snmptt.snmptt_statistics                           OK
snmptt.snmptt_unknown                              OK
sys.sys_config
note     : The storage engine for the table doesn't support repair
Last edited by tmcdonald on Tue Sep 19, 2017 10:17 am, edited 1 time in total.
Reason: Please use [code][/code] tags around long output
Top
Locked

Return to “Nagios XI”