Nagios Support Forum

I saw the below entries when I did the upgrade that look questionable. Are these anything to worry about?

Applying NDOUtils patch level 103
ALTER TABLE `nagios_logentries` DROP INDEX `logentry_time_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'logentry_time_2'; check that column/key exists ALTER TABLE `nagios_logentries` DROP INDEX `logentry_data_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'logentry_data_2'; check that column/key exists ALTER TABLE `nagios_logentries` DROP INDEX `instance_id_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'instance_id_2'; check that column/key exists ALTER TABLE `nagios_statehistory` DROP INDEX `state_time_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'state_time_2'; check that column/key exists ALTER TABLE `nagios_statehistory` DROP INDEX `object_id_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'object_id_2'; check that column/key exists ALTER TABLE `nagios_notifications` DROP INDEX `start_time_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'start_time_2'; check that column/key exists ALTER TABLE `nagios_notifications` DROP INDEX `object_id_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'object_id_2'; check that column/key exists ALTER TABLE `nagios_notifications` DROP INDEX `instance_id_2` ;
ALTER TABLE `nagios_contactnotifications` DROP INDEX `notification_id_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'notification_id_2'; check that column/key exists ALTER TABLE `nagios_contactnotifications` DROP INDEX `contact_object_id_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'contact_object_id_2'; check that column/key exists ALTER TABLE `nagios_contactnotificationmethods` DROP INDEX `contactnotification_id_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'contactnotification_id_2'; check that column/key exists ALTER TABLE `nagios_objects` DROP INDEX `objecttype_id_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'objecttype_id_2'; check that column/key exists ALTER TABLE `nagios_objects` DROP INDEX `name1_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'name1_2'; check that column/key exists ALTER TABLE `nagios_objects` DROP INDEX `name2_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'name2_2'; check that column/key exists ALTER TABLE `nagios_objects` DROP INDEX `is_active_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'is_active_2'; check that column/key exists ALTER TABLE `nagios_timedeventqueue` DROP INDEX `queued_time_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'queued_time_2'; check that column/key exists ALTER TABLE `nagios_timedevents` DROP INDEX `queued_time_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'queued_time_2'; check that column/key existsNDOUtils patched to level 103 successfully.

Run a database repair to check for any issues:
http://assets.nagios.com/downloads/nagi ... tabase.pdf

I ran that and it ran succesfully. I tried the upgrade again and got the below errors.

Applying NDOUtils patch level 103
ALTER TABLE `nagios_logentries` DROP INDEX `logentry_time_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'logentry_time_2'; check that column/key exists ALTER TABLE `nagios_logentries` DROP INDEX `logentry_data_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'logentry_data_2'; check that column/key exists ALTER TABLE `nagios_logentries` DROP INDEX `instance_id_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'instance_id_2'; check that column/key exists ALTER TABLE `nagios_statehistory` DROP INDEX `state_time_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'state_time_2'; check that column/key exists ALTER TABLE `nagios_statehistory` DROP INDEX `object_id_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'object_id_2'; check that column/key exists ALTER TABLE `nagios_notifications` DROP INDEX `start_time_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'start_time_2'; check that column/key exists ALTER TABLE `nagios_notifications` DROP INDEX `object_id_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'object_id_2'; check that column/key exists ALTER TABLE `nagios_notifications` DROP INDEX `instance_id_2` ;
ALTER TABLE `nagios_contactnotifications` DROP INDEX `notification_id_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'notification_id_2'; check that column/key exists ALTER TABLE `nagios_contactnotifications` DROP INDEX `contact_object_id_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'contact_object_id_2'; check that column/key exists ALTER TABLE `nagios_contactnotificationmethods` DROP INDEX `contactnotification_id_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'contactnotification_id_2'; check that column/key exists ALTER TABLE `nagios_objects` DROP INDEX `objecttype_id_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'objecttype_id_2'; check that column/key exists ALTER TABLE `nagios_objects` DROP INDEX `name1_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'name1_2'; check that column/key exists ALTER TABLE `nagios_objects` DROP INDEX `name2_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'name2_2'; check that column/key exists ALTER TABLE `nagios_objects` DROP INDEX `is_active_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'is_active_2'; check that column/key exists ALTER TABLE `nagios_timedeventqueue` DROP INDEX `queued_time_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'queued_time_2'; check that column/key exists ALTER TABLE `nagios_timedevents` DROP INDEX `queued_time_2` ;
SQL: SQL Error [ndoutils] :</b> Can't DROP 'queued_time_2'; check that column/key existsNDOUtils patched to level 103 successfully.

These aren't blocking errors, they are just saying that the "extra" indexes we are trying to delete, do not exist

So I can ignore these errors?

I am also seeing these, but am I right to assume I can ignore these as well?
Unable to locally verify the issuer’s authority.
WARNING: cannot verify localhost’s certificate, issued by
WARNING: certificate common name “” doesn’t match requested host name “localhost”.

cockraml wrote:So I can ignore these errors?

Yep.

cockraml wrote:I am also seeing these, but am I right to assume I can ignore these as well?

Yep, these errors are just informing you that your cert is unverifiable, as it is self signed and the host does not have a FQDN.