Skip to main content
Skip table of contents

Set up database schemes

A DBMS is necessary for using LUY. This page shows all steps to set up the recommended LUY database scheme.

The iTURM identity management solution delivered together with LUY needs a second database to hold the authentication and authorization information.

MySQL / MariaDB

Before setting up a LUY database, ensure that the right settings are entered for character set and collation, enabling text in German and English each to be stored correctly. Therefore, set up the LUY database with the following SQL command:

CREATE DATABASE databasename
CHARACTER SET utf8
COLLATE utf8_bin;

After that, create a new database user with full access privileges for the LUY database. The following SQL commands are required to give this user both local and remote access to the database:

GRANT ALL PRIVILEGES
ON databasename.*
TO 'username'@'localhost'
IDENTIFIED BY 'userpassword';

If the user in question does not already exist, executing these commands will automatically create a new user.

PostgreSQL

Before setting up a LUY database, ensure that the right settings are entered for character set and collation, enabling text in German and English each to be stored correctly. Therefore, set up the LUY database with the following SQL command:

CREATE DATABASE databasename
OWNER = role_name
ENCODING = UTF8;

MS SQL Server

Before setting up a LUY database, ensure that the right settings are entered for character set and collation, enabling text in German and English each to be stored correctly. Therefore, set up the LUY database, e.g., with the Microsoft SQL Server Management Studio:

  • Currently, only the usage of Latin-1 characters (ISO/IEC 8859-1) will work properly in LUY. It is recommended to set up the database with the standard collation Latin1_General_CI_AS.

  • The server login used for LUY must have sufficient privileges to create and alter tables insert, update, delete data. Please ensure that you run the installer and migration/initialization/repair scripts with the login that you configured for the LUY application. This is necessary, because the login user's default schema must be the same schema which contains the tables for LUY.

  • We recommend using server authentication with a local SQL-user username and password. The Windows authentication method is more elaborate and needs additionally configured infrastructure.

Oracle DB

Before setting up a LUY database, ensure that the right settings are entered for character set and collation, enabling text in German and English each to be stored correctly. The following properties are required for the database user schema when using an Oracle database system:

  • Default character set: WE8ISO8859P1 (or a superset like AL32UTF8)

  • Country specific character set: AL16UTF16

  • Roles for the database user:

    • CONNECT

  • Rights for the database user:

    • CREATE SEQUENCE

    • CREATE TABLE

  • Tablespace/quota: Minimum of 10MB, but we recommend 100-200MB and adequate quota for this user on the assigned table space. To provide an unlimited quota, adapt and execute this command:

    • ALTER USER <username> QUOTA UNLIMITED ON <schemaname>;

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.