Skip to content

Latest commit

 

History

History
84 lines (56 loc) · 2.64 KB

02-Installation.md

File metadata and controls

84 lines (56 loc) · 2.64 KB
Raw

Installation

Requirements

If your Icinga Web 2 is not v2.9+, the following modules are also required:

Database Setup

MySQL / MariaDB

The module needs a MySQL/MariaDB database with the schema that's provided in the etc/schema/mysql.sql file.

Example command for creating the MySQL/MariaDB database. Please change the password:

CREATE DATABASE reporting;
GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE VIEW, INDEX, EXECUTE ON reporting.* TO reporting@localhost IDENTIFIED BY 'secret';

After, you can import the schema using the following command:

mysql -p -u root reporting < schema/mysql.sql

PostgreSQL

The module needs a PostgreSQL database with the schema that's provided in the etc/schema/postgresql.sql file.

Example command for creating the PostgreSQL database. Please change the password:

CREATE USER reporting WITH PASSWORD 'secret';
CREATE DATABASE reporting
  WITH OWNER reporting
  ENCODING 'UTF8'
  LC_COLLATE = 'en_US.UTF-8'
  LC_CTYPE = 'en_US.UTF-8';

After, you can import the schema using the following command:

psql -U reporting reporting -a -f schema/postgresql.sql

Module Installation

  1. Install it like any other module. Use reporting as name.

  2. Once you've set up the database, create a new Icinga Web 2 resource for it using the Configuration -> Application -> Resources menu. Make sure that you set the character set to utf8mb4.

  3. The next step involves telling the Reporting module which database resource to use. This can be done in Configuration -> Modules -> reporting -> Backend. If you've used reporting as name for the resource, you can skip this step.

This concludes the installation. Now continue with the configuration.

Scheduler Daemon

There is a daemon for generating and distributing reports on a schedule if configured:

icingacli reporting schedule run

This command schedules the execution of all applicable reports.

You may configure this command as systemd service. Just copy the example service definition from config/systemd/icinga-reporting.service to /etc/systemd/system/icinga-reporting.service and enable it afterwards:

systemctl enable icinga-reporting.service