oKBereitschaftsplanungDoku/howto/config.adoc

////
******************************************************************************
* Copyright 2018 Mettenmeier GmbH.
* All rights reserved. This program and the accompanying materials
* are made available under the terms of the Eclipse Public License v1.0
* which accompanies this distribution, and is available at
*
*     http://www.eclipse.org/legal/epl-v10.html
*
******************************************************************************
////
= openKonsequenz "StandbyPlanning" - How to configure the module
:Date: 2018-06-07
:Revision: 1

== Keycloak
Define the following client(s), roles and users. 

.create keycloak client
[source]
	standbyplanning

.create keycloak client roles
[source]
	BP_Admin
	BP_Gruppenleiter
	BP_Leseberechtigte
	BP_Sachbearbeiter

.create keycloak user
[source]	
	user=   bp_leser       pwd= mm
	user=   bp_leiter      pwd= mm
	user=   bp_bearbeiter  pwd= mm
	user=   bp_admin       pwd= mm
	
== Datenbank (Postgres)
A postgres database and a user should be created. All the needed tables and sequences will be genreated bei the "Standby Planning" backend (spbe).

.user
[source]
-- Role: bp
-- DROP ROLE bp;
CREATE ROLE bp LOGIN
  ENCRYPTED PASSWORD 'md5b03632e190331f379668603ee46d4772'
  NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;

.database
[source]
-- Database: "BP"
-- DROP DATABASE "BP";
CREATE DATABASE "BP"
  WITH OWNER = bp
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       LC_COLLATE = 'German_Germany.1252'
       LC_CTYPE = 'German_Germany.1252'
       CONNECTION LIMIT = -1;

== Camunda
=== server.xml
The following Resources has added to the *<GlobalNamingResources>* section of the tomcat server.xml.
[source, xml]

    <!--camunda resource-->
	<Resource auth="Container"
		driverClassName="org.postgresql.Driver"
		factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" maxActive="20"
		minIdle="5" name="jdbc/ProcessEngine" password="camunda"
		type="javax.sql.DataSource" uniqueResourceName="process-engine"
		url="jdbc:postgresql://localhost:5432/camunda" username="camunda" />
	<!--spbe resource-->	
	<Resource auth="Container"
		driverClassName="org.postgresql.Driver"
		factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" maxActive="20"
		minIdle="5" name="jdbc/BP" password="bp" type="javax.sql.DataSource"
		uniqueResourceName="bp" url="jdbc:postgresql://localhost:5432/BP"
		username="bp" />
		

The following Resources has to be disabled or out commented in the *<GlobalNamingResources>* section of the tomcat server.xml because it uses the default camunda h2 database. This should not be used for the Standby Planning module.
[source, xml]
    <Resource auth="Container" 
    	defaultTransactionIsolation="READ_COMMITTED" 
    	driverClassName="org.h2.Driver" 
    	factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" maxActive="20" 
    	maxIdle="20" minIdle="5" name="jdbc/ProcessEngine" password="sa" 
    	type="javax.sql.DataSource" uniqueResourceName="process-engine" 
    	url="jdbc:h2:./camunda-h2-dbs/process-engine;MVCC=TRUE;TRACE_LEVEL_FILE=0;DB_CLOSE_ON_EXIT=FALSE" username="sa"/>