Update the application database password - Data360_Analyze - Latest

Data360 Analyze Server Help
Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 Analyze
Version
Latest
Language
English
Product name
Data360 Analyze
Title
Data360 Analyze Server Help
Copyright
2024
First publish date
2016
Last updated
2024-11-28
Published on
2024-11-28T15:26:57.181000

Update the application database password on Linux

To update the application database password on Linux, do the following:

  1. Shutdown the Data360 Analyze application, see Starting and stopping the Data360 Analyze Server.
  2. Startup the Data360 Analyze Database, see Starting and stopping the Data360 Analyze Server.
  3. Change the database password for the application database user by running the following commands:
    1. Start a bash shell.
    2. Run the command:

      source <install-dir>/.profile.lavastorm

    3. Run the command:

      <install-dir>/platform/linux-x86-64/pgsql/bin/psql -U dataverse -c '\password' lavastorm

      1. Enter the existing database user password when prompted. The default password after install is 'dataverse'.
      2. Enter the new database user password when prompted.
  4. Update the database password in the credential storage:
    1. If storing the database password in <site-dir>/conf/cust.prop:
      1. Run the command (in the same command environment as step 3):

        laeConfig properties generate --encrypt ls.lae.webapp.dbKey <new-database-password>

      2. Edit the <site-dir>/conf/cust.prop and either add or update the line setting the property ls.lae.webapp.dbKey with the output of the previous command.
    2. If storing the database password in a KMS, update the KMS key with the new password.
  5. Stop the Data360 Analyze Database
  6. Restart the Data360 Analyze application.

Update the application database password on Windows

To update the application database password on Windows, do the following:

  1. Shutdown the Data360 Analyze application, see Starting and stopping the Data360 Analyze Server.
  2. Startup the Data360 Analyze Database, see Starting and stopping the Data360 Analyze Server.
  3. Change the database password for the application database user by running the following command
    1. Start a cmd prompt.
    2. Run the command: <install-dir>\bin\laeEnv.bat
    3. Run the command:

      <installDir>platform\windows-x86-64\pgsql\bin\psql.exe -U dataverse -c "\password" lavastorm

      1. Enter the existing database user password when prompted. The default password after install is 'dataverse'.
      2. Enter the new database user password when prompted.
  4. Update the database password in the credential storage:
    1. If storing the database password in <site-dir>/conf/cust.prop:
      1. Run the command (in the same command environment as step 3):

        laeConfig.bat properties generate --encrypt ls.lae.webapp.dbKey <new-database-password>

      2. Edit the <site-dir>/conf/cust.prop and either add or update the line setting the property ls.lae.webapp.dbKey with the output of the previous command.
    2. If storing the database password in a KMS, update the KMS key with the new password.
  5. Stop the Data360 Analyze Database
  6. Restart the Data360 Analyze application.