Define a production database
Connection events are stored in the UserLock database. The installation package provides a free database (MS Access file) that we recommend only for evaluation purposes.
UserLock supports the following production database systems:
- MS SQL Express 2005 and newer - 32/64-bit.
- MS SQL Server 2005 and newer - 32/64-bit.
- MySQL 5.6 and newer. MySQL is greyed out until you download the driver on the editor’s web site, here is the link: https://dev.mysql.com/downloads/connector/odbc/
You need to install the 32 bits driver even if you are using a 64 bits OS. Once installed, MySQL won't be anymore greyed out.
- The MySQL .NET connector must not be installed
Please note that LocalDB editions are not supported.
Table that maps the server name in the examples to their roles in the application:
|Server Role||Server Name|
|Primary UserLock Server||ULSRVPRIMARY|
|SQL UserLock Server||ULSRVDB|
To define your production database:
Create an empty database for UserLock in your MS SQL or MySQL database system.
In the UserLock console, select your UserLock server in the menu tree and click on 'Properties' in the 'Quick access' panel.
Display the 'Database' section.
Verify that the box 'Store all events in database' is checked. This option needs to be enabled to log all connection events in the UserLock database.
Switch the 'Database configuration' to 'Other database' and click on the right button to launch the wizard that will guide you.
Select your database system and click on 'OK'.
Enter the connection details using an account having rights to create tables on the database. Select the database you've previously created at step 1.
Click on 'Test' to check the connection and, if everything is alright, click on 'OK'.
Click on 'Create database tables'. Please note that this operation to create tables should only be launched once a new empty database has been set up.
The new database has now been defined. Click on 'OK' in the 'Quick access' panel to validate the settings.
To learn more about all the settings present in the 'Database' section, please see the help reference here.