{"id":293,"date":"2026-04-08T01:11:23","date_gmt":"2026-04-07T23:11:23","guid":{"rendered":"https:\/\/pandack.fr\/?p=293"},"modified":"2026-04-08T01:11:23","modified_gmt":"2026-04-07T23:11:23","slug":"installation-centreon-et-serveur-sql-deportes","status":"publish","type":"post","link":"https:\/\/pandack.fr\/?p=293","title":{"rendered":"Installation-Centreon-et-Serveur-SQL-deportes"},"content":{"rendered":"<p>Dans le cas du serveur MySQL et PHPmyAmin d\u00e9j\u00e0 installer se r\u00e9f\u00e9rer directement au chapitre : <a href=\"#Centreon\" target=\"_blank\" rel=\"noopener\">Centreon<\/a><\/p>\n<h2>Installation Serveur MySQL <\/h2>\n<p>Le serveur comprenant mariadb et phpmyadmin sera sur une distribution linux : Alma 9.7<\/p>\n<ul>\n<li>Hostname : sql-sev<\/li>\n<li>ip : 10.10.20.40\/24<\/li>\n<li>Passerelle : 10.10.20.1<\/li>\n<\/ul>\n<p>La version\u202f9.7 est actuellement la plus stable, et c\u2019est aussi celle qui b\u00e9n\u00e9ficie du meilleur support ainsi que de la disponibilit\u00e9 compl\u00e8te des paquets<\/p>\n<ul>\n<li>Installation de MariaDb<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">bash<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code class=\"language-bash\">sudo dnf install mariadb-server<\/code><\/pre>\n<\/div>\n<ul>\n<li>D\u00e9marrer le service mariadb<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">bash<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code class=\"language-bash\">sudo systemctl start mariadb.service\n\n#v\u00e9rifier son status \nsudo systemctl status mariadb.service<\/code><\/pre>\n<\/div>\n<ul>\n<li>Tester le fonctionne de mariadb<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>sudo mysql --user root --execute &quot;select version()&quot;\n\n# R\u00e9sultat :\n+-----------------+\n| version()       |\n+-----------------+\n| 10.5.29-MariaDB |\n+-----------------+<\/code><\/pre>\n<\/div>\n<ul>\n<li>Lancer mariadb au lancement de la machine :<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">bash<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code class=\"language-bash\">sudo systemctl enable mariadb.service<\/code><\/pre>\n<\/div>\n<ul>\n<li>S\u00e9curisation<\/li>\n<\/ul>\n<p>Lancer le programme d&rsquo;installation pour configurer les param\u00e8tre de s\u00e9curit\u00e9 mariadb<\/p>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>mysql_secure_installation\n\n# Switch to unix_socket authentification : N\n# Changer root password : N\n# Remove anonymous users? Y\n# Disallow root login remotely? Y\n# Remove test database and access to it? Y\n# Reload privilege tables now? Y<\/code><\/pre>\n<\/div>\n<ul>\n<li>Pour ce connect on va utilis\u00e9 la commande :<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">bash<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code class=\"language-bash\">mysql --user root<\/code><\/pre>\n<\/div>\n<ul>\n<li>Pour changer de mot de passe pour le compte root sur mariadb<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">bash<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code class=\"language-bash\">mysql --user root --password --execute &quot;select version()&quot;<\/code><\/pre>\n<\/div>\n<ul>\n<li>Si mot de passe perdu de root<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code># systemctl stop mariadb.service\n# mysqld_safe --skip-grant-tables --skip-networking  &amp;\n# mysql\nmysql&gt; UPDATE mysql.user SET Password=PASSWORD(&#039;NouveauMotDePasse&#039;) WHERE User=&#039;root&#039;;\nmysql&gt; FLUSH PRIVILEGES;\nmysql&gt; exit\n# mysqladmin shutdown\n# systemctl start mariadb.service<\/code><\/pre>\n<\/div>\n<h2>Installation PHPmyadmin<\/h2>\n<ul>\n<li>Installation de php :<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code># Permet de verifier la version, si inexistant il propose l&#039;installation\nphp -v<\/code><\/pre>\n<\/div>\n<ul>\n<li>Installation des d\u00e9pots &amp; mise \u00e0 jour<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>sudo dnf install epel-release -y\nsudo dnf update -y<\/code><\/pre>\n<\/div>\n<ul>\n<li>Installation de phpmyadmin<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>sudo dnf install phpmyadmin -y<\/code><\/pre>\n<\/div>\n<ul>\n<li>Modifier le fichier : <code>\/etc\/httpd\/conf.d\/phpMyAdmin.conf<\/code><\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">bash<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code class=\"language-bash\"># Modifier les lignes Require Local par :\nRequire all granted\n# ou pour une limitation au r\u00e9seau local :\nRequire ip 10.10.20.0\/24<\/code><\/pre>\n<\/div>\n<ul>\n<li>R\u00e9d\u00e9marrer les service httpd<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>sudo systemctl restart httpd<\/code><\/pre>\n<\/div>\n<ul>\n<li>Se connect\u00e9 \u00e0 phpmyadmin sur : http:\/\/10.10.20.40\/phpmyadmin<\/li>\n<\/ul>\n<p>\t&#8211; User : Root<br \/>\n\t&#8211; Password : root session password<\/p>\n<p>On peux constast\u00e9 que la base fonction bien et elle identique via mysql et phpmyadmin<\/p>\n<h2>Centreon<\/h2>\n<p>Centreon utilisera la distribution Alma Linux 9.7 pour une meilleurs stabilit\u00e9 et recommand\u00e9 par centreon :<\/p>\n<ul>\n<li>HOSTNAME : centreon-serv<\/li>\n<li>Ip : 10.10.20.30\/24<\/li>\n<li>passerelle : 10.10.20.1<\/li>\n<\/ul>\n<h2>Installation des d\u00e9pots<\/h2>\n<ul>\n<li>Installation des paquets en fran\u00e7ais&#8230; si n\u00e9cessaires<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">bash<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code class=\"language-bash\">sudo dnf install glibc-langpack-fr<\/code><\/pre>\n<\/div>\n<ul>\n<li>D\u00e9sactiver SELINUX : D\u00e9sactivation temporaire pendant l&rsquo;installation de Centreon. Pour des raisons de s\u00e9curit\u00e9, il dot \u00eatre r\u00e9activer apr\u00e8s l&rsquo;installation<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">bash<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code class=\"language-bash\">sudo sed -i s\/^SELINUX=.*$\/SELINUX=disabled\/ \/etc\/selinux\/config<\/code><\/pre>\n<\/div>\n<ul>\n<li>R\u00e9d\u00e9marrer<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">bash<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code class=\"language-bash\">sudo Reboot<\/code><\/pre>\n<\/div>\n<ul>\n<li>V\u00e9rifier si SElinux est bien en \u00e9tat <code>Disable<\/code><\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>getenforce<\/code><\/pre>\n<\/div>\n<ul>\n<li>D\u00e9sactiver le pare-feu pendant le temps de l&rsquo;installation :<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>sudo systemctl stop firewalld\nsudo systemctl disable firewalld<\/code><\/pre>\n<\/div>\n<ul>\n<li>Installation des d\u00e9pots pour Alma 9 :<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>sudo dnf install dnf-plugins-core\nsudo dnf install epel-release\nsudo dnf config-manager --set-enabled crb<\/code><\/pre>\n<\/div>\n<ul>\n<li>Activez PHP 8.2 avec la commande suivante :<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>sudo dnf module reset php\nsudo dnf module install php:8.2<\/code><\/pre>\n<\/div>\n<ul>\n<li>Activer le module mariadb :<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>dnf module enable -y mariadb:10.11<\/code><\/pre>\n<\/div>\n<ul>\n<li>Installation des d\u00e9pots centreon :<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>sudo dnf config-manager --add-repo https:\/\/packages.centreon.com\/rpm-standard\/25.10\/el9\/centreon-25.10.repo\nsudo dnf clean all --enablerepo=*\nsudo dnf update<\/code><\/pre>\n<\/div>\n<h2>Installation de Centreon avec une base de donn\u00e9es d\u00e9port\u00e9e <\/h2>\n<div class=\"callout callout--warning\">\n<div class=\"callout__title\">&gt; Si vous installez la base de donn\u00e9es sur un serveur d\u00e9di\u00e9, ce serveur doit \u00e9galement avoir les d\u00e9p\u00f4ts requis.<\/div>\n<div class=\"callout__content\"><\/div>\n<\/div>\n<ul>\n<li>Installation du serveur central :<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>dnf install -y centreon-central<\/code><\/pre>\n<\/div>\n<ul>\n<li>Ex\u00e9cuter l&rsquo;installation de centreon-mariadb sur le serveur sql (SQL-SRV &#8211; 10.10.20.40)<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>dnf install -y centreon-mariadb\nsystemctl daemon-reload\nsystemctl restart mariadb<\/code><\/pre>\n<\/div>\n<ul>\n<li>Sur (SQL-SRV &#8211; 10.10.20.40), se connect\u00e9 \u00e0 sql avec root :<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">bash<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code class=\"language-bash\">mysql --user root<\/code><\/pre>\n<\/div>\n<ul>\n<li>Cr\u00e9er la base de donn\u00e9e pour centreon :<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">mysql<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code class=\"language-mysql\"># BASE \nCREATE USER &#039;&lt;UTILISATEUR&gt;&#039;@&#039;&lt;IP_SERVEUR_CENTRAL&gt;&#039; IDENTIFIED BY &#039;&lt;MOT_DE_PASSE&gt;&#039;;\nGRANT ALL PRIVILEGES ON *.* TO &#039;&lt;UTILISATEUR&gt;&#039;@&#039;&lt;IP_SERVEUR_CENTRAL&gt;&#039; WITH GRANT OPTION;\nFLUSH PRIVILEGES;\n\n# Mes param\u00e8tres \nCREATE USER &#039;Centreon&#039;@&#039;10.10.20.30&#039; IDENTIFIED BY &#039;rocknroll&#039;;\nGRANT ALL PRIVILEGES ON *.* TO &#039;Centreon&#039;@&#039;10.10.20.30&#039; WITH GRANT OPTION;\nFLUSH PRIVILEGES;<\/code><\/pre>\n<\/div>\n<div class=\"callout callout--info\">\n<div class=\"callout__title\">&gt; Cet utilisateur ne sera utilis\u00e9 que pour le processus d&#039;installation. Une fois l&#039;installation web termin\u00e9e, vous pouvez supprimer cet utilisateur via la commande suivante :<\/div>\n<div class=\"callout__content\"><code>DROP USER &#039;&lt;UTILISATEUR&gt;&#039;@&#039;&lt;IP_SERVEUR_CENTRAL&gt;&#039;;<\/code><\/div>\n<\/div>\n<ul>\n<li>Sur le serveur centreon d\u00e9marer les services :<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>sudo systemctl enable php-fpm httpd centreon cbd centengine gorgoned snmptrapd centreontrapd snmpd\nsudo systemctl enable crond\nsudo systemctl start crond<\/code><\/pre>\n<\/div>\n<ul>\n<li>Sur le serveur sql d\u00e9marrer les services :<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>sudo systemctl enable mariadb\nsudo systemctl restart mariadb<\/code><\/pre>\n<\/div>\n<ul>\n<li>Sur le serveur centreon d\u00e9marrer les services httpd<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>systemctl start httpd<\/code><\/pre>\n<\/div>\n<h2>Installation Web Centreon <\/h2>\n<ul>\n<li>Pour ce connecter \u00e0 centreon sur un navigateur : <code>http:\/\/10.10.20.30\/centreon<\/code><\/li>\n<\/ul>\n<ul>\n<li>Suivre les instruction d&rsquo;installation et v\u00e9rifier si tout les module sont bien en <code>loaded<\/code><\/li>\n<\/ul>\n<ul>\n<li>Ne pas toucher au chemin de monitoring par default<\/li>\n<\/ul>\n<ul>\n<li>Admin information :<\/li>\n<\/ul>\n<p>\t&#8211; Cr\u00e9er un mot de passe s\u00e9curis\u00e9<br \/>\n\t&#8211; d\u00e9finir nom \/ pr\u00e9nom \/ email<\/p>\n<ul>\n<li>Datanase information<\/li>\n<\/ul>\n<p>\t&#8211; Database Host Address : 10.10.20.40 (serveur sql)<br \/>\n\t&#8211; User (root) : Centreon (cr\u00e9ation lors de la database centreon dans mariadb)<br \/>\n\t&#8211; pass : rocknroll (cr\u00e9ation lors de la database centreon dans mariadb)<\/p>\n<div class=\"callout callout--warning\">\n<div class=\"callout__title\">&gt; Il est possible que lors de la connection \u00e0 la database, le pare-feux bloque l&#039;acc\u00e8s. Deux possible :<\/div>\n<div class=\"callout__content\">\n<ul>\n<li>Red\u00e9sactiver le pare feu provisoirement s&rsquo;il s&rsquo;est r\u00e9activer (voir plus haut)<\/li>\n<li>Ouvrir les ports sur le firewall du serveur sql<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<ul>\n<li>Ouvrir les ports sur le firewall sur le serveur sql<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>sudo firewall-cmd --add-port=3306\/tcp --permanent\nsudo firewall-cmd --reload\n\n# Pour v\u00e9rifier :\nsudo firewall-cmd --list-ports\n\n#R\u00e9d\u00e9marrer les services mysql\nsudo systemctl restart mysqld<\/code><\/pre>\n<\/div>\n<ul>\n<li>Pour tester si le port fonctionne bien depuis centreon :<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>nc -zv 10.10.20.40 3306<\/code><\/pre>\n<\/div>\n<ul>\n<li>Maintenant sur : http:\/\/10.10.20.30\/centreon\/ il est possible de se connecter avec le compte <code>admin<\/code> \u00e0 centreon.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Dans le cas du serveur MySQL et PHPmyAmin d\u00e9j\u00e0 installer se r\u00e9f\u00e9rer directement au chapitre : Centreon Installation Serveur MySQL Le serveur comprenant mariadb et phpmyadmin sera sur une distribution<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[166,172],"tags":[],"class_list":["post-293","post","type-post","status-publish","format-standard","hentry","category-infrastructure","category-infrastructure-siem"],"_links":{"self":[{"href":"https:\/\/pandack.fr\/index.php?rest_route=\/wp\/v2\/posts\/293","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pandack.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pandack.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pandack.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pandack.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=293"}],"version-history":[{"count":0,"href":"https:\/\/pandack.fr\/index.php?rest_route=\/wp\/v2\/posts\/293\/revisions"}],"wp:attachment":[{"href":"https:\/\/pandack.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pandack.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pandack.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}