Hello jacek,
I think your issue is similar to the one mentioned
here.
Basically, we changed some mysql tables is one place and not in another, and updated the code to match those changes.
To fix your issue, please log into mysql from the terminal. By default, you can do this with
,
though the -p option might be different if you've manually set a different password.
Then, run these commands to update your schema:
Code: Select all
DROP TABLE nagiosxi.xi_cmp_trapdata;
CREATE TABLE IF NOT EXISTS `nagiosxi`.`xi_cmp_trapdata` (
`trapdata_id` int auto_increment,
`trapdata_updated` timestamp NOT NULL DEFAULT current_timestamp ON UPDATE current_timestamp,
`trapdata_enabled` smallint default 1,
`trapdata_event_name` varchar(128) NOT NULL default '',
`trapdata_event_oid` varchar(256) NOT NULL default '',
`trapdata_category` varchar(128) NOT NULL default '',
`trapdata_severity` varchar(64) NOT NULL default '',
`trapdata_custom_format` text,
`trapdata_raw_data` text,
`trapdata_exec` text,
`trapdata_desc` text,
`trapdata_wizard_integration_enabled` smallint default 0,
`trapdata_wizard_integration_data` text,
primary key (`trapdata_id`),
unique (`trapdata_event_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
DROP TABLE nagiosxi.xi_cmp_trapdata_log;
CREATE TABLE IF NOT EXISTS `nagiosxi`.`xi_cmp_trapdata_log` (
`trapdata_log_id` int auto_increment,
`trapdata_log_event_name` varchar(128) NOT NULL default '',
`trapdata_log_event_oid` varchar(50) NOT NULL default '',
`trapdata_log_numeric_oid` varchar(100),
`trapdata_log_symbolic_oid` varchar(100),
`trapdata_log_community` varchar(20),
`trapdata_log_trap_hostname` varchar(100),
`trapdata_log_trap_ip` varchar(16),
`trapdata_log_agent_hostname` varchar(100),
`trapdata_log_agent_IP` varchar(16),
`trapdata_log_category` varchar(20) NOT NULL default '',
`trapdata_log_severity` varchar(20) NOT NULL default '',
`trapdata_log_uptime` varchar(20) NOT NULL default '',
`trapdata_log_datetime` datetime,
`trapdata_log_bindings` text,
primary key (`trapdata_log_id`),
unique (`trapdata_log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
and let me know whether this fixes your issue.
