Print

Changing PostgreSQL user account passwords

About this task

Experience Portal uses the following PostgreSQL user accounts:

Default account name Description
postgres The database administrator can use this account to log in to the local Avaya Experience Portal database and perform database administration tasks.

The password for this account is automatically generated. You cannot add other accounts of this type, delete this account, or change the account name.

importantImportant:

Contact the Avaya Services representative to modify the local VoicePortal database as the database contains critical configuration information used to run the system.

report You can have any number of accounts of this type with any account names.
reportwriter This user account can only change the data in the tables that store report data in the Experience Portal database on the Auxiliary EPM server.

You can have any number of accounts of this type with any account names.

importantImportant:

Contact the Avaya Services representative to modify the tables that store report data in the local VoicePortal database.

vpcommon This account allows each Auxiliary EPM server limited access to the main Experience Portal database, and it is required if you plan to configure an Auxiliary EPM server.

You can delete this account and set the password for this account, but you cannot add other accounts of this type or change the account name.

Use the SetDbPassword.sh script to change all account passwords and add and delete all accounts except for postgres, which you cannot delete.

Before you begin

If you have just installed the EPM software and are still logged into the EPM server, ensure that the environment variables are properly loaded.

Procedure

  1. Log on to Linux on the Experience Portal server with root privileges.
  2. Enter the cd $AVAYA_HOME/Support/Security-Tools/SetDbPassword command, where $AVAYA_HOME is an environmental variable pointing to the name of the installation directory specified during the Experience Portal software installation.
  3. Enter the bash SetDbPassword.sh update -u username command, where username is the name of the user account whose password you want to change.
  4. Type the password you want to use for this account and press Enter.

    When you change the password for the postgres account, Experience Portal stops and then restarts the vpms service.

  5. Enter the /sbin/service vpms status command to verify if the vpms service has started.

Next Steps

If you change the password for the vpcommon account on the primary EPM server, you must also change the password on the auxiliary EPM server.