Necessary preparations on EXASOL database clusters - exasol/nagios-monitoring GitHub Wiki

  • for using the XMLRPC API, you need an EXAoperation user having at least the supervisor role
  • this user needs to have read access on all EXAStorage volumes of the cluster
  • a logservice with all relevant informations
  • a database user for accessing the monitoring tables

Creating the user

Log into EXAoperation web interface with a user which has Administrator or Master role. Under "Access Management" you can add users. Access Management Adding Users

Assign Supervisor role

Assign the correct role to the new user by clicking "Roles". The default role for new users is "User", but not all XMLRPC functions used by the plugins can be used by this role. That's why you have to change the role to "Supervisor". Assing Role

Grant read-only access to all data and archive volumes

Add that user to all available EXAStorage volumes - not including any temporary volumes (which are system-managed). Having read-only access to all volumes is necessary to be able to calculate the free, available space for the databases. A full explanation about calculating the free disk space can be found in SOL-366.

Granting access for a specific EXAStorage volume can be done by clicking on "EXAStorage" in the EXAoperation web interface and choosing the desired volume by clicking on the volume name. Now you can edit the volume settings, add the monitoring user to the "Read-only Users" list and apply the changes. This has to be done on all existing volumes. EXAStorage EXAStorage - Editing Volumes

Creating the logservice

The nagios monitoring bundle also contains an event-based check for cluster log messages. This check needs a logservice with all the desired options and will notify you as soon as there is an entry with a log priority higher than "WARNING". Click on "Monitoring" on the navigation pane where you might already find an appropriate logservice. Otherwise we recommend to create a new logservice with the following options:

  • Minimum Log Priority: Information
  • EXAClusterOS Services:
  • Database Systems:

Monitoring - Logservices Monitoring - Logservices

To configure the plugin you need the "Service" id (like "logservice2").

Creating the database monitoring user

If we want to use the performance plugin which uses the statistical system tables of EXASOL, you need a database user which is able to access thes tables. You can use the following snippet to create such a database user:

CREATE USER exa_monitor IDENTIFIED BY "secure password";
GRANT CREATE SESSION TO exa_monitor;
GRANT SELECT ANY DICTIONARY TO exa_monitor;
⚠️ **GitHub.com Fallback** ⚠️