We’ve developed some resources to help you work effectively from home during COVID-19 Click to learn more

Service config

In this article

    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
    8.5 R09 and newer services88 services88
    8.5 R01 - R08 services87 services87
    8.4 R07, R08 services87 services87
    8.4 R01, R02, R03, R04, R05, 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.