Hello y’all
I tried to upgrade centreon from 20.04 to hos latest version but i’ve got this error.
Can someone help me please.
Thanks.
Best answer by marcelluis
View originalHello y’all
I tried to upgrade centreon from 20.04 to hos latest version but i’ve got this error.
Can someone help me please.
Thanks.
Best answer by marcelluis
View originalHi
Can you edit the /usr/share/centreon/src/Core/Platform/Infrastructure/Repository/DbWriteUpdateRepository.php file at line 289 and change this bloc:
private function isSqlComment(string $line): bool
{
return str_starts_with(trim($line), '--');
}
Then refresh your page (Ctrl + F5)
Regards
Hello
I restored centreon yesterday to his 20.04 version
Today i have this issue
I juste need to drop that from centreon.cf_nagios table ?
Hi
ALTER TABLE `cfg_nagios` DROP COLUMN `postpone_notification_to_timeperiod
regards,
i know have this
Here is the result
Hello Y’all
Sorry for the late : here is the result
| Table | Create Table -------------------------------------------------------------------------------------------------------------------------+
| cfg_nagios | CREATE TABLE `cfg_nagios` (
`nagios_id` int(11) NOT NULL AUTO_INCREMENT,
`nagios_name` varchar(255) DEFAULT NULL,
`use_timezone` int(11) unsigned DEFAULT NULL,
`log_file` varchar(255) DEFAULT NULL,
`cfg_dir` varchar(255) DEFAULT NULL,
`temp_file` varchar(255) DEFAULT NULL,
`status_file` varchar(255) DEFAULT NULL,
`status_update_interval` int(11) DEFAULT NULL,
`nagios_user` varchar(255) DEFAULT NULL,
`nagios_group` varchar(255) DEFAULT NULL,
`postpone_notification_to_timeperiod` tinyint(1) DEFAULT 0,
`enable_notifications` enum('0','1','2') DEFAULT NULL,
`execute_service_checks` enum('0','1','2') DEFAULT NULL,
`accept_passive_service_checks` enum('0','1','2') DEFAULT NULL,
`execute_host_checks` enum('0','1','2') DEFAULT NULL,
`accept_passive_host_checks` enum('0','1','2') DEFAULT NULL,
`enable_event_handlers` enum('0','1','2') DEFAULT NULL,
`log_rotation_method` varchar(255) DEFAULT NULL,
`log_archive_path` varchar(255) DEFAULT NULL,
`check_external_commands` enum('0','1','2') DEFAULT NULL,
`external_command_buffer_slots` int(11) DEFAULT NULL,
`command_check_interval` varchar(255) DEFAULT NULL,
`command_file` varchar(255) DEFAULT NULL,
`downtime_file` varchar(255) DEFAULT NULL,
`comment_file` varchar(255) DEFAULT NULL,
`lock_file` varchar(255) DEFAULT NULL,
`retain_state_information` enum('0','1','2') DEFAULT NULL,
`state_retention_file` varchar(255) DEFAULT NULL,
`retention_update_interval` int(11) DEFAULT NULL,
`use_retained_program_state` enum('0','1','2') DEFAULT NULL,
`use_retained_scheduling_info` enum('0','1','2') DEFAULT NULL,
`retained_contact_host_attribute_mask` bigint(20) DEFAULT NULL,
`retained_contact_service_attribute_mask` bigint(20) DEFAULT NULL,
`retained_process_host_attribute_mask` bigint(20) DEFAULT NULL,
`retained_process_service_attribute_mask` bigint(20) DEFAULT NULL,
`retained_host_attribute_mask` bigint(20) DEFAULT NULL,
`retained_service_attribute_mask` bigint(20) DEFAULT NULL,
`use_syslog` enum('0','1','2') DEFAULT NULL,
`log_notifications` enum('0','1','2') DEFAULT NULL,
`log_service_retries` enum('0','1','2') DEFAULT NULL,
`log_host_retries` enum('0','1','2') DEFAULT NULL,
`log_event_handlers` enum('0','1','2') DEFAULT NULL,
`log_initial_states` enum('0','1','2') DEFAULT NULL,
`log_external_commands` enum('0','1','2') DEFAULT NULL,
`log_passive_checks` enum('0','1','2') DEFAULT NULL,
`global_host_event_handler` int(11) DEFAULT NULL,
`global_service_event_handler` int(11) DEFAULT NULL,
`sleep_time` varchar(10) DEFAULT NULL,
`service_inter_check_delay_method` varchar(255) DEFAULT NULL,
`host_inter_check_delay_method` varchar(255) DEFAULT NULL,
`service_interleave_factor` varchar(255) DEFAULT NULL,
`max_concurrent_checks` int(11) DEFAULT NULL,
`max_service_check_spread` int(11) DEFAULT NULL,
`max_host_check_spread` int(11) DEFAULT NULL,
`check_result_reaper_frequency` int(11) DEFAULT NULL,
`max_check_result_reaper_time` int(11) DEFAULT NULL,
`interval_length` int(11) DEFAULT NULL,
`auto_reschedule_checks` enum('0','1','2') DEFAULT NULL,
`auto_rescheduling_interval` int(11) DEFAULT NULL,
`auto_rescheduling_window` int(11) DEFAULT NULL,
`use_aggressive_host_checking` enum('0','1','2') DEFAULT NULL,
`enable_flap_detection` enum('0','1','2') DEFAULT NULL,
`low_service_flap_threshold` varchar(255) DEFAULT NULL,
`high_service_flap_threshold` varchar(255) DEFAULT NULL,
`low_host_flap_threshold` varchar(255) DEFAULT NULL,
`high_host_flap_threshold` varchar(255) DEFAULT NULL,
`soft_state_dependencies` enum('0','1','2') DEFAULT NULL,
`service_check_timeout` int(11) DEFAULT NULL,
`host_check_timeout` int(11) DEFAULT NULL,
`event_handler_timeout` int(11) DEFAULT NULL,
`notification_timeout` int(11) DEFAULT NULL,
`ocsp_timeout` int(11) DEFAULT NULL,
`ochp_timeout` int(11) DEFAULT NULL,
`perfdata_timeout` int(11) DEFAULT NULL,
`obsess_over_services` enum('0','1','2') DEFAULT NULL,
`ocsp_command` int(11) DEFAULT NULL,
`obsess_over_hosts` enum('0','1','2') DEFAULT NULL,
`ochp_command` int(11) DEFAULT NULL,
`process_performance_data` enum('0','1','2') DEFAULT NULL,
`host_perfdata_command` int(11) DEFAULT NULL,
`service_perfdata_command` int(11) DEFAULT NULL,
`host_perfdata_file` varchar(255) DEFAULT NULL,
`service_perfdata_file` varchar(255) DEFAULT NULL,
`host_perfdata_file_template` text DEFAULT NULL,
`service_perfdata_file_template` text DEFAULT NULL,
`host_perfdata_file_mode` enum('a','w','2') DEFAULT NULL,
`service_perfdata_file_mode` enum('a','w','2') DEFAULT NULL,
`host_perfdata_file_processing_interval` int(11) DEFAULT NULL,
`service_perfdata_file_processing_interval` int(11) DEFAULT NULL,
`host_perfdata_file_processing_command` int(11) DEFAULT NULL,
`service_perfdata_file_processing_command` int(11) DEFAULT NULL,
`check_for_orphaned_services` enum('0','1','2') DEFAULT NULL,
`check_for_orphaned_hosts` enum('0','1','2') DEFAULT NULL,
`check_service_freshness` enum('0','1','2') DEFAULT NULL,
`service_freshness_check_interval` int(11) DEFAULT NULL,
`freshness_check_interval` int(11) DEFAULT NULL,
`check_host_freshness` enum('0','1','2') DEFAULT NULL,
`host_freshness_check_interval` int(11) DEFAULT NULL,
`date_format` varchar(255) DEFAULT NULL,
`instance_heartbeat_interval` smallint(6) DEFAULT 30,
`illegal_object_name_chars` varchar(255) DEFAULT NULL,
`illegal_macro_output_chars` varchar(255) DEFAULT NULL,
`use_regexp_matching` enum('0','1','2') DEFAULT NULL,
`use_true_regexp_matching` enum('0','1','2') DEFAULT NULL,
`admin_email` varchar(255) DEFAULT NULL,
`admin_pager` varchar(255) DEFAULT NULL,
`nagios_comment` text DEFAULT NULL,
`nagios_activate` enum('0','1') DEFAULT NULL,
`event_broker_options` varchar(255) DEFAULT NULL,
`translate_passive_host_checks` int(11) DEFAULT NULL,
`nagios_server_id` int(11) DEFAULT NULL,
`enable_predictive_host_dependency_checks` enum('0','1','2') DEFAULT NULL,
`enable_predictive_service_dependency_checks` enum('0','1','2') DEFAULT NULL,
`cached_host_check_horizon` int(11) DEFAULT NULL,
`cached_service_check_horizon` int(11) DEFAULT NULL,
`passive_host_checks_are_soft` int(11) DEFAULT NULL,
`use_large_installation_tweaks` enum('0','1','2') DEFAULT NULL,
`enable_environment_macros` enum('0','1','2') DEFAULT NULL,
`use_setpgid` enum('0','1','2') DEFAULT NULL,
`additional_freshness_latency` int(11) DEFAULT NULL,
`debug_file` varchar(255) DEFAULT NULL,
`debug_level` int(11) DEFAULT NULL,
`debug_level_opt` varchar(200) DEFAULT '0',
`debug_verbosity` enum('0','1','2') DEFAULT NULL,
`max_debug_file_size` int(11) DEFAULT NULL,
`daemon_dumps_core` enum('0','1') DEFAULT NULL,
`cfg_file` varchar(255) NOT NULL DEFAULT 'centengine.cfg',
`log_pid` enum('0','1') DEFAULT '1',
`enable_macros_filter` enum('0','1') DEFAULT '0',
`macros_filter` text DEFAULT NULL,
PRIMARY KEY (`nagios_id`),
KEY `cmd1_index` (`global_host_event_handler`),
KEY `cmd2_index` (`global_service_event_handler`),
KEY `cmd3_index` (`ocsp_command`),
KEY `cmd4_index` (`ochp_command`),
KEY `cmd5_index` (`host_perfdata_command`),
KEY `cmd6_index` (`service_perfdata_command`),
KEY `cmd7_index` (`host_perfdata_file_processing_command`),
KEY `cmd8_index` (`service_perfdata_file_processing_command`),
KEY `nagios_server_id` (`nagios_server_id`),
KEY `cfg_nagios_ibfk_27` (`use_timezone`),
CONSTRAINT `cfg_nagios_ibfk_15` FOREIGN KEY (`service_perfdata_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `cfg_nagios_ibfk_18` FOREIGN KEY (`global_host_event_handler`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `cfg_nagios_ibfk_19` FOREIGN KEY (`global_service_event_handler`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `cfg_nagios_ibfk_20` FOREIGN KEY (`ocsp_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `cfg_nagios_ibfk_21` FOREIGN KEY (`ochp_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `cfg_nagios_ibfk_22` FOREIGN KEY (`host_perfdata_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `cfg_nagios_ibfk_23` FOREIGN KEY (`service_perfdata_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `cfg_nagios_ibfk_24` FOREIGN KEY (`host_perfdata_file_processing_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `cfg_nagios_ibfk_25` FOREIGN KEY (`service_perfdata_file_processing_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `cfg_nagios_ibfk_26` FOREIGN KEY (`nagios_server_id`) REFERENCES `nagios_server` (`id`) ON DELETE CASCADE,
CONSTRAINT `cfg_nagios_ibfk_27` FOREIGN KEY (`use_timezone`) REFERENCES `timezone` (`timezone_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 |
1 row in set (0.000 sec)
Hello
This command has resolved the issue for me : SET GLOBAL innodb_strict_mode = 0;
Hope it will help someone else
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.