WebOffice > Installation > WebOffice usermanagement (Application Server)

Note: Before configuring the file web.config, plaese create a database in your selected RDBMS that will serve as usermanagement 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 UserManagement 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.

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.

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

<Profile>My MSSQL Profile</Profile>

<Host>MyServer\sql2008</Host>

<DatabaseType>MSSQL</DatabaseType>

<DatabaseName>MySQL_Database</DatabaseName>

<Username>MyUsername</Username>

<Password>KH4yhJLabVaPSxrXOGCb7g==</Password>

</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 MSACCESS 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 Note: For details how to encrypt your password, please see chapert 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. 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	Valid values: 0 1

Overview of the User Management database connection properties

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

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

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

Configure the File web.config