Step 5: Updating the migrated product connection strings

Step 5.1: Generating the cluster_config.json file

Generate the latest cluster_config.json file as follows:

• Option A: If you have the old cluster_config.json, generate the configuration file from the cluster by running the following command on the server node:

  cd /opt/UiPathAutomationSuite/{version}/installer
  
  ./configureUiPathAS.sh config get -i /path/to/old/cluster_config.json -o ./cluster_config.json

• Option B: If you do not have the old cluster_config.json file, generate an override of any default values resulted during the installation of the previous version by running the following command on the server node:

  cd /opt/UiPathAutomationSuite/{version}/installer
  
  ./configureUiPathAS.sh config get -o ./cluster_config.json

Note:

For details on how to configure the cluster_config.json parameters, see Advanced installation experience.

Step 5.2: Providing the new connection strings for installed products

You must provide the database connection string to the restored databases.

• To provide the restored connection string to the Orchestrator service, add or update sql_connection_str under orchestrator in the cluster_config.json file:

  "orchestrator": {
    "sql_connection_str": "<dotnet connection string>",   (added line)
    "enabled": true
  }

• If Test Automation tables are placed inside the standalone Orchestrator database, you can add the same connection string for Test Automation feature inside the cluster_config.json file:

  "orchestrator": {
      "testautomation": {
        "enabled": true,
        "sql_connection_str": "<restored orchesrator connection string>"
      },
    "sql_connection_str": "<restored orchesrator connection string>",   (added line)
    "enabled": true
  }

• To provide the restored connection string to the Insights service, add or update sql_connection_str under insights in the cluster_config.json file.

  "insights": {   
     "sql_connection_str": "<restored connection string>",   (added line)
     "enabled": true }

Note: Make sure you escape special characters in the connection string's password.

Step 5.3: Running the service installer

Online

To run the service installer in an online environment, run the following command on the server node:

cd /opt/UiPathAutomationSuite/{version}/installer

./install-uipath.sh -i ./cluster_config.json -s -o output.json --accept-license-agreement

Offline

To run the service installer in an offline environment, use the following command on the server node:

cd /opt/UiPathAutomationSuite/{version}/installer

./install-uipath.sh -i ./cluster_config.json -s --install-type offline -o output.json --accept-license-agreement