blob: 532d0ff925fccc3aa173414abf359245af90a33a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
|
# Installation
## Requirements
* PHP (>= 7.0)
* Icinga Web 2 (>= 2.9)
* Icinga Web 2 libraries:
* [Icinga PHP Library (ipl)](https://github.com/Icinga/icinga-php-library) (>= 0.8)
* Icinga Web 2 modules:
* [reporting](https://github.com/Icinga/icingaweb2-module-reporting) (>= 0.9)
* MySQL, MariaDB or PostgreSQL
## Database Setup
### MySQL / MariaDB
#### Grant Required Privileges
Skip this step if you used the database configuration wizard during the Icinga 2 installation.
Please proceed only if you did the setup manually as described here:
https://icinga.com/docs/icinga2/latest/doc/02-getting-started/#setting-up-the-mysql-database
The import of the SQL functions will fail due to insufficient privileges.
The required privileges are `CREATE, CREATE ROUTINE, ALTER ROUTINE, EXECUTE`.
The following example assumes that your MySQL database is hosted on **localhost**
and your Icinga database and user is named **icinga2**:
```
GRANT CREATE, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON icinga2.* TO 'icinga2'@'localhost';
```
Please adapt the host, database and username to your environment.
#### Import Database Files
The module ships with database functions for calculating the host and service availability in `etc/schema/mysql`.
Please import those files into your Icinga database.
The following example assumes that your Icinga database and user is named **icinga2**:
```
mysql -p -u icinga2 icinga2 < schema/mysql/slaperiods.sql
mysql -p -u icinga2 icinga2 < schema/mysql/get_sla_ok_percent.sql
```
Please adapt the database and username to your environment.
### PostgreSQL
#### Import Database Files
The module ships with database functions for calculating the host and service availability in `etc/schema/postgresql`.
Please import those files into your Icinga database.
The following example assumes that your Icinga database and user is named **icinga2**:
```
psql -U icinga2 icinga2 < schema/postgresql/slaperiods.sql
psql -U icinga2 icinga2 < schema/postgresql/get_sla_ok_percent.sql
```
Please adapt the database and username to your environment.
## Installation
Install it [like any other module](https://icinga.com/docs/icinga-web-2/latest/doc/08-Modules/#installation).
Use `idoreports` as name.
This concludes the installation. You should now be able to create host and service availability reports.
|
