Configure the File "web.config"

icon_comment

Before configuring the file web.config, please create a database in your selected RDBMS that will serve as user management database.

 

The next configuration steps of UserManagement Admin Web are done inside the file web.config, which can be found at the C:\inetpub\wwwroot\UserManagementAdminWeb directory.

 

The file web.config holds the connection information to access the user management database(s) and the visibility settings for the wizards in UserManagement Admin Web. Every database connection has a connection profile (GeoUserManagementConnection).

From a technical point of view the connection is established via the file GeoProject.dll.

 

icon_comment

Note that you need at least a text editor capable of editing UTF8 text files for editing web.config, e.g. UltraEdit32, PSPad or Notepad++. Do NOT USE NOTEPAD instead – the web.config file would get corrupted then.

The configured database user has to be granted at least Read (Select) and Write (Insert, Update, Delete) rights at the tables of the User Management model.

 

<GeoUserManagement>
         <GeoUserManagementConnections>
                 <GeoUserManagementConnection>

                         <Profile>My MSSQL Profile</Profile>

                         <Host>MyServer\sql2008</Host>

                         <DatabaseType>MSSQL</DatabaseType>

                         <DatabaseName>MySQL_Database</DatabaseName>

                         <Username>MyUsername</Username>

                         <Password>KH4yhJLabVaPSxrXOGCb7g==</Password>

                         <ProviderExtension></ProviderExtension>

                         <KeepconnectionAlive>1</KeepconnectionAlive>

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

                         <KeepLoggingEntriesPeriode>0</KeepLoggingEntriesPeriode>

                         <WebOfficeURL></WebOfficeURL>

                         <WebOfficePassword></WebOfficePassword>

                 </GeoUserManagementConnection>
         <GeoUserManagementConnections>
<GeoUserManagement>

 

Parameter

Description

Valid & Default Values

Profile

Name of the database connection, which is shown at the dropdown box at the UserManagement Admin Web login site.


Host

Database host name (if necessary) and database instance (if necessary)


DatabaseType

Database type

ORACLE

MSSQL

POSTGRESQL

SQLITE

DatabaseName

Database name


Username

Database user name

(Not needed if database type is MSAccess; the application requires from a not secured MSAccess database the default login user name admin)


Password

Password of the database connection (if necessary) encrypted by the included software

icon_cross-reference

For details how to encrypt your password, please see chapter Creating an Encrypted Password.


ProviderExtension

Connecting to a  64-bit OLEDB-Client for Oracle and  MSSQL set the value .1'

Valid values:
<empty>
.1

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, Oracle and PostgresSQL

Valid values:

0

1

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).


KeepLoggingEntriesPeriode

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


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.


Overview of the user management database connection properties

 

Additionally to the connection entries there are some parameters concerning the password security:

<PasswordMinimalSize>1</PasswordMinimalSize>

<PasswordMinimalNumberDigits>0</PasswordMinimalNumberDigits>

<PasswordMinimalNumberLetters>0</PasswordMinimalNumberLetters>

<PasswordMinimalNumberSpecialCharacters>0</PasswordMinimalNumberSpecialCharacters>

<PasswordDiffersFromUserID>true</PasswordDiffersFromUserID>

 

Parameter

Description

Valid & Default Values

PasswordMinimalSize

Minimum number of characters in a password.

Space at the beginning or at the end are ignored. The maximal size is 64.

Default = 1

PasswordMinimalNumberDigits

Minimum number of digits in a password.

Default = 0

PasswordMinimalNumberLetters

Minimum number of letters in a password.

Default = 0

PasswordMinimalNumberSpecialCharacters

Minimum number of characters that are neither digits nor letters.

Default = 0

PasswordDiffersFromUserID

Can not the password be the same as the user id?

Default = true

Overview of the password security

 

icon_cross-reference

See the subsequent chapters ORACLE Connection Parameter, MSSQL Connection Parameter, POSTGRESQL Connection Parameter, SQLITE Connection Parameter and Menu Entries for details regarding the web.config configuration.