Changing the Database user password using the ./password-change.pl script fails.

Products

• VMware Smart Assurance

Issue/Introduction

Changing the database user password by using the ./password-change.pl script as shown below: 

[root@<Hostname> tools]# ./password-change.pl
+========================================================+
| Password Update Utility                                |
+========================================================+
| Available Commands:                                    |
|     [A]uto-Generate All Passwords                      |
|     [C]hange Single Password                           |
|     [S]ychronize from App Server                       |
|     [Q]uit                                             |
+========================================================+
Command: c
+========================================================+
| List of Users                                          |
+--------------------------------------------------------+
| 1. system                                              |
| 2. controlDaemon                                       |
| 3. int_mod_user                                        |
| 4. msa-user                                            |
| 5. jmx-user                                            |
| 6. smc-user                                            |
| 7. database                                            |
+========================================================+

But will fail when selecting database user with the following:

Changing password for voyence user
psql: FATAL: password authentication failed for user "voyence"
ERROR: Unable to update the voyence user password in voyencedb

Environment

NCM-10.1.x

Resolution

1. Log into the CLI of the database with 'root' access. 
   • su - pgdba
   • psql voyencedb voyence
   • Enter your old DB password when prompted.
2. Enter the following at the Database Command prompt:
   • ALTER USER voyence WITH password 'new password';
   • ALTER USER archive WITH password 'new password';
   • ALTER USER pgdba WITH password 'new password';


3. Now log out of the Database and run $VOYENCE_HOME/tool/password-change.pl script from NCM AS server to change database password. The password should successfully change.