Centreon documentation

Centreon documentation

  • Documentation

›Administrate

Getting Started

  • Installation & first steps
  • Tutorials

    • Introduction
    • Create a custom view
    • Create a graphical view
    • Model your IT services
    • Analyze resources availability

Installation

  • Introduction
  • Prerequisites
  • Architectures
  • Download
  • Installation of a Central server

    • Using Centreon ISO
    • Using packages
    • Using virtual machines (VMs)
    • Using sources
  • Web And Post Installation
  • Installation of a Poller

    • Using Centreon ISO
    • Using packages

    Installation of a Remote server

    • Using Centreon ISO
    • Using packages
  • What is Centreon CEIP?

Monitoring

  • About Monitoring
  • Generic actions
  • Basic Objects

    • Macros
    • Commands
    • Time periods
    • Contacts
    • Hosts
    • Services
    • Meta Services
  • Templates
  • Plugin Packs
  • Monitoring Servers

    • Add a Poller to configuration
    • Add a Remote Server to configuration
    • Communications
    • Deploying a configuration
    • Advanced configuration
  • Groups & Categories
  • Passive Monitoring

    • Enable SNMP Traps
    • Create SNMP Traps definitions
    • Monitoring with SNMP Traps
    • Debug SNMP Traps management
    • Dynamic Service Management
  • Anomaly detection
  • Discovery

    • Introduction
    • Installation
    • Hosts Discovery
    • Services Discovery
    • Administration
  • Auto Remediation
  • Import/Export

Alerts & Notifications

  • Concepts
  • Events view (beta)
  • Event console
  • Manage Alerts
  • Notification

    • Concept
    • Configuration
    • Dependencies
    • Escalation
    • Flapping
    • To go further
  • Ticketing
  • Event Logs

Performance graphs

  • Charts managment
  • Graph template
  • Curves
  • Virtual metrics

Service Mapping

  • Introduction to Centreon BAM
  • Guide

    • Manage Business Activities
    • Monitor Business Activities
    • Report Business Activities
    • Settings
    • Widgets

    Administrate

    • Install Centreon BAM extension
    • Update the extension
    • Upgrade the extension
    • Migrate the extension
    • Install on a Remote Server

Graphical views

  • Introduction to Centreon MAP
  • Guide

    • Create a standard view
    • Create a geo view
    • Display views
    • Share a view

    Administrate

    • Install Centreon MAP extension
    • Update the extension
    • Upgrade the extension
    • Migrate the extension
    • Configure
    • Install on a Remote server
    • Procedures
    • Known issues
  • Release notes

Reporting

  • Introduction to Centreon MBI
  • Guide

    • Generate reports
    • Available reports
    • Widgets
    • Configure
    • Concepts
    • Report development

    Administrate

    • Install Centreon MBI extension
    • Update the extension
    • Upgrade the extension
    • Migrate the extension
    • Backup & restore

Administration

  • Secure your platform
  • Parameters

    • Centreon UI
    • Monitoring
    • Gorgone
    • LDAP
    • RRDTool
    • Debug
    • Data management
    • Medias
  • Access Control Lists
  • Extensions
  • Database partitioning
  • Centreon HA

    • Architectures
    • Installing a Centreon HA 2-nodes cluster
    • Installing a Centreon HA 4-nodes cluster
    • Monitoring Centreon-HA
    • Operating guide
    • Updating Centreon-HA platform
    • Upgrade from Centreon-Failover to Centreon-HA
    • Troubleshooting guide
  • Backup
  • Knowledge Base
  • Logging configuration changes
  • Platform statistics

Update, Upgrade & Migrate

    Update

    • Update a Centreon 20.04 platform

    Upgrade

    • Introduction to upgrade
    • Upgrade from Centreon 19.10
    • Upgrade from Centreon 19.04
    • Upgrade from Centreon 18.10
    • Upgrade from Centreon 3.4

    Migrate

    • Introduction
    • Migrate from a Centreon 3.4 platform
    • Nagios Reader to Centreon CLAPI
    • Migrate a platform with Poller Display module

