Share this page

# Server management

You can configure application servers, add and configure database servers in Site Administration.

In this topic:

## Configure server log file settings

You can set the server log files and the maximum number of database connections.

To configure log file settings:

In the Servers > Application Servers tab, under the Client Log File Settings, Site Administration Log File Settings, and Project Planning and Tracking Log File Settings sections, define the following:

Log Level | Click the Log Level drop-down list and select the type of log file you want the server to create. None. Does not create a log file. Errors. Records error events. Warnings. Records potentially harmful situations. Flow. Records informational messages that highlight the application flow. Debug. Records events that are most useful for debugging.
Max. Log Lines | Define the maximum number of lines that can be written to the log file. A new log file is created after the log file reaches the maximum number of lines. The default value is 10,000.
Max. Log Days | Define the maximum number of days that the server keeps the log file. The log files are deleted automatically once the maximum number of days is reached. The default value is Unlimited.
Log File Location | Enter the directory path of the log file. Caution: Saving logs on a remote server may cause performance issues. We recommend that you save logs to the local file system. If the local file system has limited space, prepare a script which periodically moves the logs to network storage.

To set the maximum number of database connections:

In the Servers > Application Servers tab, under the Miscellaneous section, set the Max. Database Connections field.

For information on maximum database connections, see What is the purpose of " Maximum database connection" parameter.

Back to top

## Add database servers

You can define new database servers that were not defined during installation.

Note: To make Text Search unavailable on a new database server, you must disable Text Search on the database server before you define the new database server.

Permission:

To add a database server, you should be site admin.

To add a database server:

1. Open Site Administration > Servers tab > DB Servers tab.

2. Click the add button. In the Create Database Server dialog box, enter the following information.

   Database Type | Select the type of database server you want to define: Oracle. Uses Oracle authentication. MS-SQL (SQL Auth.). Authenticates the user to the database using a database user name and password. MS-SQL (Win Auth.). Windows authentication relies on the user being authenticated by the operating system. MS-SQL (AAD Auth.). Authenticates the user to the database using an Azure AD account.
   Database Name | Give the new database server a name.
   DB Admin User | Enter the login name of the database administrator. For the MS-SQL (SQL Auth.) database type, the administrator user account that enables you to create projects. By default, it is sa. For the MS-SQL (Win Auth.) database type, the DB Admin User field is not required. The login name of the database administrator is the Windows user that is set to run OpenText Application Quality Management as a service. For the Oracle database type, the administrator user account that enables you to create projects. By default, it is system. For the MS-SQL (AAD Auth) database type, the Azure AD account that enables you to create projects.
   DB Admin Password | Enter the password of the database administrator. For the MS-SQL (Win Auth.) database type, the DB Admin User field is not required.
   ALM User Password | Required only when you create a MS-SQL (SQL Auth.) database. Set the password for the OpenText Application Quality Management td user who can access the database schema.
   Default Connection String | Select either Connection String Parameters or Connection String to define the default connection string.
   Connection String Parameters | Define the default connection string by providing values for the following parameters: Server Host. The database server hostname or IP address used to connect to the database. Port. The port number of the database server. Oracle Service Name. Available for Oracle databases. Enter the service name for the new Oracle database server.
   Connection String | Enter the default connection string. For Oracle RAC support, you can enter the connection string by following the example below. Copy code
       jdbc:company:oracle:TNSNamesFile=<ALM server>\tnsnames.ora;TNSServerName=OrgRAC
   tnsnames.ora is a file that contains the Oracle database addresses. OrgRAC is the address of the TNS server OpenText Application Quality Management should refer to. Note: To enable Oracle RAC support, set the ORACLE_RAC_SUPPORT site parameter to Y. For details, see Site Parameters.

3. To check whether you can connect to the database server, click Ping.

4. Click OK to add the database server.

Back to top

## Modify database server properties

You can modify the properties of a database server after you add it.

Permission:

To update a database server, you should be site admin.

To modify the properties of a database server:

1. Open Site Administration > Servers tab > DB Servers tab.

2. From the servers list, select the database.

3. Edit the following properties.

   Database Administrator User Name | Enter the login name of the new database administrator. For details about database administrator username, see DB Admin User.
   Database Administrator Password | Enter the password of the new database administrator. Alternatively, you can click the Change Password button to enter the new password.
   Application Lifecycle Management User Password | Click the Change Password link to modify the password of the td user who can access the database schema.
   Text Search | Click Enable to enable Text Search capabilities on the database server. You cannot disable Text Search after you enable it. For details, see Configure Text Search.
   Default Search Language | Editable when Text Search is enabled. Select the default Text Search language for the database server.
   Connection String | Click the Change Connection String link to change the connection string.

4. Click Ping to check whether you can connect to the database server.
5. Click Save to save your changes, or Restore to cancel your changes.

Back to top

See also:

- Project management

https://admhelp.microfocus.com Application Quality Management 8942
Tips to improve your search results... OpenText™ Application Quality Management Help Center OpenText™ Application Quality Management Help Center OpenText™ Application Quality Management Help 26.1 All View Local Help Center View Online Help Center Version: