Configuration changes will not apply

[spperry]

I've found a few posts that references this or a similar issue, but none of the solutions provided have helped with the issue. We have outstanding changes that need to apply within Nagios XI/Core. When we click apply, we get to "Waiting to confirm configuration...." and it spins into oblivion and adds dots. I'm new to this product (our Nagios admin left and I took it over), so I'm looking for support on what to check in relation to this.

This describes, at least in the problem description, what is happening:
https://support.nagios.com/kb/article.php?id=34

However, the solution provided does not resolve anything. The system is working as a whole - we're getting alerts for existing services and hosts, so it's just the application of the configuration that isn't working as expected.

Any assistance would be greatly appreciated.

Thanks!
Scott

[npolovenko]

Hello, @spperry.

Please run this command first:

Code: Select all

rm -f /usr/local/nagiosxi/scripts/reconfigure_nagios.lock

Then run the manual reconfigure script and post the output here:

Code: Select all

/usr/local/nagiosxi/scripts/reconfigure_nagios.sh

[spperry]

Here is the requested output:

URL: http://localhost/nagiosxi/includes/components/ccm/
CMDLINE
/usr/bin/wget --save-cookies nagiosql.cookies --keep-session-cookies http://localhost/nagiosxi/includes/components/ccm/ --no-check-certificate --post-data 'submit=Login&hidelog=true&loginSubmitted=true&backend=1&username=nagiosxi&password=******' -O nagiosql.login--2018-06-01 16:01:52-- http://localhost/nagiosxi/includes/components/ccm/
Resolving localhost... ::1, 127.0.0.1
Connecting to localhost|::1|:80... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://localhost/nagiosxi/includes/components/ccm/ [following]
--2018-06-01 16:01:52-- https://localhost/nagiosxi/includes/components/ccm/
Connecting to localhost|::1|:443... connected.
WARNING: no certificate subject alternative name matches
requested host name “localhost”.
HTTP request sent, awaiting response... 302 Found
Location: https://localhost/nagiosxi/login.php?re ... f&noauth=1 [following]
--2018-06-01 16:01:53-- https://localhost/nagiosxi/login.php?re ... f&noauth=1
Connecting to localhost|::1|:443... connected.
WARNING: no certificate subject alternative name matches
requested host name “localhost”.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
Saving to: “nagiosql.login”

[ <=> ] 26,067 --.-K/s in 0.04s

2018-06-01 16:01:53 (653 KB/s) - “nagiosql.login” saved [26067]

NAGIOSQL LOGIN FAILED!


I'm assuming the NAGIOSQL LOGIN FAILED is a bad thing. I did the reset of the sudoers as mentioned in the article I posted, so I'm confident on that being okay. This seems to have started last Thursday/Friday, but nobody mentioned it until today. No major changes were made to the system, though, just regular monitoring and service/host configuration.

[npolovenko]

@spperry, Can you post the output of the following command:

Code: Select all

echo "show tables;" |    mysql -unagiosql -pn@gweb nagiosql

[spperry]

Hi, thanks, sorry for the delayed response. This is the output:

Tables_in_nagiosql
tbl_command
tbl_contact
tbl_contactgroup
tbl_contacttemplate
tbl_domain
tbl_host
tbl_hostdependency
tbl_hostescalation
tbl_hostextinfo
tbl_hostgroup
tbl_hosttemplate
tbl_info
tbl_lnkContactToCommandHost
tbl_lnkContactToCommandService
tbl_lnkContactToContactgroup
tbl_lnkContactToContacttemplate
tbl_lnkContactToVariabledefinition
tbl_lnkContactgroupToContact
tbl_lnkContactgroupToContactgroup
tbl_lnkContacttemplateToCommandHost
tbl_lnkContacttemplateToCommandService
tbl_lnkContacttemplateToContactgroup
tbl_lnkContacttemplateToContacttemplate
tbl_lnkContacttemplateToVariabledefinition
tbl_lnkHostToContact
tbl_lnkHostToContactgroup
tbl_lnkHostToHost
tbl_lnkHostToHostgroup
tbl_lnkHostToHosttemplate
tbl_lnkHostToVariabledefinition
tbl_lnkHostdependencyToHost_DH
tbl_lnkHostdependencyToHost_H
tbl_lnkHostdependencyToHostgroup_DH
tbl_lnkHostdependencyToHostgroup_H
tbl_lnkHostescalationToContact
tbl_lnkHostescalationToContactgroup
tbl_lnkHostescalationToHost
tbl_lnkHostescalationToHostgroup
tbl_lnkHostgroupToHost
tbl_lnkHostgroupToHostgroup
tbl_lnkHosttemplateToContact
tbl_lnkHosttemplateToContactgroup
tbl_lnkHosttemplateToHost
tbl_lnkHosttemplateToHostgroup
tbl_lnkHosttemplateToHosttemplate
tbl_lnkHosttemplateToVariabledefinition
tbl_lnkServiceToContact
tbl_lnkServiceToContactgroup
tbl_lnkServiceToHost
tbl_lnkServiceToHostgroup
tbl_lnkServiceToServicegroup
tbl_lnkServiceToServicetemplate
tbl_lnkServiceToVariabledefinition
tbl_lnkServicedependencyToHost_DH
tbl_lnkServicedependencyToHost_H
tbl_lnkServicedependencyToHostgroup_DH
tbl_lnkServicedependencyToHostgroup_H
tbl_lnkServicedependencyToService_DS
tbl_lnkServicedependencyToService_S
tbl_lnkServiceescalationToContact
tbl_lnkServiceescalationToContactgroup
tbl_lnkServiceescalationToHost
tbl_lnkServiceescalationToHostgroup
tbl_lnkServiceescalationToService
tbl_lnkServicegroupToService
tbl_lnkServicegroupToServicegroup
tbl_lnkServicetemplateToContact
tbl_lnkServicetemplateToContactgroup
tbl_lnkServicetemplateToHost
tbl_lnkServicetemplateToHostgroup
tbl_lnkServicetemplateToServicegroup
tbl_lnkServicetemplateToServicetemplate
tbl_lnkServicetemplateToVariabledefinition
tbl_lnkTimeperiodToTimeperiod
tbl_logbook
tbl_mainmenu
tbl_service
tbl_servicedependency
tbl_serviceescalation
tbl_serviceextinfo
tbl_servicegroup
tbl_servicetemplate
tbl_session
tbl_session_locks
tbl_settings
tbl_submenu
tbl_timedefinition
tbl_timeperiod
tbl_user
tbl_variabledefinition

[npolovenko]

@spperry, Please run the repair script first and show me the output:

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh

Also, please upload the following file in the ticket:

Code: Select all

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

[spperry]

I ran the repair script, which completed successfully. The requested file is attached. Extension changes from PHP to TXT so it would upload.

The issue is still occurring, even after the repair, just FYI.

Thanks.

Scott

[spperry]

From repair script:

Code: Select all

[root@sxnagios01 ~]# /usr/local/nagiosxi/scripts/repair_databases.sh
DATABASE: nagios
TABLE:
mysqld (pid  2382) is running...
/var/lib/mysql/nagios ~
Stopping mysqld:                                           [  OK  ]
- recovering (with sort) MyISAM-table 'nagios_acknowledgements.MYI'
Data records: 1599
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_commands.MYI'
Data records: 164
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_commenthistory.MYI'
Data records: 5614
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_comments.MYI'
Data records: 9
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_configfiles.MYI'
Data records: 1
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_configfilevariables.MYI'
Data records: 131
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_conninfo.MYI'
Data records: 3533
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_contact_addresses.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactgroup_members.MYI'
Data records: 148
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactgroups.MYI'
Data records: 17
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contact_notificationcommands.MYI'
Data records: 588
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactnotificationmethods.MYI'
Data records: 80419
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_contactnotifications.MYI'
Data records: 80419
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5

---------

- recovering (with sort) MyISAM-table 'nagios_contacts.MYI'
Data records: 49
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactstatus.MYI'
Data records: 49
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_customvariables.MYI'
Data records: 507
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_customvariablestatus.MYI'
Data records: 507
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with keycache) MyISAM-table 'nagios_dbversion.MYI'
Data records: 1

---------

