Nvm, installed a fresh instance on the side and pulled the table structure from there (including them in the end in case someone else runs into the same issue).
After that, I started getting error messages such as this nagios.log instead:
Code: Select all
[1704195787] NDO-3: ndo_return = 1 (Unknown column 'retain_status_information' in 'field list')
[1704195787] NDO-3: ndo_write_contacts(ndo-startup.c:972): Unable to prepare statement
[1704195787] NDO-3: ndo_write_contacts() failed. Disabling NDO.
[1704195787] NDO-3: NDO startup thread failed at ndo_write_object_config() - disabling NDO.
[1704195787] NDO-3: Ended contact_status thread
So, fi
xing them, one by one:
Code: Select all
ALTER TABLE nagios_contacts ADD COLUMN retain_status_information smallint NOT NULL DEFAULT 0 AFTER can_submit_commands;
ALTER TABLE nagios_contacts ADD COLUMN retain_nonstatus_information smallint NOT NULL DEFAULT 0 AFTER retain_status_information;
ALTER TABLE nagios_hosts ADD COLUMN should_be_drawn smallint NOT NULL DEFAULT 0;
ALTER TABLE nagios_hostgroups ADD COLUMN notes varchar(255) NOT NULL DEFAULT 0;
ALTER TABLE nagios_hostgroups ADD COLUMN notes_url varchar(255) NOT NULL DEFAULT '';
ALTER TABLE nagios_hostgroups ADD COLUMN action_url varchar(255) NOT NULL DEFAULT '';
ALTER TABLE nagios_services ADD COLUMN parallelize_check smallint NOT NULL DEFAULT '';
ALTER TABLE nagios_servicegroups ADD COLUMN notes varchar(255) NOT NULL DEFAULT '';
Maybe this will help someone else having similar problems, dunno.
Table structure dumps for the three initially missing tables:
nagios_timeperiod_exception_timeranges.sql
Code: Select all
CREATE TABLE `nagios_timeperiod_exception_timeranges` (
`nagios_timeperiod_exception_timerange_id` int NOT NULL AUTO_INCREMENT,
`instance_id` smallint NOT NULL DEFAULT '0',
`timeperiod_exception_id` int NOT NULL DEFAULT '0',
`start_sec` int NOT NULL DEFAULT '0',
`end_sec` int NOT NULL DEFAULT '0',
PRIMARY KEY (`nagios_timeperiod_exception_timerange_id`),
KEY `timeperiod_exception_id` (`timeperiod_exception_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COMMENT='Timeperiod Exception Timeranges';
Code: Select all
CREATE TABLE `nagios_timeperiod_exceptions` (
`timeperiod_exception_id` int NOT NULL AUTO_INCREMENT,
`instance_id` smallint NOT NULL DEFAULT '0',
`timeperiod_id` int NOT NULL DEFAULT '0',
`exception_type` smallint NOT NULL DEFAULT '0',
`syear` smallint NOT NULL DEFAULT '0',
`smon` smallint NOT NULL DEFAULT '0',
`smday` smallint NOT NULL DEFAULT '0',
`swday` smallint NOT NULL DEFAULT '0',
`swday_offset` smallint NOT NULL DEFAULT '0',
`eyear` smallint NOT NULL DEFAULT '0',
`emon` smallint NOT NULL DEFAULT '0',
`emday` smallint NOT NULL DEFAULT '0',
`ewday` smallint NOT NULL DEFAULT '0',
`ewday_offset` smallint NOT NULL DEFAULT '0',
`skip_interval` smallint NOT NULL DEFAULT '0',
PRIMARY KEY (`timeperiod_exception_id`),
KEY `timeperiod_id` (`timeperiod_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COMMENT='Timeperiod Exceptions';
Code: Select all
CREATE TABLE `nagios_timeperiod_exclusions` (
`parent_id` int NOT NULL,
`child_id` int NOT NULL,
KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Timeperiod Exclusions';