Centreon MBI Reporting Server

This chapter covers the installation of the reporting server. Note that it is mandatory to install a dedicated reporting server. The requirements are described in the following chapter Pre-requisites .

You will need the following information during that process, be sure to collect them before starting :

  • IP/DNS of the monitoring database
  • IP/DNS the Centreon web interface
  • IP/DNS the reporting database (localhost highly recommanded)
  • access (user/password) to the reporting database if specific
  • define and know the password of the centreonBI user on the monitoring server (to publish report on Central server and make them accessible through the interface)

Installation

Contact Centreon Service Desk to get and install the Centreon MBI repository, then run the following command::

yum install centreon-bi-reporting-server

If you installed your reporting server using a “fresh CentOS installation” 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 the installation, it is necessary to modify LimitNOFILE limitation. Setting this option into /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 the MySQL 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’re 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

First check that MySQL is running, then launch the following command and answer to the questions:

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

The script make the ssh exchange key between the monitoring and the reporting server, and configure the default sftp publication rule to be able to publish reports on the Centreon web interface. Finally, it activates the backup and starts cbis service.

Please go to the next chapter to continue the configure the ETL.