Skip to main content
Solved

migration centreon to 22.04

  • Jul 28, 2022 3:29 PM UTC
  • 10 replies
  • 321 views
Forum|alt.badge.img+2

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

View original

    10 replies

    sims24
    Forum|alt.badge.img+19
    • sims24
    • Ranger ***
    • Jul 29, 2022 6:20 AM UTC

    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'.
    sims24
    Forum|alt.badge.img+19
    • sims24
    • Ranger ***
    • Jul 29, 2022 6:21 AM UTC

    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'.
    Forum|alt.badge.img+2
    • g.bruciamonti
    • Author
    • Steward *
    • Jul 29, 2022 9:45 AM UTC

    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

    Forum|alt.badge.img+2
    • g.bruciamonti
    • Author
    • Steward *
    • Jul 29, 2022 9:46 AM UTC

    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 |

    sims24
    Forum|alt.badge.img+19
    • sims24
    • Ranger ***
    • Answer
    • Jul 29, 2022 10:13 AM UTC

    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'.
    Forum|alt.badge.img+2
    • g.bruciamonti
    • Author
    • Steward *
    • Jul 29, 2022 12:55 PM UTC

    great, it works now

    Forum|alt.badge.img+2

    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

    sims24
    Forum|alt.badge.img+19
    • sims24
    • Ranger ***
    • Aug 1, 2022 2:17 PM UTC

    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'.
    Forum|alt.badge.img+2

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

    Forum|alt.badge.img+2
    • g.bruciamonti
    • Author
    • Steward *
    • Aug 2, 2022 12:16 PM UTC

    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?

    Terms & ConditionsAccessibility statement