The OpenLM Applications Manager Database Configuration tool has been created to help administrators configure and replace the default Hyper SQL Database (HSQLDB) used by the Applications Manager with either a SQL Server or a MySQL database.
The Applications Manager DB Configuration tool requires that your Applications Manager license include support for external databases. If in doubt, please contact sales or support for assistance.
Additionally, if you’re running the Applications Manager in conjunction with hundreds of OpenLM Workstation Agent installations, make sure to read the Optimal Configuration for Applications Manager guide.
Launching the Database Configuration Tool
On Windows
The Applications Manager DB Configuration tool can be started from
- The Windows Start Menu (Start → OpenLM → OpenLM Applications Manager DB Configuration)
- By executing the database_configuration.bat file located in the OpenLM Applications Manager folder (typically C:Program FilesOpenLMOpenLM App Manager)
On Linux
1. Open the folder where you have extracted and installed the OpenLM Applications Manager files.
2. Run the app_manager.sh script with dbconfig as a parameter:
sudo ./app_manager.sh dbconfig
Configuring HSQLDB
This is the default database that is provided with OpenLM Applications Manager. If you haven’t changed your DB type, it will be selected by default from the DB Provider dropdown menu.
1. Edit the required settings as follows:
Connection Pool Size – this is the number of parallel connections that can be made to the database at one given moment (default: 50)
DB File Location – the location of the HSQLDB database folder (default: the db/ folder which is located in the same folder as the Applications Manager)
User – the database username used for connecting to the database (default: sa)
Password – the database password associated with the username used to connect to the database
2. Click Apply to save the settings and close the DB Configuration tool.
4. Restart the Applications Manager service:
On Windows: Open Windows Services (press Windows + R, type in services.msc and press Enter) and restart the “OpenLM App Manager” service.
On Linux: Run the following command
sudo ./app_manager.sh restart
or
sudo ./app_manager.sh stop
then
sudo ./app_manager.sh start
Configuring MySQL
To configure the Applications Manager to interface with a MySQL database:
1. Select “MySQL” from the DB Provider dropdown menu.
2. Edit the required settings as follows:
Connection Pool Size – number of parallel connections that can be made to the database at one given moment (default: 50)
Server – the MySQL server name
Port – the MySQL server access port
DB Name – the name of the DB you would like to access
User ID – the User ID used to connect to the database
Password – the database password associated with the User ID used to connect to the database
3. Click Apply to save the settings and close the DB Configuration tool.
4. Restart the Applications Manager service:
On Windows: Open Windows Services (press Windows + R, type in services.msc and press Enter) and restart the “OpenLM App Manager” service.
On Linux: Run the following command
sudo ./app_manager.sh restart
or
sudo ./app_manager.sh stop
then
sudo ./app_manager.sh start
Configuring SQL Server
To configure the Applications Manager to interface with a MS-SQL database:
Using SQL Server Authentication
1. Select SQL Server (SQL Server Authentication) from the DB Provider dropdown menu.
2. Edit the required settings as follows:
Connection Pool Size – number of parallel connections that can be made to the database at one given moment (default: 50)
Server – the SQL server name
User ID – the User ID used to connect to the database
Password – the password associated with the User ID used to connect to the database
DB Name – the name of the DB you would like to access (can either by typed in or selected from the dropdown list once the Server, User ID and Password fields have been set)
3. Click Apply to save the settings and close the DB Configuration tool.
4. Open Windows Services (press Windows + R, type in services.msc and press Enter) and restart the OpenLM App Manager service.
Using Windows Authentication
Please note that connecting to SQL Server using Windows Authentication is possible once the following prerequisites have been met:
- The OpenLM service is set to log in with a user that has “Local System Account” permissions
- The MS-SQL server is set to grant access to that user through Windows Authentication
Once these prerequisites have been met, the steps are as follows:
1. Select SQL Server (Windows Authentication) from the DB Provider dropdown menu.
2. Edit the required settings as follows:
Connection Pool Size – number of parallel connections that can be made to the database at one given moment (default: 50)
Server Name – the SQL server name
DB Name – the name of the DB you would like to access (can either by typed in or selected from the dropdown list once the Server field has been set)
3. Click Apply to save the settings and close the DB Configuration tool.
4. Restart the Applications Manager service:
On Windows: Open Windows Services (press Windows + R, type in services.msc and press Enter) and restart the “OpenLM App Manager” service.
On Linux: Run the following command
sudo ./app_manager.sh restart
or
sudo ./app_manager.sh stop
then
sudo ./app_manager.sh start
