Centreon SQL Metrics
Overviewβ
This Pack ships metrics collected from the Centreon SQL real-time database. Get a complete overview of its virtual curves capabilities here
Pack Assetsβ
Templatesβ
The Centreon Plugin Pack Centreon SQL Metrics brings a host template:
- App-Monitoring-Centreon-SQL-Metrics-custom
It brings the following service templates:
Service Alias | Service Template | Service Description | Default |
---|---|---|---|
Poller-Delay | App-Monitoring-Centreon-SQL-Poller-Delay | Check the poller lag delay | |
Virtual-Curve | App-Monitoring-Centreon-SQL-Virtual-Curves | Mix your metrics from several services |
Collected metrics & statusβ
- Poller-Delay
- Virtual-Curve
Metric Name | Unit |
---|---|
centreon.poller.delay.seconds | s |
Metrics depend on the service configuration. Check our The Watch blog post.
Prerequisitesβ
The poller executing the check must be able to connect to the centreon_storage database over the 3306/TCP port with values supplied through --username and --password options.
The SQL user must hold required privileges to "SELECT" data within index_data, metrics, and instances tables tables in the centreon_storage database.
When using the Virtual-Curve service, the configuration file must be readable by the centreon-engine user.
Setupβ
- Online License
- Offline License
- Install the Centreon plugin package on the central server:
yum install centreon-plugin-Applications-Monitoring-Centreon-SQL-Metrics
- On the Centreon web interface, install the Centreon SQL Metrics Centreon Plugin Pack on the Configuration > Plugin Packs page.
- Install the Centreon plugin package on the central server:
yum install centreon-plugin-Applications-Monitoring-Centreon-SQL-Metrics
- Install the Centreon SQL Metrics Centreon Plugin Pack RPM on the Centreon central server:
yum install centreon-pack-applications-monitoring-centreon-sql-metrics
- On the Centreon web interface, install the Centreon SQL Metrics Centreon Plugin Pack on the Configuration > Plugin Packs page.
Configurationβ
Hostβ
- Log into Centreon and add a new host through Configuration > Hosts.
- Fill the Name, Alias and IP Address/DNS fields according to your Centreon database server server settings.
- Apply the App-Monitoring-Centreon-SQL-Metrics-custom to the host.
- Once the template is applied, fill in the corresponding macros. Some macros are mandatory.
Mandatory | Name | Description |
---|---|---|
x | CENTREONDATABASEUSER | Username of the Centreon centreon_storage database |
x | CENTREONDATABASEPASSWORD | Password of the Centreon centreon_storage database |
EXTRAOPTIONS | Any additional option. |
How to check in the CLI that the configuration is OK and what are the main options for?β
Once the plugin is installed, log into your Centreon poller's CLI using the centreon-engine user account (su - centreon-engine
) and test the plugin by running the following
command:
/usr/lib/centreon/plugins/centreon_centreon_sql_metrics.pl \
--plugin=database::mysql::plugin \
--dyn-mode=apps::centreon::sql::mode::pollerdelay \
--host=10.25.14.139 \
--username=readerstorage \
--password=rostorage
The expected command output is shown below:
OK: All poller delay for last update are ok | 'Central#centreon.poller.delay.seconds'=30s;;;; 'poller#centreon.poller.delay.seconds'=14s;;;;
All available options for a given mode can be displayed by adding the
--help
parameter to the command:
/usr/lib/centreon/plugins/centreon_centreon_sql_metrics.pl \
--plugin=database::mysql::plugin \
--dyn-mode=apps::centreon::sql::mode::pollerdelay \
--help
Troubleshootingβ
Please find all the troubleshooting documentation for the Centreon plugins in the dedicated page.