- recovering (with sort) MyISAM-table 'nagios_downtimehistory.MYI'
Data records: 2884
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_eventhandlers.MYI'
Data records: 4
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_externalcommands.MYI'
Data records: 2006
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_flappinghistory.MYI'
Data records: 36276
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_hostchecks.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_host_contactgroups.MYI'
Data records: 286
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_host_contacts.MYI'
Data records: 238
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostdependencies.MYI'
Data records: 98
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostescalation_contactgroups.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostescalation_contacts.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostescalations.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostgroup_members.MYI'
Data records: 414
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostgroups.MYI'
Data records: 30
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_host_parenthosts.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hosts.MYI'
Data records: 278
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_hoststatus.MYI'
Data records: 278
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
- Fixing index 10
- Fixing index 11
- Fixing index 12
- Fixing index 13
- Fixing index 14
- Fixing index 15
- Fixing index 16
- Fixing index 17
- Fixing index 18
- Fixing index 19

---------

- recovering (with sort) MyISAM-table 'nagios_instances.MYI'
Data records: 1
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_logentries.MYI'
Data records: 945588
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5

---------

- recovering (with sort) MyISAM-table 'nagios_notifications.MYI'
Data records: 22605
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5

---------

- recovering (with sort) MyISAM-table 'nagios_objects.MYI'
Data records: 8415
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5

---------

- recovering (with sort) MyISAM-table 'nagios_processevents.MYI'
Data records: 3380
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_programstatus.MYI'
Data records: 1
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_runtimevariables.MYI'
Data records: 18
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_scheduleddowntime.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicechecks.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_service_contactgroups.MYI'
Data records: 1602
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_service_contacts.MYI'
Data records: 219
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicedependencies.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_serviceescalation_contactgroups.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_serviceescalation_contacts.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_serviceescalations.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicegroup_members.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicegroups.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_service_parentservices.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_services.MYI'
Data records: 1370
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_servicestatus.MYI'
Data records: 1370
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
- Fixing index 10
- Fixing index 11
- Fixing index 12
- Fixing index 13
- Fixing index 14
- Fixing index 15
- Fixing index 16
- Fixing index 17
- Fixing index 18
- Fixing index 19

---------

- recovering (with sort) MyISAM-table 'nagios_statehistory.MYI'
Data records: 1463303
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_systemcommands.MYI'
Data records: 116
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_timedeventqueue.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6

---------

- recovering (with sort) MyISAM-table 'nagios_timedevents.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6

---------

- recovering (with sort) MyISAM-table 'nagios_timeperiods.MYI'
Data records: 44
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_timeperiod_timeranges.MYI'
Data records: 285
- Fixing index 1
- Fixing index 2
Starting mysqld:                                           [  OK  ]
~

