How to Change the Password of a Database User

When the password of a database user is changed, it is necessary to change the password of the connection properties of particular subsystems:

Dispatcher Paragon Management Service

The passwords must be changed in the configuration files when the user password of a connection to the database is changed:

  • <DispatcherParagon_DIRECTORY>\Management\ims\application.properties (if the password in an IMS database is changed)

    • spring.datasource.password – the password of a user for a common connection to an IMS database (typically, a database with postfix _IMS in its name, and a default user with the username "postgres" or "sa")

  • <DispatcherParagon_DIRECTORY>\Management\conf\safeq.properties (if the password to the main database is changed)

    • database.global.management.password – the password of a user for a common connection to the database (typically, a default user with the username "postgres" or "sa")

    • database.cluster.management.password – the password of a cluster management user (typically, a user with the username cluster_mngmt)

    • database.cluster.guest.password – the password of a cluster guest user (typically, a user with the username cluster_guest)

In the case of SQL Server domain authentication, there is no need to change passwords in the configuration files because the domain user password is used.

The passwords must be changed in database tables when a user with the username "tenantuser_*" or "dwhtenantuser_*" is changed

  • cluster_mngmt.tenants – see the database password according to select "SELECT db_pass FROM cluster_mngmt.tenants WHERE db_login='<username>'" and alter the user password according to general database documentation.

  • cluster_mngmt.tenant_warehouses – see the database password according to select "SELECT db_pass FROM cluster_mngmt.tenant_warehouses WHERE db_login='<username>'" and alter the user password according to general database documentation.

For detailed information on how to alter a user password, see Recovery of databases documentation.

Dispatcher Paragon Payment System

The passwords must be changed in configuration files when the user password of a connection to the database is changed:

  • <DispatcherParagon_DIRECTORY>\YPS\ps-conf\environment-configuration.properties

  • database.password – the password of a user for a common connection to the database (typically, a default user with the username "postgres" or "sa")

In the case of SQL Server domain authentication, there is no need to change the passwords in the configuration files because the domain user password is used.

Password Encryption

Passwords in the configuration files

Passwords in the configuration files can be in plain text or encrypted by the utility provided by Dispatcher Paragon as a widget on Dashboard:

  1. Sign into Management Service interface as an administrator (into a tenant scheme if it is in a multi-tenant environment).

  2. Stay on Dashboard.

  3. Find the Text Encryption widget or enable it (click the Add widget button).

  4. Enter the text to encrypt.

  5. Click the Encode button at the bottom of the widget.

  6. Copy the text to the clipboard or transcribe it and replace the original password in the property file.

images/download/attachments/153629489/image2017-4-26_16_28_19.png

Passwords in the Database

Passwords in the database are in plaintext.