Eric Schirra
4ec91b8b9b
- Update to 0.10.0
* Enhancements
- Support for PHP 8.1
- Support for PostgreSQL
- Support for Icinga's dark and light mode
- Permissions for better access control
- E-mail subjects are now configurable per schedule
* Fixes
- Reports now get automatically more resources #113
- Percent signs in report names now work without problem #62
- Recipients can now be defined on multiple lines as well, not
just comma-separated #111
OBS-URL: https://build.opensuse.org/request/show/987437
OBS-URL: https://build.opensuse.org/package/show/server:monitoring/icingaweb2-module-reporting?expand=0&rev=2
46 lines
1.7 KiB
Plaintext
46 lines
1.7 KiB
Plaintext
Database Setup
|
|
==============
|
|
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
|
|
|
|
Module Installation
|
|
===================
|
|
1. Just drop this module to a reporting subfolder in your Icinga Web 2 module path.
|
|
2. Log in with a privileged user in Icinga Web 2 and enable the module in
|
|
Configuration -> Modules -> reporting. Or use the icingacli and run icingacli module enable reporting.
|
|
3. 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.
|
|
4. The next step involves telling the Reporting module which database resource to use.
|
|
This can be done in Configuration -> Modules -> reporting -> Backend.
|
|
|
|
This concludes the installation. You should now be able create reports.
|
|
|
|
You also must enable modules: ipl, pdfexport and reactbundle.
|
|
|
|
Scheduler Daemon
|
|
================
|
|
|
|
systemctl enable icinga-reporting.service
|
|
|
|
|
|
Upgrading to Version x.y.z
|
|
==========================
|
|
|
|
Icinga Reporting version x.y.z requires a schema update for the database.
|
|
A new table template, linked to table report, has been introduced.
|
|
Please find the upgrade script in schema/mysql-migrations.
|
|
|
|
You may use the following command to apply the database schema upgrade file:
|
|
|
|
# mysql -u root -p reporting <schema/mysql-migrations/vx.y.z.sql
|
|
|