Solved

migration centreon to 22.04

Forum|Forum|3 years ago
July 28, 2022
10 replies
273 views

g.bruciamonti
Steward *

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

Best answer by sims24

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`'

+19

sims24
Ranger ***
Forum|Forum|3 years ago
July 29, 2022

Hi,

Could you share the result of these SQL queries:

show create table centreon.host;

show create table centreon_storage.hosts;

Thanks

"It's shocking to find how many people do not believe they can learn, and how many more believe learning to be difficult." - Frank Herbert, 'Dune'.

+19

sims24
Ranger ***
Forum|Forum|3 years ago
July 29, 2022

edited

"It's shocking to find how many people do not believe they can learn, and how many more believe learning to be difficult." - Frank Herbert, 'Dune'.

g.bruciamonti
Author
Steward *
Forum|Forum|3 years ago
July 29, 2022

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

g.bruciamonti
Author
Steward *
Forum|Forum|3 years ago
July 29, 2022

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 |

+19

sims24
Ranger ***
Answer
Forum|Forum|3 years ago
July 29, 2022

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`'

"It's shocking to find how many people do not believe they can learn, and how many more believe learning to be difficult." - Frank Herbert, 'Dune'.

g.bruciamonti
Author
Steward *
Forum|Forum|3 years ago
July 29, 2022

great, it works now

g.bruciamonti
Author
Steward *
Forum|Forum|3 years ago
August 1, 2022

we have another message error on file “gorgoned.log”:

ERROR - [autodiscovery] -class- host discovery - cannot get platform versions - Login error [code: '401'] [message: 'Unauthorized']

Could you give us support about it?

Thanks, regards

+19

sims24
Ranger ***
Forum|Forum|3 years ago
August 1, 2022

You have to set correct credentials in /etc/centreon-gorgone/config.d/31-centreon-api.yaml and restart gorgoned daemon.

"It's shocking to find how many people do not believe they can learn, and how many more believe learning to be difficult." - Frank Herbert, 'Dune'.

g.bruciamonti
Author
Steward *
Forum|Forum|3 years ago
August 1, 2022

Ok but How can i know if those credentials are correct?

g.bruciamonti
Author
Steward *
Forum|Forum|3 years ago
August 2, 2022

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?

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded