Sommaire
Hello, une nouvelle version majeure de Centreon est disponible. Je vous propose dans cet article la mise à jour Centreon 19.10.10 vers cette nouvelle version, Centreon 20.04.x.
Mise à jour #3 : Server PROD, TEST : OK
J’ai eu le même problème en PROD.
[root@pixelabs centreon]# tail -f /var/log/centreon/upgrade.log
2020-09-24 07:37|0|0|UPGRADE - 20.04.1 : Gorgone configuration file is not created properly - Code : 0 - Error : Gorgone configuration file is not created properly - Trace : #0 /usr/share/centreon/www/install/step_upgrade/process/process_step4.php(72): include_once()
#1 {main}
Solution qui a fonctionnée pour moi : (Certains ont apparemment actualisé la page et ça fonctionne…)
Relancer le service PHP :
[root@pixelabs centreon]# systemctl restart rh-php72-php-fpm
Retourner sur la page web et cliquez sur « Refresh » et terminer la migration.
Mise à jour #2 : Serveur TEST OK
J’ai retenté la migration depuis un serveur Centreon 19.10.15 vers la dernière version 20.04.5. La migration s’est bien déroulée sans erreur. Il semble que le problème a été réglé, mais vous devez mettre à jour Centreon vers la version 19.10.15 AVANT de passer à la dernière version (20.04.5).
- Step 0 : Vérifier la SAUVEGARDE AVANT LA MIGRATION
- Step 1 : Mettre à jour Centreon vers 19.10.15 (j’étais sur 19.10.10. C’est très simple, voici un exemple : update)
- Step 2 : Migration de Centreon 19.10.15 vers Centreon 20.04.5 (tuto ci-dessous)
- Step 3 : Mise à jour des Extensions & Modules
- Step 4 : Migration de la base de donnée MariaDB (tuto ci-dessous)
- Step 5 : Vérifier le bon fonctionnement de votre plate-forme.
- /var/log/centreon
- /var/log/centreon-engine
- /var/log/centreon-broker
- /var/log/centreon-gorgoned
Je reviens aux nouvelles après la migration de la PROD. Je vérifie d’abord que tout fonctionne bien sur le test.
Mise à jour #1 : PROD FAILED – TEST OK
Attention : certains ont eu des problèmes de mise à jour vers la version 20.04 tout comme moi sachant que, la mise à jour sur mon serveur de test s’est bien déroulée. Voici l’erreur que j’ai rencontrée pour ma part :
20.04.0 to 20.04.1 UPGRADE - 20.04.1 : Gorgone configuration file is not created properly You seem to be having trouble with your upgrade. Please check the "upgrade.log" and the "sql-error.log" located in "/var/log/centreon" for more details You may refer to the line in the specified file in order to correct the issue. The SQL files are located in "/usr/share/centreon/www/install/sql/" But do not edit the SQL files unless you know what you are doing.Refresh this page when the problem is fixed.
Des problèmes de base de données via le log :
tail -f /var/log/centreon-broker/central-broker-master.log
Pour revenir en arrière, il y a cette commande que je n’ai pas encore testée (en cours…). Voir ici : https://docs.centreon.com/current/fr/releases/centreon-core.html#20045
yum downgrade centreon-broker-20.04.4 centreon-broker-cbd-20.04.4 centreon-broker-storage-20.04.4 centreon-broker-cbmod-20.04.4 centreon-broker-core-20.04.4
Remarque : avant de passer sur cette nouvelle version, je vous conseille de mettre à jour Centreon vers la version 19.10.15.
Voir mes autres articles sur la mise à jour Centreon :
Documentation Centreon 20.04.0 :
- Vue d’événements (beta) New ! : events-view
- Application Mobile New ! : mobile/introduction
- Releases note : docs.centreon.com/current/fr/releases/
- Mise à jour depuis la version 19.10 : upgrade/upgrade-from-19-10
- Mise à jour depuis la version 19.04 : upgrade/upgrade-from-19-04
- Mise à jour depuis la version 18.10 : upgrade/upgrade-from-18-10
- Mise à jour depuis la version 3.4 : upgrade/upgrade-from-3-4
- Migration depuis la version 3.4 : migrate/migrate-from-3-4
Mes autres articles sur Centreon :
- Supervision avec Centreon Plugin Packs (AIO) : supervision-avec-centreon-plugins-packs/
- Installation et Mise à jour des Plugins Packs : centreon-plugin-packs-monitoring/
- Pack icônes Centreon v.2 : centreon-icones-pack/
Attention : merci de réaliser l’opération sur un serveur de test. Vérifier la sauvegarde de votre plate-forme de supervision avant de mettre à jour la PROD.
Mise à jour Centreon 19.10.10 vers 20.04.0
Commencer par arrêter les services Centreon :
[root@vm-centreon ~]# systemctl stop centengine [root@vm-centreon ~]# systemctl stop cbd
Mettez à jour le dépôt Centreon :
[root@vm-centreon ~]# yum install -y http://yum.centreon.com/standard/20.04/el7/stable/noarch/RPMS/centreon-release-20.04-1.el7.centos.noarch.rpm Modules complémentaires chargés : fastestmirror centreon-release-20.04-1.el7.centos.noarch.rpm | 4.2 kB 00:00:00 [...] Résolution des dépendances --> Lancement de la transaction de test ---> Le paquet centreon-release.noarch 0:19.10-1.el7.centos sera mis à jour ---> Le paquet centreon-release.noarch 0:20.04-1.el7.centos sera utilisé --> Résolution des dépendances terminée Dépendances résolues [...] Mettre à jour 1 Paquet Taille totale : 3.4 k Downloading packages: Running transaction check Running transaction test Transaction test succeeded Running transaction Mise à jour : centreon-release-20.04-1.el7.centos.noarch 1/2 Nettoyage : centreon-release-19.10-1.el7.centos.noarch 2/2 Vérification : centreon-release-20.04-1.el7.centos.noarch 1/2 Vérification : centreon-release-19.10-1.el7.centos.noarch 2/2 Mis à jour : centreon-release.noarch 0:20.04-1.el7.centos Terminé ! [root@vm-centreon ~]#
Videz le cache Yum :
[root@vm-centreon ~]# yum clean all --enablerepo=*
Lancez la mise à jour :
[root@vm-centreon ~]# yum update centreon\*
Rechargez le serveur web Apache :
[root@vm-centreon ~]# systemctl reload httpd24-httpd
Il faut finaliser la mise à jour depuis l’interface web. (déconnectez-vous pour déclencher le processus de mise à jour)
- Cliquez sur Next
- Cliquez sur Next
- Si tout est Ok, le message suivant s’affiche : Everything is ready !
- Cliquez sur Next
- Si vous avez une erreur ici, voir au début de l’article : Mise à jour #3
Remarque : sur mon serveur de test, la mise à jour s’est bien déroulée. Sur la PROD, j’ai eu l’erreur cité plus haut.
- Cliquez sur Next
- Cliquez sur Finish
Connectez-vous à Centreon.
Mise à jour des Modules & Widgets
- Allez dans le menu : Administration > Extensions > Gestionnaire
- Commencer par mettre à jour d’abord les modules suivant (si vous les utilisez) :
- License Manager
- Plugin Packs Manager
- Auto Discovery
- Cliquez ensuite sur Update All pour mettre à jours tous les widgets :
Démarrage de la supervision
Cette nouvelle version de Centreon a changé son gestionnaire de tâches en passant de Centcore à Gorgone.
Il faut donc arrêter le service Centcore et démarrer le nouveau gestionnaire de tâches :
[root@vm-centreon ~]# systemctl stop centcore [root@vm-centreon ~]# systemctl disable centcore
Lancer le nouveau service de gestionnaire de tâches :
[root@vm-centreon ~]# systemctl enable gorgoned
Created symlink from /etc/systemd/system/multi-user.target.wants/gorgoned.service to /etc/systemd/system/gorgoned.service.
Created symlink from /etc/systemd/system/centreon.service.wants/gorgoned.service to /etc/systemd/system/gorgoned.service.
[root@vm-centreon ~]#
[root@vm-centreon ~]# systemctl start gorgoned
[root@vm-centreon ~]# systemctl status gorgoned
● gorgoned.service - Centreon Gorgone
Loaded: loaded (/etc/systemd/system/gorgoned.service; enabled; vendor preset: disabled)
Active: active (running) since mer. 2020-05-06 00:57:04 CEST; 6s ago
Main PID: 7226 (perl)
CGroup: /system.slice/gorgoned.service
├─7226 /usr/bin/perl /usr/bin/gorgoned --config=/etc/centreon-gorgone/config.yaml --logfile=/var/log/centreon-gorgone/gorgoned.log --severity=info
├─7235 gorgone-nodes
├─7236 gorgone-dbcleaner
├─7237 gorgone-autodiscovery
├─7238 gorgone-cron
├─7239 gorgone-engine
├─7240 gorgone-statistics
├─7241 gorgone-action
├─7242 gorgone-httpserver
├─7243 gorgone-legacycmd
├─7298 gorgone-proxy
├─7299 gorgone-proxy
├─7300 gorgone-proxy
├─7301 gorgone-proxy
└─7302 gorgone-proxy
mai 06 00:57:04 vm-centreon.pixelabs.lan systemd[1]: Started Centreon Gorgone.
[root@vm-centreon ~]#
Changer les droits sur les fichiers RRD en exécutant la commande suivante :
[root@vm-centreon ~]# chown -R centreon-gorgone /var/lib/centreon/nagios-perf/*
Exporter la configuration depuis l’interface web de Centreon :
- Allez dans Configuration > Collecteurs
- Cochez votre collecteur : Central
- Cliquez sur Exporter la configuration
Relancer les services Centreon :
[root@vm-centreon ~]# systemctl restart cbd [root@vm-centreon ~]# systemctl restart centengine
Mise à jour MariaDB 10.1 vers 10.2
Centreon 20.04.0 utilise la version 10.3. Il faut donc mettre à jour MariaDB.
Pour connaître la version, connectez-vous à MariaDB : Server version : 10.1
[root@vm-centreon ~]# mysql -u root Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 18865 Server version: 10.1.38-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
Remarque : comme indiqué sur la doc Centreon et sur la doc officielle, il faut mettre à jour MariaDB en passant par chacune des versions.
- Update MariaDB 10.1 vers 10.2
- Update MariaDB 10.2 vers 10.3
Avant de réaliser cette opération, éditez le fichier suivant : /etc/my.cnf.d/centreon.cnf
[root@vm-centreon ~]# nano /etc/my.cnf.d/centreon.cnf
Supprimer le paramètre : innodb_additional_mem_pool_size
# # Custom MySQL/MariaDB server configuration for Centreon # [server] innodb_file_per_table=1 open_files_limit = 32000 key_buffer_size = 256M sort_buffer_size = 32M join_buffer_size = 4M thread_cache_size = 64 read_buffer_size = 512K read_rnd_buffer_size = 256K max_allowed_packet = 8M # For 4 Go Ram #innodb_additional_mem_pool_size=512M #innodb_buffer_pool_size=512M # For 8 Go Ram #innodb_additional_mem_pool_size=1G #innodb_buffer_pool_size=1G
Depuis la version MariaDB 10.2, ce paramètre n’est plus utilisé.
Arrêter le service MariaDB :
[root@vm-centreon ~]# systemctl stop mariadb
Désinstaller la version actuelle 10.1 :
[root@vm-centreon ~]# rpm --erase --nodeps --verbose MariaDB-server MariaDB-client MariaDB-shared MariaDB-compat MariaDB-common Préparation des paquets... MariaDB-server-10.1.38-1.el7.centos.x86_64 MariaDB-client-10.2.26-1.el7.centos.x86_64 MariaDB-shared-10.3.22-1.el7.centos.x86_64 MariaDB-compat-10.2.26-1.el7.centos.x86_64 attention : fichier /usr/lib64/libmysqlclient_r.so.18.0.0 : échec de la suppression : Aucun fichier ou dossier de ce type attention : fichier /usr/lib64/libmysqlclient_r.so.18 : échec de la suppression : Aucun fichier ou dossier de ce type MariaDB-common-10.2.26-1.el7.centos.x86_64 [root@vm-centreon ~]#
Installer la version 10.2 :
[root@vm-centreon ~]# yum install MariaDB-server-10.2\* MariaDB-client-10.2\* MariaDB-shared-10.2\* MariaDB-compat-10.2\* MariaDB-common-10.2\* Modules complémentaires chargés : fastestmirror Loading mirror speeds from cached hostfile * base: centos.mirrors.proxad.net * centos-sclo-rh: centos.mirrors.proxad.net * centos-sclo-sclo: centos.mirrors.proxad.net * extras: centos.mirrors.proxad.net * updates: centos.mirrors.proxad.net Résolution des dépendances --> Lancement de la transaction de test ---> Le paquet MariaDB-client.x86_64 0:10.2.31-1.el7.centos sera installé ---> Le paquet MariaDB-common.x86_64 0:10.2.31-1.el7.centos sera installé ---> Le paquet MariaDB-compat.x86_64 0:10.2.31-1.el7.centos sera installé ---> Le paquet MariaDB-server.x86_64 0:10.2.31-1.el7.centos sera installé ---> Le paquet MariaDB-shared.x86_64 0:10.2.31-1.el7.centos sera installé --> Résolution des dépendances terminée [...]
Démarrer le service MariaDB :
[root@vm-centreon ~]# systemctl start mariadb
Lancer le processus de mise à jour :
[root@vm-centreon ~]# mysql_upgrade Phase 1/7: Checking and upgrading mysql database Processing databases mysql mysql.column_stats OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.gtid_slave_pos OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.roles_mapping OK mysql.servers OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Phase 2/7: Installing used storage engines... Skipped Phase 3/7: Fixing views Phase 4/7: Running 'mysql_fix_privilege_tables' Phase 5/7: Fixing table and database names Phase 6/7: Checking and upgrading tables Processing databases centreon centreon.acl_actions OK centreon.acl_actions_rules OK centreon.acl_group_actions_relations OK centreon.acl_group_contactgroups_relations OK centreon.acl_group_contacts_relations OK centreon.acl_group_topology_relations OK centreon.acl_groups OK centreon.acl_res_group_relations OK centreon.acl_resources OK centreon.acl_resources_hc_relations OK centreon.acl_resources_hg_relations OK centreon.acl_resources_host_relations OK centreon.acl_resources_hostex_relations OK centreon.acl_resources_meta_relations OK centreon.acl_resources_poller_relations OK centreon.acl_resources_sc_relations OK centreon.acl_resources_service_relations OK centreon.acl_resources_sg_relations OK centreon.acl_topology OK centreon.acl_topology_relations OK centreon.auth_ressource OK centreon.auth_ressource_host OK centreon.auth_ressource_info OK centreon.cb_field OK centreon.cb_fieldgroup OK centreon.cb_fieldset OK centreon.cb_list OK centreon.cb_list_values OK centreon.cb_module OK centreon.cb_module_relation OK centreon.cb_tag OK centreon.cb_tag_type_relation OK centreon.cb_type OK centreon.cb_type_field_relation OK centreon.cfg_centreonbroker OK centreon.cfg_centreonbroker_info OK centreon.cfg_nagios OK centreon.cfg_nagios_broker_module OK centreon.cfg_resource OK centreon.cfg_resource_instance_relations OK centreon.command OK centreon.command_arg_description OK centreon.command_categories OK centreon.command_categories_relation OK centreon.connector OK centreon.contact OK centreon.contact_feature OK centreon.contact_host_relation OK centreon.contact_hostcommands_relation OK centreon.contact_param OK centreon.contact_service_relation OK centreon.contact_servicecommands_relation OK centreon.contactgroup OK centreon.contactgroup_contact_relation OK centreon.contactgroup_host_relation OK centreon.contactgroup_hostgroup_relation OK centreon.contactgroup_service_relation OK centreon.contactgroup_servicegroup_relation OK centreon.cron_operation OK centreon.css_color_menu OK centreon.custom_view_default OK centreon.custom_view_user_relation OK centreon.custom_views OK centreon.dependency OK centreon.dependency_hostChild_relation OK centreon.dependency_hostParent_relation OK centreon.dependency_hostgroupChild_relation OK centreon.dependency_hostgroupParent_relation OK centreon.dependency_metaserviceChild_relation OK centreon.dependency_metaserviceParent_relation OK centreon.dependency_serviceChild_relation OK centreon.dependency_serviceParent_relation OK centreon.dependency_servicegroupChild_relation OK centreon.dependency_servicegroupParent_relation OK centreon.downtime OK centreon.downtime_cache OK centreon.downtime_host_relation OK centreon.downtime_hostgroup_relation OK centreon.downtime_period OK centreon.downtime_service_relation OK centreon.downtime_servicegroup_relation OK centreon.escalation OK centreon.escalation_contactgroup_relation OK centreon.escalation_host_relation OK centreon.escalation_hostgroup_relation OK centreon.escalation_meta_service_relation OK centreon.escalation_service_relation OK centreon.escalation_servicegroup_relation OK centreon.extended_host_information OK centreon.extended_service_information OK centreon.giv_components_template OK centreon.giv_graphs_template OK centreon.host OK centreon.host_hostparent_relation OK centreon.host_service_relation OK centreon.host_template_relation OK centreon.hostcategories OK centreon.hostcategories_relation OK centreon.hostgroup OK centreon.hostgroup_hg_relation OK centreon.hostgroup_relation OK centreon.informations OK centreon.locale OK centreon.meta_contact OK centreon.meta_contactgroup_relation OK centreon.meta_service OK centreon.meta_service_relation OK centreon.modules_informations OK centreon.nagios_macro OK centreon.nagios_server OK centreon.ns_host_relation OK centreon.ods_view_details OK centreon.on_demand_macro_command OK centreon.on_demand_macro_host OK centreon.on_demand_macro_service OK centreon.options OK centreon.poller_command_relations OK centreon.remote_servers OK centreon.rs_poller_relation OK centreon.service OK centreon.service_categories OK centreon.service_categories_relation OK centreon.servicegroup OK centreon.servicegroup_relation OK centreon.session OK centreon.task OK centreon.timeperiod OK centreon.timeperiod_exceptions OK centreon.timeperiod_exclude_relations OK centreon.timeperiod_include_relations OK centreon.timezone OK centreon.topology OK centreon.topology_JS OK centreon.traps OK centreon.traps_group OK centreon.traps_group_relation OK centreon.traps_matching_properties OK centreon.traps_preexec OK centreon.traps_service_relation OK centreon.traps_vendor OK centreon.view_img OK centreon.view_img_dir OK centreon.view_img_dir_relation OK centreon.virtual_metrics OK centreon.widget_models OK centreon.widget_parameters OK centreon.widget_parameters_field_type OK centreon.widget_parameters_multiple_options OK centreon.widget_parameters_range OK centreon.widget_preferences OK centreon.widget_views OK centreon.widgets OK centreon.ws_token OK centreon_storage centreon_storage.acknowledgements OK centreon_storage.centreon_acl OK centreon_storage.comments OK centreon_storage.config OK centreon_storage.customvariables OK centreon_storage.data_bin OK centreon_storage.data_stats_daily OK centreon_storage.data_stats_monthly OK centreon_storage.data_stats_yearly OK centreon_storage.downtimes OK centreon_storage.eventhandlers OK centreon_storage.flappingstatuses OK centreon_storage.hostgroups OK centreon_storage.hosts OK centreon_storage.hosts_hostgroups OK centreon_storage.hosts_hosts_dependencies OK centreon_storage.hosts_hosts_parents OK centreon_storage.hoststateevents OK centreon_storage.index_data OK centreon_storage.instances OK centreon_storage.issues OK centreon_storage.issues_issues_parents OK centreon_storage.log_action OK centreon_storage.log_action_modification OK centreon_storage.log_archive_host OK centreon_storage.log_archive_last_status OK centreon_storage.log_archive_service OK centreon_storage.log_traps OK centreon_storage.log_traps_args OK centreon_storage.logs OK centreon_storage.metrics OK centreon_storage.modules OK centreon_storage.nagios_stats OK centreon_storage.notifications OK centreon_storage.schemaversion OK centreon_storage.servicegroups OK centreon_storage.services OK centreon_storage.services_servicegroups OK centreon_storage.services_services_dependencies OK centreon_storage.servicestateevents OK information_schema performance_schema test Phase 7/7: Running 'FLUSH PRIVILEGES' OK [root@vm-centreon ~]#
Si vous avez l’erreur :
[root@vm-centreon ~]# mysql_upgrade Version check failed. Got the following error when calling the 'mysql' command line client ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) FATAL ERROR: Upgrade failed
Vous avez protégé le compte root par mot de passe. Lancer la commande avec le compte root et le mot de passe de votre base de données mariadb.
[root@vm-centreon ~]# mysql_upgrade -u root -p Enter password:
Mise à jour MariaDB 10.2 vers 10.3
Il faut répéter l’opération une dernière fois.
Arrêtez le service MariaDB :
[root@vm-centreon ~]# systemctl stop mariadb
Désinstallez maintenant la version 10.2 :
[root@vm-centreon ~]# rpm --erase --nodeps --verbose MariaDB-server MariaDB-client MariaDB-shared MariaDB-compat MariaDB-common Préparation des paquets... MariaDB-server-10.2.31-1.el7.centos.x86_64 MariaDB-client-10.2.31-1.el7.centos.x86_64 MariaDB-shared-10.2.31-1.el7.centos.x86_64 MariaDB-compat-10.2.31-1.el7.centos.x86_64 attention : fichier /usr/lib64/libmysqlclient_r.so.18.0.0 : échec de la suppression : Aucun fichier ou dossier de ce type attention : fichier /usr/lib64/libmysqlclient_r.so.18 : échec de la suppression : Aucun fichier ou dossier de ce type MariaDB-common-10.2.31-1.el7.centos.x86_64 [root@vm-centreon ~]#
Installation la version 10.3 :
[root@vm-centreon ~]# yum install MariaDB-server-10.3\* MariaDB-client-10.3\* MariaDB-shared-10.3\* MariaDB-compat-10.3\* MariaDB-common-10.3\* Modules complémentaires chargés : fastestmirror Loading mirror speeds from cached hostfile * base: centos.mirrors.proxad.net * centos-sclo-rh: centos.mirrors.proxad.net * centos-sclo-sclo: centos.mirrors.proxad.net * extras: centos.mirrors.proxad.net * updates: centos.mirrors.proxad.net Résolution des dépendances --> Lancement de la transaction de test ---> Le paquet MariaDB-client.x86_64 0:10.3.22-1.el7.centos sera installé ---> Le paquet MariaDB-common.x86_64 0:10.3.22-1.el7.centos sera installé ---> Le paquet MariaDB-compat.x86_64 0:10.3.22-1.el7.centos sera installé ---> Le paquet MariaDB-server.x86_64 0:10.3.22-1.el7.centos sera installé ---> Le paquet MariaDB-shared.x86_64 0:10.3.22-1.el7.centos sera installé --> Résolution des dépendances terminée [...]
Démarrez le service MariaDB :
[root@vm-centreon ~]# systemctl start mariadb
Lancez le processus de mise à jour :
[root@vm-centreon ~]# mysql_upgrade Phase 1/7: Checking and upgrading mysql database Processing databases mysql mysql.column_stats OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.gtid_slave_pos OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.roles_mapping OK mysql.servers OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Phase 2/7: Installing used storage engines... Skipped Phase 3/7: Fixing views Phase 4/7: Running 'mysql_fix_privilege_tables' Phase 5/7: Fixing table and database names Phase 6/7: Checking and upgrading tables Processing databases centreon centreon.acl_actions OK centreon.acl_actions_rules OK centreon.acl_group_actions_relations OK centreon.acl_group_contactgroups_relations OK centreon.acl_group_contacts_relations OK centreon.acl_group_topology_relations OK centreon.acl_groups OK centreon.acl_res_group_relations OK centreon.acl_resources OK centreon.acl_resources_hc_relations OK centreon.acl_resources_hg_relations OK centreon.acl_resources_host_relations OK centreon.acl_resources_hostex_relations OK centreon.acl_resources_meta_relations OK centreon.acl_resources_poller_relations OK centreon.acl_resources_sc_relations OK centreon.acl_resources_service_relations OK centreon.acl_resources_sg_relations OK centreon.acl_topology OK centreon.acl_topology_relations OK centreon.auth_ressource OK centreon.auth_ressource_host OK centreon.auth_ressource_info OK centreon.cb_field OK centreon.cb_fieldgroup OK centreon.cb_fieldset OK centreon.cb_list OK centreon.cb_list_values OK centreon.cb_module OK centreon.cb_module_relation OK centreon.cb_tag OK centreon.cb_tag_type_relation OK centreon.cb_type OK centreon.cb_type_field_relation OK centreon.cfg_centreonbroker OK centreon.cfg_centreonbroker_info OK centreon.cfg_nagios OK centreon.cfg_nagios_broker_module OK centreon.cfg_resource OK centreon.cfg_resource_instance_relations OK centreon.command OK centreon.command_arg_description OK centreon.command_categories OK centreon.command_categories_relation OK centreon.connector OK centreon.contact OK centreon.contact_feature OK centreon.contact_host_relation OK centreon.contact_hostcommands_relation OK centreon.contact_param OK centreon.contact_service_relation OK centreon.contact_servicecommands_relation OK centreon.contactgroup OK centreon.contactgroup_contact_relation OK centreon.contactgroup_host_relation OK centreon.contactgroup_hostgroup_relation OK centreon.contactgroup_service_relation OK centreon.contactgroup_servicegroup_relation OK centreon.cron_operation OK centreon.css_color_menu OK centreon.custom_view_default OK centreon.custom_view_user_relation OK centreon.custom_views OK centreon.dependency OK centreon.dependency_hostChild_relation OK centreon.dependency_hostParent_relation OK centreon.dependency_hostgroupChild_relation OK centreon.dependency_hostgroupParent_relation OK centreon.dependency_metaserviceChild_relation OK centreon.dependency_metaserviceParent_relation OK centreon.dependency_serviceChild_relation OK centreon.dependency_serviceParent_relation OK centreon.dependency_servicegroupChild_relation OK centreon.dependency_servicegroupParent_relation OK centreon.downtime OK centreon.downtime_cache OK centreon.downtime_host_relation OK centreon.downtime_hostgroup_relation OK centreon.downtime_period OK centreon.downtime_service_relation OK centreon.downtime_servicegroup_relation OK centreon.escalation OK centreon.escalation_contactgroup_relation OK centreon.escalation_host_relation OK centreon.escalation_hostgroup_relation OK centreon.escalation_meta_service_relation OK centreon.escalation_service_relation OK centreon.escalation_servicegroup_relation OK centreon.extended_host_information OK centreon.extended_service_information OK centreon.giv_components_template OK centreon.giv_graphs_template OK centreon.host OK centreon.host_hostparent_relation OK centreon.host_service_relation OK centreon.host_template_relation OK centreon.hostcategories OK centreon.hostcategories_relation OK centreon.hostgroup OK centreon.hostgroup_hg_relation OK centreon.hostgroup_relation OK centreon.informations OK centreon.locale OK centreon.meta_contact OK centreon.meta_contactgroup_relation OK centreon.meta_service OK centreon.meta_service_relation OK centreon.modules_informations OK centreon.nagios_macro OK centreon.nagios_server OK centreon.ns_host_relation OK centreon.ods_view_details OK centreon.on_demand_macro_command OK centreon.on_demand_macro_host OK centreon.on_demand_macro_service OK centreon.options OK centreon.poller_command_relations OK centreon.remote_servers OK centreon.rs_poller_relation OK centreon.service OK centreon.service_categories OK centreon.service_categories_relation OK centreon.servicegroup OK centreon.servicegroup_relation OK centreon.session OK centreon.task OK centreon.timeperiod OK centreon.timeperiod_exceptions OK centreon.timeperiod_exclude_relations OK centreon.timeperiod_include_relations OK centreon.timezone OK centreon.topology OK centreon.topology_JS OK centreon.traps OK centreon.traps_group OK centreon.traps_group_relation OK centreon.traps_matching_properties OK centreon.traps_preexec OK centreon.traps_service_relation OK centreon.traps_vendor OK centreon.view_img OK centreon.view_img_dir OK centreon.view_img_dir_relation OK centreon.virtual_metrics OK centreon.widget_models OK centreon.widget_parameters OK centreon.widget_parameters_field_type OK centreon.widget_parameters_multiple_options OK centreon.widget_parameters_range OK centreon.widget_preferences OK centreon.widget_views OK centreon.widgets OK centreon.ws_token OK centreon_storage centreon_storage.acknowledgements OK centreon_storage.centreon_acl OK centreon_storage.comments OK centreon_storage.config OK centreon_storage.customvariables OK centreon_storage.data_bin OK centreon_storage.data_stats_daily OK centreon_storage.data_stats_monthly OK centreon_storage.data_stats_yearly OK centreon_storage.downtimes OK centreon_storage.eventhandlers OK centreon_storage.flappingstatuses OK centreon_storage.hostgroups OK centreon_storage.hosts OK centreon_storage.hosts_hostgroups OK centreon_storage.hosts_hosts_dependencies OK centreon_storage.hosts_hosts_parents OK centreon_storage.hoststateevents OK centreon_storage.index_data OK centreon_storage.instances OK centreon_storage.issues OK centreon_storage.issues_issues_parents OK centreon_storage.log_action OK centreon_storage.log_action_modification OK centreon_storage.log_archive_host OK centreon_storage.log_archive_last_status OK centreon_storage.log_archive_service OK centreon_storage.log_traps OK centreon_storage.log_traps_args OK centreon_storage.logs OK centreon_storage.metrics OK centreon_storage.modules OK centreon_storage.nagios_stats OK centreon_storage.notifications OK centreon_storage.schemaversion OK centreon_storage.servicegroups OK centreon_storage.services OK centreon_storage.services_servicegroups OK centreon_storage.services_services_dependencies OK centreon_storage.servicestateevents OK information_schema performance_schema test Phase 7/7: Running 'FLUSH PRIVILEGES' OK [root@vm-centreon ~]#
Activez le démarrage automatique de MariaDB :
[root@vm-centreon ~]# systemctl enable mariadb Created symlink from /etc/systemd/system/mysql.service to /usr/lib/systemd/system/mariadb.service. Created symlink from /etc/systemd/system/mysqld.service to /usr/lib/systemd/system/mariadb.service. Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service. [root@vm-centreon ~]#
[root@vm-centreon ~]# systemctl status mariadb
● mariadb.service - MariaDB 10.3.22 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─centreon.conf, limits.conf, migrated-from-my.cnf-settings.conf
Active: active (running) since mer. 2020-05-06 01:43:32 CEST; 1s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 12528 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 12457 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 12455 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 12496 (mysqld)
Status: "Taking your SQL requests now..."
CGroup: /system.slice/mariadb.service
└─12496 /usr/sbin/mysqld
mai 06 01:43:32 vm-centreon.pixelabs.lan mysqld[12496]: 2020-05-06 1:43:32 0 [Note] InnoDB: 10.3.22 started; log sequence number 43302047; transaction id 500541
mai 06 01:43:32 vm-centreon.pixelabs.lan mysqld[12496]: 2020-05-06 1:43:32 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mai 06 01:43:32 vm-centreon.pixelabs.lan mysqld[12496]: 2020-05-06 1:43:32 0 [Note] Plugin 'FEEDBACK' is disabled.
mai 06 01:43:32 vm-centreon.pixelabs.lan mysqld[12496]: 2020-05-06 1:43:32 0 [Note] InnoDB: Buffer pool(s) load completed at 200506 1:43:32
mai 06 01:43:32 vm-centreon.pixelabs.lan mysqld[12496]: 2020-05-06 1:43:32 0 [Note] Server socket created on IP: '::'.
mai 06 01:43:32 vm-centreon.pixelabs.lan mysqld[12496]: 2020-05-06 1:43:32 0 [Note] Reading of all Master_info entries succeeded
mai 06 01:43:32 vm-centreon.pixelabs.lan mysqld[12496]: 2020-05-06 1:43:32 0 [Note] Added new Master_info '' to hash table
mai 06 01:43:32 vm-centreon.pixelabs.lan mysqld[12496]: 2020-05-06 1:43:32 0 [Note] /usr/sbin/mysqld: ready for connections.
mai 06 01:43:32 vm-centreon.pixelabs.lan mysqld[12496]: Version: '10.3.22-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
mai 06 01:43:32 vm-centreon.pixelabs.lan systemd[1]: Started MariaDB 10.3.22 database server.
[root@vm-centreon ~]#C’est terminé. Vérifie que tout fonctionne :
Remarque : pour mettre à jour un collecteur distant, répétez l’opération (sans mise à jour via l’interface web).
A ne pas oublier :
- Vérifiez le bon fonctionnement de votre serveur : Administration > Statut de la plateforme > Statistiques du broker
- Activer la sauvegarde de Centreon : Administration > Paramètres > Backup
- Vérifiez l’état de votre collecteur : Configuration > Collecteurs
Supervision des systèmes & Réseaux
Mes articles sur la supervision avec Centreon :
- Supervision Certificat HTTPS/Windows : supervision-des-certificats-https-windows/
- Supervision Web HTTP(S) : supervision-https-response-expected-content-centreon/
- Supervision ORACLE BDD : oracle-database-monitoring-centreon-plugins/
- Supervision EMC VNX : vnx5300-vnx5200-monitoring-centreon/
- Supervision MSSQL : microsoft-sql-server-monitoring/
- Supervision Switch CISCO : switch-cisco-centreon-partie-1-2/
- Supervision VMWARE ESXi : vmware-esxi-6-7-monitoring/
- Supervision EXCHANGE Server : exchange-server-2016-monitoring-actif/
- Supervision Quotas Windows : supervision-des-quotas-windows-nrpe-nsclient/
- Supervision Skype for Business : supervision-microsoft-skype-for-business/
- Supervision HPE Proliant Gen10 : supervision-hpe-proliant-gen10-snmp-restapi/
- Supervision NETAPP SANTricity : supervision-netapp-santricity-storage-restapi/
Certaines applications/serveurs nécessitent l’installation d’un client/module sur le serveur Centreon.
- Oracle Database : oracle-client-19c-installation-sous-centos7-centreon
- EMC VNX Series : installer NaviSECCLI
- VMware ESXi : Centreon-vmware et le package VMware Perl SDK
- Les protocoles de supervision à configurer : SNMP, NRPE, NSClient…etc.
- Configuration SNMP : snmp-win-unix-esxi-cisco/
- Installation NSClient++ / NRPE :windows-nrpe-nsclient/
Ajouter mon pack d’icônes : Centreon-icones-Pack
Bonne journée à tous.
