OpenLM Database Configuration Form - KB3025 - OpenLM Software License Management
Israel +972 4 6308447         USA +1 619 831 0029              JAPAN +81 505 893 6263 担当:萩原

OpenLM Database Configuration Form – KB3025

You are here:
< All Topics

 

OpenLM software supports the use of leading database systems as its storage base. The OpenLM Server is configured by default to use the Firebird embedded DB. It could also be configured to use the MS SQL Server, MySQL, MariaDB databases which are very popular in organizations.

In this guide we will explain the different options available in the OpenLM Database Configuration form.

Table of Contents

Accessing OpenLM Database Configuration Form

Firebird Embedded Database

Firebird External DB Configuration

MS SQL Server

SQL Server Windows Authentication

SQL Server Authentication

Non-Standard SQL Server Port

MySQL or MariaDB

 

Accessing OpenLM Database Configuration Form

The OpenLM Database Configuration form is accessible by Clicking the Windows’ ‘Start’ button → OpenLM →  OpenLM Server DB Configuration.

 

Firebird Embedded Database

This is the default option. OpenLM is using an embedded FireBird database.

The DB file is stored under the server installation folder.

DB file stored under the server installation folder

Using this form, the user can set the location of the database by moving the DB file and changing the defined path. The form also enables the user to change the “user/password” according to what is defined in the database itself.

Firebird Embedded Database Configuration

 

Firebird External DB Configuration

OpenLM can be configured to use the non-embedded Firebird Server database. The database features improved performance, and enables database administrators full access to the data, in conjunction with the OpenLM Server. The use of a Firebird Server database requires the installation and configuration of a Firebird server.

Firebird External DB Configuration

On the OpenLM DB configuration form, the ‘Embedded’ checkbox needs to be cleared (see image below).

Firebird External DB Configuration

MS SQL Server

The Microsoft SQL Server database is very popular in organizations and can be easily configured to work with OpenLM.

The SQL Server DBA creates the database using the Microsoft SQL Management Studio UI and can also use the OpenLM DDL (Database Definition Language) scripts in order to create a dedicated OpenLM DB on SQL server.

Using the MS SQL Server, OpenLM supports two authentication methods, that could be set according to the requirement of the organization:

  • SQL Server Authentication.
  • Windows Authentication.

 

SQL Server Windows Authentication

SQL Server Windows Authentication

  • Server Name – The SQL Server name.
  • Database Name – The name of the OpenLM Database.

 

SQL Server Authentication

SQL Server Authentication

  • Server – The SQL Server name.
  • Database name – The name of the OpenLM Database (Usually OpenLM is a good option).
  • User ID – The user with permissions on OpenLM database.
  • Password – The OpenLM User password as defined in MS SQL Server.

 

Non-Standard SQL Server Port

If you want to use a different TCP port other than standard 1433 port, then you can mention the host and specific port in the Server field, as shown in the image below:

 

MySQL or MariaDB

OpenLM supports MySQL and MariaDB databases. The MySQL/MariaDB Server DBA creates the database using the MySQL Workbench tool and can also use the OpenLM DDL (Database Definition Language) scripts in order to create a dedicated OpenLM DB on MySQL server.

Select ‘MySql’ in the drop-down menu, type in the required credentials and employ the MySQL database on your system.

Select ‘MariaDb’ in the drop-down menu, type in the required credentials and employ MariaDB on your system.

Note: If you still require technical assistance, please feel free to contact the OpenLM support team at support@openlm.com

Previous OpenLM components’ logging parameters – KB4018
Next OpenLM Database migration – KB4025f
Table of Contents