Documentation

Database Settings

You can access the database settings in the firstrun wizard (see First Run Configuration ) or later on through

  1. https://<host>/admin

  2. General Settings

  3. Database

H2 Database

The H2 configuration offers the following options

  1. Username: is used for authenticating against the database. This can be left empty.

  2. Password: is the according password. This can be left empty.

  3. Path: is an absolute or relative path which will contain the database

  4. Filename: determines the naming schema for the database files within the given path.

  1. Click on validate.
    If there are any issues, then please solve them by editing the values. In any case, you can also double check the logs at /logs-

  2. Click on save to store the configuration (and to move on to the next screen Authentication Provider

Postgres Database

The Postgres configuration offers the following options

  1. Username: is used for authenticating against the database.
    The given user must be allowed to create, delete, alter tables and indexes. And it must be allowed to create, update and delete records in the given database.

  2. Password: is the according password.

  3. URL: this is the connection string to the database, which is <FQDN of the instance>:<port>/<databaseName>

  1. Click on validate.
    If there are any issues, then please solve them by editing the values. In any case, you can also double check the logs at /logs-

  2. Click on save to store the configuration (and to move on to the next screen Authentication Provider

Microsoft SQL

The Microsoft SQL configuration offers the following options

  1. Username: is used for authenticating against the database.
    The given user must be allowed to create, delete, alter tables and indexes. And it must be allowed to create, update and delete records in the given database.

    Also this user must be created through SQL Server Authentication. Mixed mode and Windows authentication is not supported as of now.

  2. Password: is the according password.

  3. URL: this is the connection string to the database, which is <FQDN of the instance>:<port>

  4. Name of the database: is the according database

  1. Click on validate.
    If there are any issues, then please solve them by editing the values. In any case, you can also double check the logs at /logs-

  2. Click on save to store the configuration (and to move on to the next screen Authentication Provider