SQLITE Connection Parameter |
  
|
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>
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. |