===============
REPAIR COMPLETE
===============
DATABASE: nagiosql
TABLE:
mysqld (pid  24300) is running...
/var/lib/mysql/nagiosql ~
Stopping mysqld:                                           [  OK  ]
- recovering (with sort) MyISAM-table 'tbl_command.MYI'
Data records: 169
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_contactgroup.MYI'
Data records: 18
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_contact.MYI'
Data records: 48
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_contacttemplate.MYI'
Data records: 2
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_domain.MYI'
Data records: 1
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_hostdependency.MYI'
Data records: 1
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_hostescalation.MYI'
Data records: 1
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_hostextinfo.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_hostgroup.MYI'
Data records: 32
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_host.MYI'
Data records: 326
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_hosttemplate.MYI'
Data records: 52
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_info.MYI'
Data records: 218
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactgroupToContactgroup.MYI'
Data records: 7
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactgroupToContact.MYI'
Data records: 41
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToCommandHost.MYI'
Data records: 2
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToCommandService.MYI'
Data records: 2
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToContactgroup.MYI'
Data records: 1
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToContacttemplate.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToVariabledefinition.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToCommandHost.MYI'
Data records: 2
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToCommandService.MYI'
Data records: 2
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToContactgroup.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToContacttemplate.MYI'
Data records: 47
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToVariabledefinition.MYI'
Data records: 2
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHost_DH.MYI'
Data records: 49
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHostgroup_DH.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHostgroup_H.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHost_H.MYI'
Data records: 2
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToContactgroup.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToContact.MYI'
Data records: 1
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToHostgroup.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToHost.MYI'
Data records: 1
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostgroupToHostgroup.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostgroupToHost.MYI'
Data records: 372
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToContactgroup.MYI'
Data records: 4
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToContact.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToHostgroup.MYI'
Data records: 1
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToHost.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToHosttemplate.MYI'
Data records: 49
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToVariabledefinition.MYI'
Data records: 1
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToContactgroup.MYI'
Data records: 304
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToContact.MYI'
Data records: 275
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToHostgroup.MYI'
Data records: 88
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToHost.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToHosttemplate.MYI'
Data records: 323
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToVariabledefinition.MYI'
Data records: 251
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHost_DH.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHostgroup_DH.MYI'
Data records: 2
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHostgroup_H.MYI'
Data records: 2
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHost_H.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToService_DS.MYI'
Data records: 2
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToService_S.MYI'
Data records: 2
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToContactgroup.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToContact.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToHostgroup.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToHost.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToService.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicegroupToServicegroup.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicegroupToService.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToContactgroup.MYI'
Data records: 1
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToContact.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToHostgroup.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToHost.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToServicegroup.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToServicetemplate.MYI'
Data records: 82
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToVariabledefinition.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToContactgroup.MYI'
Data records: 566
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToContact.MYI'
Data records: 178
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToHostgroup.MYI'
Data records: 120
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToHost.MYI'
Data records: 469
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToServicegroup.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToServicetemplate.MYI'
Data records: 183
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToVariabledefinition.MYI'
Data records: 194
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkTimeperiodToTimeperiod.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_logbook.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_mainmenu.MYI'
Data records: 7
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_servicedependency.MYI'
Data records: 2
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_serviceescalation.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_serviceextinfo.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_servicegroup.MYI'
Data records: 1
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_service.MYI'
Data records: 553
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_servicetemplate.MYI'
Data records: 84
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_session_locks.MYI'
Data records: 3
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_session.MYI'
Data records: 3
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_settings.MYI'
Data records: 12
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_submenu.MYI'
Data records: 29
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_timedefinition.MYI'
Data records: 299
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_timeperiod.MYI'
Data records: 43
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_user.MYI'
Data records: 2
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_variabledefinition.MYI'
Data records: 617
- Fixing index 1
Starting mysqld:                                           [  OK  ]
~

===============
REPAIR COMPLETE
===============
Stopping ndo2db: done.
Starting ndo2db: done.
Running configuration check...

Nagios Core 4.2.4
Copyright (c) 2009-present Nagios Core Development Team and Community Contributors
Copyright (c) 1999-2009 Ethan Galstad
Last Modified: 12-07-2016
License: GPL

Website: https://www.nagios.org
Reading configuration data...
   Read main config file okay...
Error: Could not find any host matching 'butler' (config file '/usr/local/nagios/etc/hostgroups.cfg', starting on line 61)
Error: Could not expand members specified in hostgroup (config file '/usr/local/nagios/etc/hostgroups.cfg', starting on line 61)
   Error processing object config files!


***> One or more problems was encountered while processing the config files...

     Check your configuration file(s) to ensure that they contain valid
     directives and data defintions.  If you are upgrading from a previous
     version of Nagios, you should be aware that some variables/definitions
     may have been removed or modified in this version.  Make sure to read
     the HTML documentation regarding the config files, as well as the
     'Whats New' section to find out what has changed.


=======================
nagios database repair succeeded
nagiosql database repair succeeded

[scottwilkerson]

In your config you should change this

Code: Select all

$cfg['use_https']=false;

To this

Code: Select all

$cfg['use_https']=true;

Then try to apply configuration again

[spperry]

That appears to have done it. I was able to successfully apply a configuration change on this server now. I'm going to have the teams responsible for the system take it for a spin and make sure it's working as expected.

Assuming that being set incorrectly is the root cause, which it seems, is there any way to find out why that would have changed?

Thanks.

Scott