Plugin Packs

  • Introduction to Plugin Packs
  • Tutorials

    • Collect OpenMetrics

    Applications

    • 3CX
    • Active Directory API
    • ActiveMQ JMX
    • Alyvix Server
    • Ansible
    • Ansible Tower
    • Antivirus ClamAV
    • Apache Server
    • Asterisk VoIP Server
    • Asterisk VoIP SNMP
    • Bind9 Web
    • BlueMind SSH
    • Cassandra
    • Cisco CMS
    • Cisco ISE
    • Cisco SSMS
    • Commvault CommServe Rest API
    • DRBD SSH
    • Dynatrace Rest API
    • Exchange 2010 API
    • Github
    • Github
    • Google Gsuite
    • Haproxy SNMP
    • Hibernate
    • IBM Tivoli Storage M
    • Microsoft IIS Server Restapi
    • Microsoft IIS Server NSClient API (Deprecated)
    • JBoss Server
    • Jenkins
    • Kafka
    • Kaspersky
    • Keepalived SNMP
    • Lync 2013
    • Maltem Insight Rest API
    • IP-Label datametrie API
    • IP-Label Newtest Rest API
    • McAfee Web Gateway
    • Microsoft Cluster Se
    • Microsoft IIS Server NRPE (Deprecated)
    • Microsoft SCCM
    • Microsoft WSUS
    • MS Active Directory
    • MS Biztalk
    • Graylog
    • MS Exchange 2K10
    • BlueMind
    • Mulesoft Anypoint
    • Netbackup Rest API
    • Netdata RestAPI
    • Nginx Server
    • Nginx Plus Restapi
    • OpenHeadend
    • OpenLDAP
    • OpenMetrics
    • OpenVPN OMI
    • OpenWeatherMap
    • Oracle VM Manager API
    • Pacemaker
    • Peoplesoft
    • Pfsense Fauxapi
    • PHP APC
    • PHP FPM
    • PVX
    • Quadstor
    • RabbitMQ RestAPI
    • Rapid Recovery SNMP
    • Redis Cli
    • Redis Restapi
    • Rubrik Rest API
    • Rudder
    • Salesforce
    • SAP HANA
    • SCOM Rest API
    • Gorgone Restapi
    • Selenium
    • Sendmail
    • Skype 2015
    • Solr
    • Squid SNMP
    • Symantec Netbackup
    • Tomcat JMX
    • Tomcat Webmanager
    • TrendMicro Iwsva
    • Varnish NRPE
    • Veeam
    • Veeam API
    • VerneMQ Restapi
    • VMware VCSA RestAPI
    • VTOM
    • Wazuh Rest API
    • Weblogic Server
    • ZIXI
    • Zookeeper

    Centreon

    • Centreon Central
    • Centreon Database
    • Centreon-HA
    • Centreon Map
    • Centreon Map4
    • Centreon MBI
    • Centreon Poller

    Cloud

    • Amazon API Gateway
    • Amazon CloudFront
    • Amazon CloudWatch
    • Amazon CloudWatch Logs
    • Amazon EBS
    • Amazon EC2
    • Amazon ElastiCache
    • Amazon EFS
    • Amazon Kinesis
    • Amazon RDS
    • Amazon S3
    • Amazon SES
    • Amazon SNS
    • Amazon SQS
    • AWS Billing
    • AWS ELB
    • AWS Health
    • AWS Lambda
    • AWS Transit Gateway
    • AWS VPN
    • Azure ExpressRoute
    • Azure Log Analytics
    • Azure Monitor
    • Azure Network Interface
    • Azure Recovery
    • Azure Resource
    • Azure SQL Database
    • Azure SQL Server
    • Azure Storage Account
    • Azure Virtual Machine
    • Azure Virtual Network
    • Azure VPN Gateway
    • cAdvisor
    • Cloud Foundry
    • Docker
    • IBM Softlayer
    • Kubernetes API
    • Kubernetes w/ Prometheus
    • Office 365
    • Office365 Exchange
    • Office365 OneDrive
    • Office365 SharePoint
    • Office365 Skype
    • Office365 Teams
    • OVH
    • Prometheus Server
    • Node Exporter
    • VMware VeloCloud

    Database

    • CouchDB Rest API
    • Elasticsearch
    • Elasticsearch (Deprecated)
    • Firebird
    • InfluxDB
    • Informix DB
    • Informix DB SNMP
    • Microsoft SQL Server
    • MongoDB
    • MySQL/MariaDB
    • Oracle Database
    • PostgreSQL DB
    • RRDtool
    • Sybase
    • Warp10 Sensision

    Hardware Server

    • Adder AIM SNMP
    • AEG ACM
    • Avocent ACS 6000
    • Axis Video
    • Cisco Collaboration Endpoint Rest API
    • Cisco UCS
    • Dell CMC
    • Dell iDRAC
    • Dell OpenManage
    • Eltek eNexus SNMP
    • Fujitsu Server SNMP
    • Hanwha camera SNMP
    • Hikvision camera SNMP
    • HMS Ewon SNMP
    • Timelinkmicro Tms6001
    • HP Blade Chassis
    • HP Ilo Rest API
    • HP Ilo XMLAPI
    • HP OneView Rest API
    • HP Proliant
    • Huawei HMM
    • Huawei iBMC
    • IBM BladeCenter
    • IBM IMM
    • Lenovo XCC SNMP
    • Cisco Telepresence System SNMP
    • Masterclock NTP100GP
    • Pexip Infinity ManagementAPI
    • Polycom GroupSeries SNMP
    • Polycom Trio Rest API
    • Safenet Keysecure
    • Sun MgmtCard
    • Sun Mseries
    • Sun SFxxK
    • Supermicro

    Network

    • 3com Network
    • A10 AX
    • Acme Packet
    • Adva FSP 150 SNMP
    • Adva FSP 3000 SNMP
    • Aerohive
    • Alcatel Omniswitch
    • Allied Telesis SNMP
    • Alvarion BreezeACCESS SNMP
    • Arista Switch
    • Arkoon
    • Aruba Instant SNMP
    • Aruba Standard
    • Atrica Routeur
    • Atto Fibrebridge SNMP
    • Barracuda Cloudgen SNMP
    • Bee Ware
    • BGP Protocol SNMP
    • Bluecoat generic
    • Brocade Switch
    • CheckPoint firewall
    • Cisco Apic
    • Cisco ASA
    • Cisco Call Manager
    • Cisco Callmanager SXML
    • Cisco ESA XMLAPI
    • Cisco Firepower Management Console Rest API
    • Cisco IronPort
    • Cisco Meraki Rest API
    • Cisco Meraki
    • Cisco Prime
    • Cisco Small Business
    • Cisco Standard
    • Cisco Standard SSH
    • Cisco VCS
    • Cisco Voice Gateway
    • Cisco Waas
    • Cisco WLC
    • Citrix Acceleration
    • Citrix Netscaler
    • Citrix SDX
    • Colubris SNMP
    • Cyberoam
    • D-Link DGS 3100
    • D-Link standard SNMP
    • Dell 6200
    • Dell 6200 SNMP
    • Dell N4000
    • Dell OS10 SNMP
    • Dell S-series
    • Dell Xseries
    • Digi Anywhere USB
    • Digi PortServers TS
    • Digi PortServers TS
    • Digi Sarian
    • Efficienti IP
    • Evertz FC7800
    • Extreme Network
    • F5 BigIP
    • Lenovo Flex System Switch
    • Fortinet FortiAuthenticator SNMP
    • Fortinet Fortigate
    • Fortinet Fortimanage
    • Freebox
    • FritzBox
    • Gorgy NTP Server
    • H3C Network
    • Hirschmann switch
    • HP Procurve
    • HP Standard Network
    • HP Virtual Connect
    • Huawei
    • Infoblox SNMP
    • Juniper EX Series
    • Juniper GGSN
    • Juniper ISG
    • Juniper M-Series
    • Juniper Mag
    • Juniper SA
    • Juniper SRX
    • Juniper SSG
    • Juniper Trapeze
    • Kemp Loadbalancer
    • Mikrotik SNMP
    • Mitel 3300ICP
    • Moxa Switch
    • Mrv Optiswitch
    • NetASQ Network
    • Netgear MSeries
    • Netscaler MPX 8000
    • Nokia TiMos
    • Nortel Standard
    • Omniswitch 6850
    • OneAccess Network
    • Oracle Infiniband
    • Palo Alto firewall SNMP
    • Palo Alto firewall SSH
    • Peplink Balance
    • Peplink Pepwave SNMP
    • Perle IDS SNMP
    • pfSense
    • Rad Airmux SNMP
    • Radware Alteon
    • Raisecom
    • RedBack Router
    • Riverbed Interceptor
    • Riverbed SteelHead
    • Ruckus
    • Ruckus Zonedirector
    • Ruckus ICX
    • Ruckus SCG
    • Ruckus Smartzone
    • Ruggedcom Network
    • Silverpeak
    • Sonicwall
    • Sophos ES
    • Stonesoft
    • Stormshield SNMP
    • Stormshield SSH
    • Teltonika SNMP
    • Traffic Director
    • Ucopia
    • Watchguard
    • Zyxel
    • Versa SNMP
    • Versa Director Restapi

    Operating System

    • AIX SNMP
    • Base Pack
    • FreeBSD SNMP
    • HP-UX
    • IBM AS400
    • Linux NRPE
    • Linux NRPE3
    • Linux SNMP
    • Linux SSH
    • Mac SNMP
    • Solaris SNMP
    • Windows NRPE
    • Windows NRPE 0.5
    • Windows NSClient API
    • Windows SNMP

    Printer

    • Printer standard

    Protocol

    • BGP Protocol
    • DHCP Server
    • DNS Service
    • FTP Server
    • Generic SNMP
    • HTTP Server
    • IMAP Server
    • JMX value
    • LDAP Server
    • Modbus
    • NTP Server
    • OSPF Protocol
    • POP Server
    • Protocol DHCP
    • Protocol SSH
    • Protocol TCP
    • Protocol UDP
    • Radius Service
    • SMTP Server
    • Telnet Scenario
    • TFTP Server
    • X509 Certificat

    Sensor

    • ABB CMS-700
    • AKCP Sensor
    • Geist p8000 sensor SNMP
    • Geist Sensor SNMP
    • HWg-STE Sensor
    • Jacarta Sensor
    • LM Sensors
    • Netbotz Sensor
    • Sensor IP
    • SensorGateway
    • Sensormetrix

    Storage

    • Adic Tape SNMP
    • Avid Isis
    • Buffalo TeraStation SNMP
    • Dell Compellent
    • Dell Compellent API
    • Dell Equallogic
    • Dell FluidFS
    • Dell MD3000
    • Dell Me4 Rest API
    • Dell ML6000
    • Dell TL2000
    • EMC Celerra
    • EMC Clariion
    • EMC Data Domain
    • EMC Isilon
    • EMC RecoveryPoint
    • EMC Symmetrix API
    • EMC Symmetrix NRPE
    • EMC Unisphere Rest API
    • EMC Vplex
    • EMC Xtremio
    • Exagrid
    • Fujitsu Eternus DX
    • Hitachi HCP SNMP
    • Hitachi NAS
    • Hitachi Standard
    • HP 3PAR 7000
    • HP 3PAR SSH
    • HP EVA
    • HP Lefthand
    • HP MSA2000
    • HP MSL
    • HP P2000
    • HP StoreOnce
    • HP StoreOnce SSH
    • IBM DS3000
    • IBM DS4000
    • IBM DS5000
    • IBM FlashSystem 900
    • IBM Storwize
    • IBM TS2900
    • IBM TS3100
    • IBM TS3200
    • IBM TS3500
    • Kaminario RestAPI
    • Lenovo S Series
    • NetApp Ontap OnCommand API
    • NetApp Ontap Rest API
    • NetApp Ontap SNMP
    • Netapp Santricity Restapi
    • Netgear Readynas SNMP
    • Nimble Storage
    • Nimble Storage Rest API
    • Oracle ZFS
    • Oracle ZS
    • Overland Neo
    • Panzura
    • Pure Storage RestAPI
    • Qnap
    • QSAN NAS
    • Quantum DXi Series
    • Quantum Scalar
    • Storagetek SL
    • Synology
    • Violin Memory 3000

    Toip Voip

    • Alcatel OXE
    • Asterisk VoIP Server
    • AudioCodes
    • Avaya AES SNMP
    • Avaya Media Gateway SNMP
    • Polycom DMA SNMP
    • Polycom HDX SNMP
    • Polycom RMX
    • Polycom RPRM SNMP
    • Sonus SBC
    • XiVO VoIP Server

    Ups Pdu

    • Alpha UPS SNMP
    • APC ATS
    • APC PDU
    • APC UPS
    • Clever PDU
    • CyberPower Systems PDU SNMP
    • Eaton ATS SNMP
    • Eaton PDU SNMP
    • Emerson PDU
    • HP UPS SNMP
    • MGE UPS System
    • Nitram UPS SNMP
    • Powerware UPS
    • Raritan PDU
    • Schleifenbauer Gateway SNMP
    • UPS Standard

    Virtualization

    • Hyper-V 2012
    • Nutanix
    • Proxmox VE
    • VMware ESX
    • VMware ESX WS-MAN
    • VMware vCenter
    • VMware vCenter v4
    • VMware vCenter v5
    • VMware vCenter v6
    • VMware VM

