Handle database-related issues

This topic provides instructions for handling database-related management tasks.

Change site schema settings and reinitialize

If you need to make changes to the site schema settings, make the changes in the octane.conf file.

To change site schema settings and reinitialize:

  1. Obtain the names of the indexes related to your instance of ALM Octane in the sharedspace_logical_name.txt in the C:\Program Files\octane\server\conf\ folder.

  2. Delete the database site schema.

  3. Delete the repository.

  4. Delete the mqm_<sp_logical_name> indexes from Elasticsearch. From the command prompt on the ALM Octane server, run:

    curl -XDELETE 'http://<server address>:9200/mqm_<sp_logical_name>/'
  5. Select Start > ALM Octane > Start ALM Octane Server.

Back to top

Update database password in ALM Octane site schema and configuration files

If you change your database password, you can use the database password update tool to update the database password in ALM Octane’s site schema, and in the octane.conf configuration files. Note that this does not update the database user’s password, but only ALM Octane's configuration.

Note: The tool operates offline. Credential outputs are disabled for security.

Stop the ALM Octane server, and run the following command on your ALM Octane server:

\opt\octane\install\updatedbcreds.bat

The cluster is considered offline when there is no activity from any node for 30 seconds. After stopping the server, wait 30 seconds before running the tool.

Enter values as described in the sections below. When you are done, start the ALM Octane server.

Usage

The tool can operate in 2 modes: file, or interactive.

updatedbcreds.sh <-m mode> <-f path | -t target>

Where:

  • mode = {file | interactive}

  • target = {admin | user}

  • path = valid absolute or relative path to file

File. If mode is set to file, use -f to specify the path to the password definition file. Credentials will be taken from the provided file.

Interactive. If mode is set to interactive, use -t to specify the target whose password you want to change - either admin or user. You will enter credentials interactively. Note that either the admin or user definition can be omitted. In this case the other user's password is taken and its password will not change.

Back to top

See also: