Skip to main content

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 AliasService TemplateService DescriptionDefault
Poller-DelayApp-Monitoring-Centreon-SQL-Poller-DelayCheck the poller lag delay
Virtual-CurveApp-Monitoring-Centreon-SQL-Virtual-CurvesMix your metrics from several services

Collected metrics & status​

Metric NameUnit
centreon.poller.delay.secondss

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​

  1. Install the Centreon plugin package on the central server:
yum install centreon-plugin-Applications-Monitoring-Centreon-SQL-Metrics
  1. 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.
MandatoryNameDescription
xCENTREONDATABASEUSERUsername of the Centreon centreon_storage database
xCENTREONDATABASEPASSWORDPassword of the Centreon centreon_storage database
EXTRAOPTIONSAny 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.