Icinga-Web Notes for SUSE packages
==================================

* Icinga-web Setup


DO NOT EDIT files in /usr/share/icinga-web/ as they will be overwritten,
during the next update. Use the config files in /etc/icinga-web/
After changing configuration always delete the cache

# /usr/sbin/icinga-web-clearcache


========================
= Configure the database
========================

Check /usr/share/icinga-web/app/config/databases.xml for database configuration.
Icinga-web needs access to the databases icinga and icinga_web.
It is recommended to configure the database in /etc/icinga-web/databases.xml

-------
- MySQL
-------

Create Database, User, Grants
-----------------------------

#> mysql -u root -p

mysql> CREATE DATABASE icinga_web;

mysql> GRANT USAGE ON icinga_web.* TO 'icinga_web'@'localhost' IDENTIFIED BY 'your_secure_password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0;

mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, INDEX ON icinga_web.* TO 'icinga_web'@'localhost';

mysql> FLUSH PRIVILEGES;

mysql> quit

Import database schema
----------------------

#> cd /usr/share/icinga-web/etc/schema/
#> mysql -u root -p icinga_web < mysql.sql

------------
- Postgresql
------------

Create Database, User, Grants
-----------------------------

#> su - postgres
#> psql
postgres=# CREATE USER icinga_web;
postgres=# ALTER USER icinga_web WITH PASSWORD 'your_secure_password' CREATEDB;
postgres=# \q

Import database schema
----------------------

#> cd /usr/share/icinga-web/etc/schema/
#> psql -U icinga_web -d icinga_web < pgsql.sql

Setup trusted icinga_web user
-----------------------------

Please edit the file pg_hba.conf and add the following lines:

#icinga_web
local icinga_web icinga_web     trust


Please keep in mind to restart PostgreSQL afterwards:

#> /etc/init.d/postgresql reload


======================
= Upgrade the database
======================

There is no db upgrade script like in Debian, so you need to keep track of that yourself.

First, get the schema version. Unfortunately the version information
is not stored in the database, so you need to know it.

http://docs.icinga.org/latest/en/upgrading_icingaweb.html

Remember - the upgrade steps need to be applied incrementally, version by version.

-------
- MySQL
-------
e.g.
#> cd /usr/share/icinga-web/etc/schema/updates/
#> mysql -u root -p icinga_web < mysql_v1-6-2_to_v1-7.sql

------------
- Postgresql
------------
e.g.
#> su - postgres
#> cd /usr/share/icinga-web/etc/schema/updates/
#> psql -U icinga_web -d icinga_web < pgsql_v1-6-2_to_v1-7.sql


======================
= Web Interface Access
======================

The interface is accessible via the URL: http://<host>/icinga-web
The default login data is "root" with "password".


=====================
= Recommended Reading
=====================

Advanced guides and upgrade information can be found in the docs and wiki:

http://docs.icinga.org/latest/en/icinga-web-scratch.html
http://docs.icinga.org/latest/en/icinga-web-config.html#configweb-databases
http://docs.icinga.org/latest/en/upgrading_icingaweb.html


============================
= Suggestions and Bugreports
============================

If you want to make suggestions for the way this software is packaged or want
to report bugs related to the packaging of this software, please report to
the SUSE bug tracker by using the link "Report Bug" on
https://build.opensuse.org/package/show?package=icinga-web&project=server%3Amonitoring