update_pc_da_database_references.sh fails with ERROR 1045 (28000)

Products

• DX NetOps
• CA Performance Management - Usage and Administration

Issue/Introduction

 Had an IP change last week on portal. Ran 

/PerformanceCenter/Tools/bin/update_pc_da_database_references.sh

Had errors when running it.

 

[root@hostname bin]# ./update_pc_da_database_references.sh
Updating Performance Center record in data_sources2 to reflect new PC IP Address...
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'netqos'@'localhost' (using password: YES)

Environment

DX NetOps Portal :: All Supported Versions

Cause

You need to verify that the password in this script is the correct mysql password for your environment.

 

###################################################################

# UPDATE THE FOLLOWING MYSQL VARIABLES TO REFLECT MYSQL CREDENTIALS

###################################################################

MYSQL_USER="netqos"

MYSQL_PASSWORD="netqos"

Resolution

Edit the script and update the password to match your environment.

Additional Information

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/performance-management/23-3/migrating/migrate-performance-center.html#concept.dita_cbbd8728ac8c55af1ef7761bac55eaa88dce2d77_ConfiguretheNewSystem