Config and INI files

•

Environment: onsite

Some tooltip text!

• 3 minutes to read

 • 3 minutes to read

The SuperOffice Web client (as well as remote web services and Service) uses web.config to specify database connection details.

SuperOffice Windows client uses SuperOffice.config, in addition to SuperOffice.ini.

Note

The web.config file is an XML file that can be changed as needed, but we recommend running the SuperOffice Web Configurator. Administrators can use configuration files to set policies that affect how applications run on their computers.

SuperOffice Web

• Enable debug log (Web)
• Web.config
• Web Tools Diagnostics

Service

• Web.config
• Service log files
• Service config
• Debug service tasks failing or not running

SuperOffice Win

• Enable debug log (Win)
• SOUser.ini Used by SOCRM.exe, SOAdmin.exe, and ReporterStudio.exe
• SuperOffice.config Used by SOCRM.exe, SOAdmin.exe and ReporterStudio.exe
• Command line switches for SOCRM.exe, SOAdmin.exe

.ini versus .config (Windows)

SuperOffice.config is a NetServer config file in the same place as SuperOffice.ini (also found in the same way, if you come in via COM).

The database user and password are stored in SuperOffice.config - encrypted and set by the MSI installer.

ODBC data source and archive path are taken from SuperOffice.ini automatically. The SuperOffice.config file doesn't need to specify the database server/type unless the ODBC source is non-standard.

The SERVER and DATABASE are dictated by the ODBC source in the SuperOffice.ini file. We look up in the Registry and transfer database and server settings to NetServer (not SuperOffice.config, but directly to NetServer without writing to the .config file).

The database user and password go the other way, from SuperOffice.config to both NetServer and the C++ code.

How to find SuperOffice.ini

1. To find the configuration file for SuperOffice (SuperOffice.ini), right-click the SuperOffice icon on the desktop or in the start-menu, and choose Properties.

2. In the window that opens up click Open File Location. A file explorer window will open and you will see the SuperOffice program files.

3. Find the file SuperOffice.ini, and open this file.

Security considerations

1. ServerSetup encrypts and saves the database credentials in an MST file.
2. Client setup extracts the credentials and stores them in the local .config file
3. NetServer decrypts these credentials on behalf of the Windows client.
4. ServerSetup also creates a system user with the same credentials, giving that username a dual role.

The same credentials are used to access NetServer Web Services.

The following steps are recommended to increase security:

• Deactivate the default system user in the SoAdmin client.
• Create a new pair of database and system users specifically for Sales and Marketing Web and Service.