Centreon Database
Prerequisites
Centreon Plugin
Install this plugin on each needed poller:
yum install centreon-plugin-Applications-Monitoring-Centreon-Database centreon-plugin-Operatingsystems-Linux-Snmp
Creating a database user for Service Partitioning Monitoring
In order to be able to collect the needed information from the database a database user with specific privileges is required:
# grant select on *.* to 'monitor'@'%' identified by 'HuGr6834';
SNMP
Enable SNMP Agent
Centreon Configuration
Create a new Centreon Database server
Go to Configuration > Hosts and click Add. Then, fill the form as shown by the following table:
Field | Value |
---|---|
Host name | Name of the host |
Alias | Host description |
IP | Host IP Address |
Monitored from | Monitoring Poller to use |
Host Multiple Templates | App-Monitoring-Centreon-Database-custom |
Click on the Save button.
Host Macro Configuration
The following macros must be configured on host:
Macro | Description | Default value | Example |
---|---|---|---|
MYSQLPORT | Port used to connect to the DB server | MYSQLPORT | 3306 |
MYSQLUSERNAME | the mysql db user | MYSQLUSERNAME | monitor |
MYSQLPASSWORD | the mysql db user's password | MYSQLPASSWORD | HuGr6834 |