{{tag>Brouillon}}

= Notes Centreon

** Je vous conseille de ne pas mettre en place Centreon **
Si vous avez besion d'une solution de supervision vous pouvez essayer Zabbix


== Généralités

''/etc/centreon-engine/resource.cfg''
<code python>
$USER1$=/usr/lib64/nagios/plugins
$CENTREONPLUGINS$=/usr/lib/centreon/plugins
</code>


== Conf via WebUI

Laisser les valeurs par défaut jusqu'à l'écran 4

Puis à l'écran 5: 
<code ->
password : yieCh4ha
Firt name : admin
Last name : admin
email : root@localhost
</code>

Ecran 6
<code ->
Database Host Address (default: localhost) : 192.168.5.1
Root password : [See roles/centreon-docker/templates/env.sh.j2]
Database user password : idem
</code>

<code ->
Dialogbox "Feature testing" => "No"
</code>

<code ->
Login
Configuration
Pollers
Check "Central"
Clic "Export configuration"
check all and select "Restart" Method
</code>


== Mise à jour

* Mettre à jour les paquets
* Mettre à jours les extensions via le Extensions Manager
* Mise à jour des Plugin Packs
* Lancer la procédure http://localhost/centreon/install/upgrade.php




== Reset mot de passe

Exemple pour admin / centreon
<code sql>
INSERT INTO contact_password (password, contact_id, creation_date) VALUES ('$2y$10$ubq1hJ9z3YPXBhejjae.Ie9u3AcMrwFNImPhOnnkLmEoNtwRGwNrC', 1, (SELECT UNIX_TIMESTAMP(NOW())));
</code>

== Logs

=== Partition DB

Voir :
* https://archives.sugarbug.fr/atelier/techniques/ihmweb/centreon/partitionnement-centreon/ 
* https://archives.sugarbug.fr/blog/files/tag-mysql.html

<code bash>
mysql -u centreon -p centreon_storage
</code>
<code sql>
ALTER TABLE logs REMOVE PARTITIONING;
</code>

<code bash>
su - centreon
php /usr/share/centreon/cron/centstorage_purge.php

php /usr/share/centreon/bin/centreon-partitioning.php -m data_bin
php /usr/share/centreon/bin/centreon-partitioning.php -m log_archive_service
php /usr/share/centreon/bin/centreon-partitioning.php -m log_archive_host
php /usr/share/centreon/bin/centreon-partitioning.php -m logs
</code>


== Autres

1
<code bash>
systemctl status cbd centengine gorgoned httpd
</code>


2
<code bash>
rm -f /var/lib/centreon/metrics/*
rm -f /var/lib/centreon/status/*
rm -f  /var/lib/centreon/nagios-perf/*/*
</code>

3
<code bash>
mysql -u centreon -p centreon_storage
</code>

<code sql>
DELETE logs_old ;
TRUNCATE logs ;

TRUNCATE servicestateevents ;

DELETE FROM data_bin WHERE id_metric NOT IN (SELECT metric_id FROM metrics) ;
</code>

<code bash>
su - centreon -c "/usr/share/centreon/cron/eventReportBuilder -r"
#su - centreon -c "/usr/share/centreon/cron/dashboardBuilder -r"

# CRON
su - centreon -c "/usr/share/centreon/cron/eventReportBuilder --config=/etc/centreon/conf.pm"
su - centreon -c "/usr/share/centreon/cron/dashboardBuilder --config=/etc/centreon/conf.pm"
</code>



== Pb

<code ->
# yum install -y centreon-base-config-centreon-engine centreon
--> Finished Dependency Resolution
Error: Package: nagios-plugins-perl-1.4.16-10.el7.centos.x86_64 (centreon-stable)
           Requires: nagios-plugins = 1.4.16-10.el7.centos
           Available: nagios-plugins-1.4.16-10.el7.centos.x86_64 (centreon-stable)
               nagios-plugins = 1.4.16-10.el7.centos
           Installing: nagios-plugins-2.3.3-2.el7.x86_64 (epel)
               nagios-plugins = 2.3.3-2.el7
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
 </code>
 
Solution
<code bash>
# repoquery --location centreon-plugins
http://yum.centreon.com/standard/3.4/el7/stable/noarch/RPMS/centreon-plugins-2.8.32-1.el7.centos.noarch.rpm
</code>

<code bash>
rpm -Uvh --nodeps $(repoquery --location centreon-plugins)
</code>