Hi to all,
after the migration of centreon 22.04 we have this following problem clicking only on tab “Hosts”:
“Unknown column h.timezone in field list”
Could you give us support about it?
Thanks, regards
Page 1 / 1
Hi,
Could you share the result of these SQL queries:
show create table centreon.host;
show create table centreon_storage.hosts;
Thanks
edited
show create table centreon.host;
| host | CREATE TABLE `host` (
`host_id` int(11) NOT NULL AUTO_INCREMENT,
`host_template_model_htm_id` int(11) DEFAULT NULL,
`command_command_id` int(11) DEFAULT NULL,
`command_command_id_arg1` text DEFAULT NULL,
`timeperiod_tp_id` int(11) DEFAULT NULL,
`timeperiod_tp_id2` int(11) DEFAULT NULL,
`command_command_id2` int(11) DEFAULT NULL,
`command_command_id_arg2` text DEFAULT NULL,
`host_name` varchar(200) DEFAULT NULL,
`host_alias` varchar(200) DEFAULT NULL,
`host_address` varchar(255) DEFAULT NULL,
`display_name` varchar(255) DEFAULT NULL,
`host_max_check_attempts` int(11) DEFAULT NULL,
`host_check_interval` int(11) DEFAULT NULL,
`host_retry_check_interval` int(11) DEFAULT NULL,
`host_active_checks_enabled` enum('0','1','2') DEFAULT NULL,
`host_passive_checks_enabled` enum('0','1','2') DEFAULT NULL,
`host_checks_enabled` enum('0','1','2') DEFAULT NULL,
`initial_state` enum('o','d','u') DEFAULT NULL,
`host_obsess_over_host` enum('0','1','2') DEFAULT NULL,
`host_check_freshness` enum('0','1','2') DEFAULT NULL,
`host_freshness_threshold` int(11) DEFAULT NULL,
`host_event_handler_enabled` enum('0','1','2') DEFAULT NULL,
`host_low_flap_threshold` int(11) DEFAULT NULL,
`host_high_flap_threshold` int(11) DEFAULT NULL,
`host_flap_detection_enabled` enum('0','1','2') DEFAULT NULL,
`flap_detection_options` varchar(255) DEFAULT NULL,
`host_process_perf_data` enum('0','1','2') DEFAULT NULL,
`host_retain_status_information` enum('0','1','2') DEFAULT NULL,
`host_retain_nonstatus_information` enum('0','1','2') DEFAULT NULL,
`host_notification_interval` int(11) DEFAULT NULL,
`host_recovery_notification_delay` int(11) DEFAULT NULL,
`host_notification_options` varchar(200) DEFAULT NULL,
`host_notifications_enabled` enum('0','1','2') DEFAULT NULL,
`contact_additive_inheritance` tinyint(1) DEFAULT 0,
`cg_additive_inheritance` tinyint(1) DEFAULT 0,
`host_first_notification_delay` int(11) DEFAULT NULL,
`host_acknowledgement_timeout` int(11) DEFAULT NULL,
`host_stalking_options` varchar(200) DEFAULT NULL,
`host_snmp_community` varchar(255) DEFAULT NULL,
`host_snmp_version` varchar(255) DEFAULT NULL,
`host_location` int(11) DEFAULT 0,
`host_comment` text DEFAULT NULL,
`geo_coords` varchar(32) DEFAULT NULL,
`host_locked` tinyint(1) DEFAULT 0,
`host_register` enum('0','1','2','3') DEFAULT NULL,
`host_activate` enum('0','1','2') DEFAULT '1',
PRIMARY KEY (`host_id`),
KEY `htm_index` (`host_template_model_htm_id`),
KEY `cmd1_index` (`command_command_id`),
KEY `cmd2_index` (`command_command_id2`),
KEY `tp1_index` (`timeperiod_tp_id`),
KEY `tp2_index` (`timeperiod_tp_id2`),
KEY `name_index` (`host_name`),
KEY `host_id_register` (`host_id`,`host_register`),
KEY `alias_index` (`host_alias`),
KEY `host_register` (`host_register`),
CONSTRAINT `host_ibfk_1` FOREIGN KEY (`command_command_id`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `host_ibfk_2` FOREIGN KEY (`command_command_id2`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `host_ibfk_3` FOREIGN KEY (`timeperiod_tp_id`) REFERENCES `timeperiod` (`tp_id`) ON DELETE SET NULL,
CONSTRAINT `host_ibfk_4` FOREIGN KEY (`timeperiod_tp_id2`) REFERENCES `timeperiod` (`tp_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
show create table centreon_storage.hosts
| hosts | CREATE TABLE `hosts` (
`host_id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`instance_id` int(11) NOT NULL,
`acknowledged` tinyint(1) DEFAULT NULL,
`acknowledgement_type` smallint(6) DEFAULT NULL,
`action_url` varchar(255) DEFAULT NULL,
`active_checks` tinyint(1) DEFAULT NULL,
`address` varchar(75) DEFAULT NULL,
`alias` varchar(100) DEFAULT NULL,
`check_attempt` smallint(6) DEFAULT NULL,
`check_command` text DEFAULT NULL,
`check_freshness` tinyint(1) DEFAULT NULL,
`check_interval` double DEFAULT NULL,
`check_period` varchar(75) DEFAULT NULL,
`check_type` smallint(6) DEFAULT NULL,
`checked` tinyint(1) DEFAULT NULL,
`command_line` text DEFAULT NULL,
`default_active_checks` tinyint(1) DEFAULT NULL,
`default_event_handler_enabled` tinyint(1) DEFAULT NULL,
`default_failure_prediction` tinyint(1) DEFAULT NULL,
`default_flap_detection` tinyint(1) DEFAULT NULL,
`default_notify` tinyint(1) DEFAULT NULL,
`default_passive_checks` tinyint(1) DEFAULT NULL,
`default_process_perfdata` tinyint(1) DEFAULT NULL,
`display_name` varchar(100) DEFAULT NULL,
`enabled` tinyint(1) NOT NULL DEFAULT 1,
`event_handler` varchar(255) DEFAULT NULL,
`event_handler_enabled` tinyint(1) DEFAULT NULL,
`execution_time` double DEFAULT NULL,
`failure_prediction` tinyint(1) DEFAULT NULL,
`first_notification_delay` double DEFAULT NULL,
`flap_detection` tinyint(1) DEFAULT NULL,
`flap_detection_on_down` tinyint(1) DEFAULT NULL,
`flap_detection_on_unreachable` tinyint(1) DEFAULT NULL,
`flap_detection_on_up` tinyint(1) DEFAULT NULL,
`flapping` tinyint(1) DEFAULT NULL,
`freshness_threshold` double DEFAULT NULL,
`high_flap_threshold` double DEFAULT NULL,
`icon_image` varchar(255) DEFAULT NULL,
`icon_image_alt` varchar(255) DEFAULT NULL,
`last_check` int(11) DEFAULT NULL,
`last_hard_state` smallint(6) DEFAULT NULL,
`last_hard_state_change` int(11) DEFAULT NULL,
`last_notification` int(11) DEFAULT NULL,
`last_state_change` int(11) DEFAULT NULL,
`last_time_down` int(11) DEFAULT NULL,
`last_time_unreachable` int(11) DEFAULT NULL,
`last_time_up` int(11) DEFAULT NULL,
`last_update` int(11) DEFAULT NULL,
`latency` double DEFAULT NULL,
`low_flap_threshold` double DEFAULT NULL,
`max_check_attempts` smallint(6) DEFAULT NULL,
`modified_attributes` int(11) DEFAULT NULL,
`next_check` int(11) DEFAULT NULL,
`next_host_notification` int(11) DEFAULT NULL,
`no_more_notifications` tinyint(1) DEFAULT NULL,
`notes` varchar(255) DEFAULT NULL,
`notes_url` varchar(255) DEFAULT NULL,
`notification_interval` double DEFAULT NULL,
`notification_number` smallint(6) DEFAULT NULL,
`notification_period` varchar(75) DEFAULT NULL,
`notify` tinyint(1) DEFAULT NULL,
`notify_on_down` tinyint(1) DEFAULT NULL,
`notify_on_downtime` tinyint(1) DEFAULT NULL,
`notify_on_flapping` tinyint(1) DEFAULT NULL,
`notify_on_recovery` tinyint(1) DEFAULT NULL,
`notify_on_unreachable` tinyint(1) DEFAULT NULL,
`obsess_over_host` tinyint(1) DEFAULT NULL,
`output` text DEFAULT NULL,
`passive_checks` tinyint(1) DEFAULT NULL,
`percent_state_change` double DEFAULT NULL,
`perfdata` text DEFAULT NULL,
`process_perfdata` tinyint(1) DEFAULT NULL,
`retain_nonstatus_information` tinyint(1) DEFAULT NULL,
`retain_status_information` tinyint(1) DEFAULT NULL,
`retry_interval` double DEFAULT NULL,
`scheduled_downtime_depth` smallint(6) DEFAULT NULL,
`should_be_scheduled` tinyint(1) DEFAULT NULL,
`stalk_on_down` tinyint(1) DEFAULT NULL,
`stalk_on_unreachable` tinyint(1) DEFAULT NULL,
`stalk_on_up` tinyint(1) DEFAULT NULL,
`state` smallint(6) DEFAULT NULL,
`state_type` smallint(6) DEFAULT NULL,
`statusmap_image` varchar(255) DEFAULT NULL,
`real_state` smallint(6) DEFAULT NULL,
UNIQUE KEY `host_id` (`host_id`),
KEY `instance_id` (`instance_id`),
KEY `host_name` (`name`),
CONSTRAINT `hosts_ibfk_1` FOREIGN KEY (`instance_id`) REFERENCES `instances` (`instance_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
Can you give me a screenshot of the Host tab you are talking about?
It looks like some upgrade scripts failed, cause some fields are missing. What’s the version you’ve upgraded from?
This field comes with the 2.8.4 upgrade script:
'ALTER TABLE `hosts` ADD COLUMN `timezone` varchar(64) DEFAULT NULL AFTER `statusmap_image`'
great, it works now
we have another message error on file “gorgoned.log”:
ERROR - Rautodiscovery] -class- host discovery - cannot get platform versions - Login error rcode: '401'] 1message: 'Unauthorized']
Could you give us support about it?
Thanks, regards
You have to set correct credentials in /etc/centreon-gorgone/config.d/31-centreon-api.yaml and restart gorgoned daemon.
Ok but How can i know if those credentials are correct?
we have also this error:
>2022-08-02T14:13:04.140+02:00] sql] error] mysql_connection: Table 'centreon_storage.resources' doesn't exist
>2022-08-02T14:13:04.141+02:00] sql] error] mysql_connection: Table 'centreon_storage.severities' doesn't exist
>2022-08-02T14:13:04.141+02:00] sql] error] mysql_connection: Table 'centreon_storage.tags' doesn't exist
>2022-08-02T14:13:04.161+02:00] sql] error] error while loading caches: unified sql: could not get the list of resources: Table 'centreon_storage.resources' doesn't exist
>2022-08-02T14:13:04.162+02:00] core] error] failover: global error: unified sql: could not get the list of resources: Table 'centreon_storage.resources' doesn't exist
Could you give us support about it?
Reply
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.