Integrations

    External

    • Accedian PVX Skylight
    • Maltem Insight Performances Rest API

    Notifications

    • Notify with Telegram bot

    Open Tickets

    • BMC Footprints
    • BMC Remedy
    • EasyVista
    • GLPI
    • GLPI RestAPI
    • iTop
    • IWS Isilog
    • Jira
    • Mail
    • OTRS RestAPI
    • Request Tracker RestAPI
    • Serena
    • ServiceNow

    Stream Connectors

    • BSM
    • Elasticsearch events
    • Elasticsearch metrics
    • NDO
    • HP OMI
    • PagerDuty Service integration
    • ServiceNow Event Manager
    • ServiceNow MID Server
    • Splunk Metrics
    • Splunk Events
    • Warp10

Mobile App.

  • Introduction

API

  • Introduction
  • Command Line API (v1)
  • Rest API (v1)
  • Rest API (v2)
  • Graphical views API (beta)

Developer resources

  • About Developer
  • How to write a module
  • How to write a Stream Connector
  • How to translate Centreon
  • How to write a widget
  • Centreon Broker

    • Stream connectors
    • The BBDO protocol
    • Centreon Broker Event Mapping

Releases

  • Centreon Platform 20.04.0
  • Products lifecycle policy
  • Release notes by component

    • Centreon Core
    • Commercial Extensions
    • Open Source Extensions
