Core configuration of Service.
Used for connecting to NetServer, the database and putting your service installation in maintenance mode.
Example of a config file
dbHost = localhost
dbUsername = crm7
dbPassword = password
dbDatabase = SuperOffice
dbType = mssql
nsUser = ejSysUser
nsPass = cpbtrzdo
nsAnonUser = ejSysUser
nsAnonPass = cpbtrzdo
nsEndPoint = http://localhost/NetServer/Services8x
defaultContact = 2
#frozen
Explanation of configuration settings
If a configuration setting is prefixed by a #, it means it is commented out and will not be read by the system. This is mostly used for the frozen setting.
dbHost
IP address or resolvable hostname of your database server.
dbUsername
Username for connecting to the SuperOffice database.
dbPassword
Password for the username used when connecting to the SuperOffice database.
dbType
Type of database, e.g. mssql or oracle.
nsUser
Username for connecting to NetServer.
This username defaults to ejSysUser and has a randomly generated password upon installation.
The user needs to have the type "System user" and an "Active" login under "Users"->"Other users" in your admin client. Be aware that "Other users" is only accessible when logging into the web admin client with a system user, i.e. crm7.
You might want to change this password if you had to recreate your Service installation and the newly randomized password in the config file is not identical to the one stored in the database.
nsPass
Password for the username used when connecting to the NetServer. For more information see above.
nsAnonUSer
Same as above, but used for anonymous access
nsAnonPass
Same as above, but used for anonymous access
nsEndPoint
Resolvable URL for your NetServer installation. Running upgrade.exe will automatically set the correct Services version, but below is an overview.
Please note that Service still does not support running https on the NetServer it uses. See our recommended scenario #2 on how to use reverse proxy to secure the installation but make sure the endpoint for Service inside is using http.
Which Services end point to use?
Versions / client |
Web |
Service |
9.1 and newer |
services88 |
services88 |
8.5 R09 - R15 |
services88 |
services88 |
8.5 R01 - R08 |
services87 |
services87 |
8.4 R07, R08 |
services87 |
services87 |
8.4 R01 - R06 |
services86 |
services86 |
8.3 R02, R03, R04 |
services86 |
services86 |
8.3 R01 |
services85 |
services85 |
8.2 |
services84 |
services84 |
8.1 |
services84 |
services84 |
8.0 SR3, SR4, SR5, SR6 |
services82 |
services82 |
8.0, SR1, SR2 |
services80 |
services80 |
Pocket CRM will automatically pick up the correct Services folder.
defaultContact
Should always be an integer with the ID of the company owner card in your crm7.contact table.
In most scenarios this should be 2 (SuperOffice having ID 1), but in some older installations the owner card can be 1.
frozen
Takes no parameters, but when not commented out it sets Service in maintenance. Valuable when you want to avoid having users logging/being logged in when you have scheduled/announced an update/maintenance. Always remember to remove this or comment it out after you have completed your maintenance.