SQLITE Connection Parameter

The example shows a connection profile of the following values:

Name: SQLite,

File: UserManagement.sqlite

 

<GeoUserManagementConnection>

<Profile>SQLite</Profile>

<Host>C:\UMDB_SQLite\UserManagement.sqlite</Host>

<DatabaseType>SQLite</DatabaseType>

<Password>SGLlPBiId+f0VGPc0VPyJA==</Password>

<DBOption></DBOption>

<KeepconnectionAlive>1</KeepconnectionAlive>

<WebOfficeURL></WebOfficeURL>

<WebOfficePassword></WebOfficePassword>

<WebOfficeProjectURL>https://mywebofficeserver.com/WebOffice/synserver?project=</WebOfficeProjectURL>

<KeepLoggingEntriesPeriode>0</KeepLoggingEntriesPeriode>

</GeoUserManagementConnection>

 

icon_comment

Encryption is not possible when using an SQLite file as a user management database. Alternatively, you can define access restrictions via IIS, for example.

The role Network Service and IUSR have to be granted full access to the SQLite file, so that the user management can access the file.

Please be aware, that WebOffice usermanagement creates a SQLite file for you, if the file is not available in the directory you have chosen.

 

Property

Description

Profile

Alias name that will be displayed in the User Management Admin Web list of profiles

Host

TNS entry that is saved in tnsnames.ora

icon_comment

Please insert the path to the specific SQLite file within the Host Parameter. Other file extensions (e.g. * .db3) are also possible.

DatabaseType

SQLite

Password

Password of the user

icon_comment

This password is used for securing  the web-interface of the UserManagement Admin Web.

The administrator has to encrypt the password with the password.exe application.

By removing or commenting out the parameter <Password>, no password is required when logging into UMAdminWeb.

icon_warning

CAUTION!

This is not a direct encryption of the file database. Restrictions concerning access of the database files have to be done by system permissions.

icon_cross-reference

See chapter Creating an Encrypted Password for details.

DBOption

To configurate provider-specific extensions.

KeepconnectionAlive

0: Defines, that the database connection is closed after every database access.

1: Defines, that the database connection keeps alive.

icon_comment

The value 1 improves the performance especially for MS Access, because the database connection keeps alive. But keep in mind that the session on the server also remains open for a bit  longer.

We recommend

'1 -> MS Access

'0 -> SQL and Oracle

WebOfficeURL

URL to the WebOffice administration page (SynAdmin): Enables a button in the User Management Admin Web to reload the user management data of the WebOffice application and reset the cache.

WebOfficePassword

Specified in days: If logging entries (of the self-registration) are older than the configured value, these logging entries will be deleted.

WebOfficeProjectURL

URL to the WebOffice project in order to communicate project approvals to users by mail. (e.g. after a group change by the administrator).

WebOfficePassword

Specified in days: If logging entries (of the self-registration) are older than the configured value, these logging entries will be deleted.