Edit

Install Centreon MBI extension

Centreon MBI is a Centreon extension that requires a valid license key. To purchase one and retrieve the necessary repositories, contact Centreon.

Four major steps to installing Centreon MBI:

  • Check the system prerequisites.
  • Install the Centreon MBI interface in the Centreon application (Centreon MBI Server).
  • Install the reporting server (Centreon MBI Reporting Server).
  • Configure Extract, Transform, Load (ETL) in the Centreon MBI.

Architecture

This chapter describes the Centreon MBI architecture and provides an overview of how the extension is integrated into Centreon monitoring software.

The information is addressed to administrators who will be installing or configuring Centreon MBI.

Dedicated reporting server

This architecture and prerequisites apply to:

  • Test environnements
  • Pre-production environments
  • Production environments.

The diagram below shows the main components of Centreon MBI:

image

The monitoring database can be installed on a server other than the Centreon server.

  • ETL: Process that extracts, transforms and loads data into the reporting database.
  • CBIS: Scheduler that manages job execution and publication.
  • Reporting database: MariaDB database that contains reporting data and some raw data extracted from the monitoring database.

Network flow table

The table below presents the different types of flow, by default, between the dedicated BI server, Centreon server and databases:

ApplicationSourceDestinationPortProtocol
ETL/CBISReporting serverCentreon Database3306TCP
SSHReporting serverCentreon22TCP
CBISCentreonReporting server1234TCP
CBISReporting serverCentreon80HTTP*
WidgetsCentreonReporting server3306TCP

