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

Products

• VMware Smart Assurance
• Network Observability

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/24.3.x

Cause

AS and DB server have different password for Database i.e both server do not have same DB password. 

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.

Additional Information

Local DB login not working