Reset SQL Credentials

Procedure

  1. You must define your configuration in the silentinstaller.yml file. Update the following parameter in the silentinstaller.yml file:
    Parameter Description
    WEBCLIENT_INSTALLATION_PATH: "" Enter the Web Client Installation path in which you want to install. For example, WEBCLIENT_INSTALLATION_PATH: "/home/ administrator/install/"
    PLANT_APPS_DB_SERVER: "" Enter the Plant Applications database server hostname that you want to connect with the Plant Applications Web Client.
    PLANT_APPS_DB_INSTANCE: "" Enter the name of the instance of the SQL server. You can leave this parameter empty if not using an instance. For example, PLANT_APPS_DB_INSTANCE:"sa"
    Note: Do not add a backslash (\) when entering the instance name.
    PLANT_APPS_DB_NAME: "" Enter the Plant Applications Database name. For example, PLANT_APPS_DB_NAME:"SOADB"
    PLANT_APPS_DB_USERNAME: "" Enter the username that has permissions to access the database you entered.
    PLANT_APPS_DB_PASSWORD: "" Enter the password for the username you entered.
    PLANT_APPS_DB_PORT: "" Enter the SQL Server port.
  2. Access the utility.sh file in the plantapps-enterprise-webclient-<buildno> folder.
  3. Provide execution permissions to utility.sh file by running the following command: sudo chmod +x your/pathto/installer/plantapps-enterprise-webclient-<buildno>/utility.sh
  4. Run the utility.sh file by running one of the following commands:
    • If you are running this utility directly on the Enterprise Edition Web Client node: <installer path>/plantapps-enterprise-webclient-<buildno>/sudo ./utility.sh -l -sql reset
    • If you are running this utility remotely on the Enterprise Edition Web Client node: <installer path>/plantapps-enterprise-webclient-<buildno>/sudo ./utility.sh -r -sql reset
    Docker secrets are created based on the values you entered, and the Docker stacks are redeployed so that the containers use the new credentials.