*Only required for Host-Graph-v2 and Hostgroup-Graph-v2 reports that use Centreon API to generate graphs

Packages information

Centreon MBI installation requires two RPM packages:

  • Centreon-bi-server: Installs the Centreon MBI interface integrated into the Centreon front end and must reside on the Centreon Web Server.
  • Centreon-bi-reporting-server: Contains all the components needed to run the reporting server -- report scheduler, ETL, standards reports -- and must reside on a dedicated server for reporting processes.

You should install the MariaDB database at the same time. We highly recommand installing the database on the same server for performance & isolation considerations.

Prerequisites

Centreon central server

Software

  • Centreon 20.04

  • Check that the parameter date.timezone is correctly configured in /etc/opt/rh/rh-php72/php.ini (same timezone displayed with the command timedatectl status)

  • Avoid the usage of the following variables in your monitoring MariaDB configuration. They halt long queries execution and can stop the ETL or the report generation jobs:

    • wait_timeout
    • interactive_timeout

Users and groups

UserGroup
centreonBI (new)apache, centreon, centreonBI
apache (existing)centreonBI

Description of users, umask and home directory

Userumaskhome
centreonBI0002/home/centreonBI

Reporting dedicated server

Hardware

Monitored servicesCPURAM
< 4 0002 CPU ( 3Ghz ) minimum12GB minimum
< 20 0004 CPU (3GHz) minimum16GB minimum
>= 20 000 and < 40 0004 CPU (3GHz) minimum24GB minimum
> 40 000 and < 100 0008 CPU (3GHz) minimum32GB minimum
> 100 000> Contact Centreon

Storage space: Use the following storage estimation file

File system

File systemSize
/5GB minimum
/var (containing MySQl data)Use the result of the above disk-space simulation file MariaDB data)
MariaDB temp folderWe recommand keeping it in /var
Volume group*5GB minimum of free space on the Volume group hosting the MySQL/MariaDB DBMS data

To check the free space use the command below, replacing vg_data by the Volume group name:

vgdisplay vg_data | grep -i free

Software

  • OS : CentOS 7 / Redhat 7
  • SGBD : MariaDB 10.3
  • Firewall : Désactivé
  • SELinux : Désactivé

We advise to tune your MariaDB database server on your reporting server in order to have better performance. You will need at least 12GB on your reporting server to run the configuration file provided below. Add the following file on your reporting server in /etc/my.cnf.d/.

Make sure to have a tmp folder in /var/lib/mysql.

Do not set these MariaDB optimizations on your monitoring server.

Users and groups :

UserGroup
centreonBIcentreonBI

Description of users, umask and home directory:

Userumaskhome
centreonBI0002/home/centreonBI

Install the extension on Centreon

The tasks explained in this chapter must be performed on the Centreon central server.

Install the Centreon MBI repository, you can find it on the support portal.

Run the following command: :

yum install centreon-bi-server

Activate the extension

The menu Administration > Extension > Manager of Centreon enables you to install the different extension detected by Centreon. Click on the "Centreon MBI" card to install it.

Upload the license sent by the Centreon team to be able to start configuring the General Options.

Configure the general options

Set the following parameters in the General Options menu Reporting > Monitoring Business Intelligence > General Options :

TabOptionValue
Scheduler OptionsCBIS HostReporting server IP Address
ETL OptionsReporting engine uses a dedicated MariaDB serverYes
Reporting Widgets *Reporting MariaDB databaseReporting database IP Address (default = same as CBIS Host)

* The connection test will not yet work at this stage of the installation process.

Centreon central databases access

Case #1: MariaDB monitoring database is hosted on the Central monitoring server

Launch the command below to authorize the reporting server to connect to the monitoring server databases. Use the following option:

@ROOTPWD@: Root MariaDB password of the monitoring databases server.If there is no password for "root" user, don't specify the option root-password.

/usr/share/centreon/www/modules/centreon-bi-server/tools/centreonMysqlRights.pl --root-password=@ROOTPWD@

Case #2: MariaDB monitoring database is hosted on a dedicated server

Connect by SSH to the database server, and the run the following commands: :

mysql -u root -p
mysql> CREATE USER 'centreonbi'@'$BI_ENGINE_IP$' IDENTIFIED BY 'centreonbi';
mysql> GRANT ALL PRIVILEGES ON centreon.* TO 'centreonbi'@'$BI_ENGINE_IP$';
mysql> GRANT ALL PRIVILEGES ON centreon_storage.* TO 'centreonbi'@'$BI_ENGINE_IP$';

$BI_ENGINE_IP$: IP address of the reporting server.

If you're using MariaDB replication for your monitoring databases, certain views are created during installation of Centreon MBI. You need to exclude them from replication by adding the following line in the my.cnf file of the slave server.

  replicate-wild-ignore-table=centreon.mod_bi_%v01,centreon.mod_bi_%V01

Then, create the views manually on the slave server by launching the following command line:

#mysql centreon < view_creation.sql

Please go to the next chapter to continue the installation.

Install the dedicated reporting server

Install the packages

You need the following information available before proceeding with the installation process:

  • IP/DNS of the monitoring database
  • IP/DNS of the Centreon web interface
  • IP/DNS of the reporting database (localhost highly recommanded)
  • Access (user/password) to the reporting database
  • Knowledge of the SSH password (after defining it) for the Centreon BI user on the central monitoring server (to publish reports on the interface).

To start installing the reporting server, install the MBI repository, you can find it on the support portal.

Then execute the following command:

yum install centreon-bi-reporting-server MariaDB-server MariaDB-client

If you installed your reporting server using a fresh CentOS image you need to add the following GPG key: :

cd /etc/pki/rpm-gpg/
wget http://yum.centreon.com/standard/20.04/el7/stable/RPM-GPG-KEY-CES

Reporting server configuration

MariaDB optimization

Make sure you have installed the MariaDB configuration file provided in the pre-requisites before starting the MariaDB service following file

systemctl restart mysql

For installation, it is necessary to modify LimitNOFILE limitation. Setting this option in /etc/my.cnf will NOT work.

mkdir -p  /etc/systemd/system/mariadb.service.d/
echo -ne "[Service]\nLimitNOFILE=32000\n" | tee /etc/systemd/system/mariadb.service.d/limits.conf
systemctl daemon-reload
systemctl restart mysql

Then start the service MariaDB. If this service cannot start, remove the ib_log files before restarting MariaDB (be sure MariaDB is stopped):

rm -f /var/lib/mysql/ib_logfile*
systemctl restart mysql

If you are using a custom MariaDB socket file, modify the /etc/my.cnf file and in the [client] section, add the following variable:

socket=$PATH_TO_SOCKET$

Start configuring

First check that the reporting MariaDB is running. Then launch the following command, answering the questions:

/usr/share/centreon-bi/config/install.sh

The script handles the SSH exchange key between the monitoring and reporting servers and configures the default SFTP publication rule in order to publish reports on the Centreon web interface. Finally, it activates the backup and starts the CBIS service.

Once installation is complete, go to the next chapter to configure the ETL.

ETL: Configuration

Centreon MBI integrates its own extract, transform, load (ETL) capabilities to:

  • Synchronize raw monitoring data with the reporting server.
  • Calculate availability and performance statistics on the reporting server.
  • Manage data retention on the reporting server.

Before following the next steps, you should have read the best practice parts to ensure that the Centreon objects (e.g., groups and categories) are configured according to Centreon MBI requirements.

In the Reporting > Business Intelligence > General Options > ETL options menu of the Centreon server, specify the following options:

OptionsValues
General options
Reporting engine uses a dedicated dedicated MariaDB serverYes. You must use a reporting server
Compatibility mode to use report templates from version of Centreon MBI prior to 1.5.0No (deprecated)
Temporary file storage directory on reporting serverFolder where dumps will be stored on the reporting server
Type of statistics to build
  • Select “Availability only” if you only use availability reports.
  • Select “Performance and capacity only” if you only want to use capacity and performance reports.
  • Select “All” to calculate the statistics for both types of reports.
Use large memory tweaks (store MariaDB temporary tables in memory)Activated only if your MariaDB configuration and allocated physical memory on the server permit.
Reporting perimeter selection
HostgroupsSelect only host groups for which you want to aggregate data.
HostcategoriesSelect only host categories for which you want to aggregate data.
Service categoriesSelect only service categories for which you want to aggregate data.
Availability statistic calculation
Live services for availability statistics calculationSelect required time periods.
Performance and capacity statistic calculation
Granularity required for performance data statisticsSelect level of granularity required to run the desired performance reports (1).
Live services for performance data statistics calculationSelect required time periods.
Capacity statistic aggregated by month
Live services for capacity statistics calculationSelect the “24x7” time period.
Service categories related to capacity data monitoringSelect the service categories that have been associated with capacity-type services.
Exclude metrics from service categories that do not return capacity USAGE informationConcerns the metrics linked to services which return capacity data. Select the metrics that do not return capacity usage information. but a maximum or total value. (e.g., the metric “size”).
Centile parameters
Calculating centile aggregation bySelect the desired aggregation level. The standard percentile report provided with BI 2.1 uses Month data.
Select service categories to aggregate centile onFilter on relevant service categories for centile statistics (e.g., Traffic).
First day of the weekSelect the first day of the week for Week aggregation.
Centile / Timeperiod combinationCreate a new centile/timeperiod combination on which to perform the calculation.

