Centreon MBI Reporting Server

This chapter describes how to install the reporting server.

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).

Installation

Contact Centreon Service Desk to obtain and install the Centreon MBI repository, then run 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/18.10/el7/stable/RPM-GPG-KEY-CES

Reporting server configuration

MySQL optimization

Make sure you have installed the MySQL configuration file provided in the pre-requisites before starting the MySQL service (centreon.cnf)

# 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 MySQL. If this service cannot start, remove the ib_log files before restarting MySQL (be sure MySQL is stopped):

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

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

socket=$PATH_TO_SOCKET$

Installation and configuration of the reporting server

First check that the reporting MySQL 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.