Navigation:  Installation & General Information > Installation > WebOffice usermanagement (Application Server) > Configure the File web.config >

SQLITE Connection Parameter

Previous pageReturn to chapter overviewNext page

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>

 

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

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

Note: 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 Usermanagement Admin Web list of profiles

Host

TNS entry that is saved in tnsnames.ora

Note: 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

Note: This password is used for securing  the web-interface of the UserManagement Admin Web. ATTENTION: This is not a direct encryption of the file database. Restrictions concerning access of the database files have to be done by system permissions.

Note: The administrator has to encrypt the password with the password.exe application. 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.

Note: 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 UserManagement Admin Web to reload the UserManagement 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.