(1) Reports requiring a precise value per hour of performance data are listed below. If you do not use the following reports, disable the statistics calculation per hour:

  • Hostgroup-Host-details-1
  • Host-detail-v2
  • Hostgroup-traffic-Average-Usage-By-Interface
  • Hostgroup-traffic-by-Interface-And-Bandwith-Ranges.

ETL: Data retention

The reporting server contains statistics tables specific to Centreon MBI in the database "centreon_storage". The storage space used by these tables increases every day. It is possible to control the size of these tables by setting data retention rules.

Under Reporting > Monitoring Business Intelligence > General options > Data retention, data retention can be managed by:

  • Type of data (availability, performance).
  • Precision of data (raw data, hourly, daily or monthly values).

Before enabling the data retention options, check that the Reporting engine uses a dedicated MariaDB server option is correctly set to "Yes" in the Reporting > Business Intelligence > General options ETL options menu.

Enable data retention management by selecting "Yes", then set the options in the configuration (example below).

image

To activate automatic purge of old data, edit the cron file /etc/cron.d/centreon-bi-purge on the reporting server, then uncomment the following line:

#0 20 * * * root @CENTREON_BI_HOME@/*etl*/dataRetentionManager.pl >> @CENTREON_BI_LOG@/dataRetentionManager.log 2>&1

Avoid periods scheduled for statistical calculations with Centreon MBI ETL and report generations.

You can run this cron daily or weekly, depending on the execution time of the batch and the load generated on the server.

Then restart the service cron:

systemctl restart crond

BEST PRACTICE: Select different retention periods according to the granularity of the statistical data:

  • Hourly aggregated values are used to analyze a metric over a short period, they take a lot of space on the disk. You may not need to keep these statistics more that two or three months.
  • Beyond five or six months, you may only need to view the trend for availability or performance statistics. You could then keep the daily aggregated data for a maximum of six months, for example, and configure the retention of monthly aggregated data for a period of several dozen months.

Please go to the next chapter to continue the installation.

ETL: Execution

Before continuing, be sure that you have installed the MariaDB configuration file as specified above in the prerequisites. Configure and activate data retention so that only the required data is imported and calculated.

Rebuilding statistics using historical data

Run the following command on the REPORTING server, it will:

  • Delete all existing data from the reporting server.

  • Import raw monitoring data from the monitoring server to the reporting server (based on retention parameters).

  • Populate the tables containing the availability statistics for hosts and services.

  • Populate the tables containing the performance and capacity statistics.

    /usr/share/centreon-bi/bin/centreonBIETL -r
    

Activating daily execution (of the script)

Once the rebuild process is finished, you can activate the daily statistic calculation. On the reporting server, edit the file /etc/cron.d/centreon-bi-engine and uncomment the following line:

#30 4 * * * root /usr/share/centreon-bi/bin/centreonBIETL -d >> /var/log/centreon-bi/centreonBIETL.log 2>&1

Restart the service cron::

systemctl restart crond

Make sure that the batch centreonBIETL starts only once the batch eventReportBuilder has finished on the monitoring server (see the cron file * /etc/cron.d/centreon* on the monitoring server).

Centreon MBI installation is now complete, check the tutorial

← Report developmentUpdate the extension →
  • Architecture
    • Dedicated reporting server
    • Network flow table
    • Packages information
  • Prerequisites
    • Centreon central server
    • Reporting dedicated server
  • Install the extension on Centreon
    • Activate the extension
    • Configure the general options
    • Centreon central databases access
  • Install the dedicated reporting server
    • Install the packages
    • Reporting server configuration
    • Start configuring
    • ETL: Configuration
    • ETL: Data retention
    • ETL: Execution
Centreon documentation
Documentation
Getting StartedAPI ReferencesReleases
Resources
Centreon WebsiteBlogDownload
Follow us
centreon
Follow @Centreon
Copyright © 2005 - 2021 Centreon