Post Upgrade MySql errors in DX NetOps Portal

Products

• Network Observability
• CA Performance Management

Issue/Introduction

Post upgrade, when running dbmigrate, the following errors are generated:

-bash-4.4$ /apps/CA/PerformanceCenter/Tools/bin/npcshell.sh dbmigrate -package com.ca.im.plugin.da -path /apps/CA/PerformanceCenter/SQL/plugins/polaris -host localhost -port 3306 -dbpass 'PASSWORD'
*******
/apps/CA/PerformanceCenter/Tools/bin/../..
/apps/CA/PerformanceCenter/Tools/bin/../../../jre
/apps/CA/PerformanceCenter/Tools/bin/../../SQL
/apps/CA/PerformanceCenter/Tools/bin/../lib
*******
>>> Reading database URL from portal.console.properties...
>>> URL = jdbc:mysql://localhost:3306/netqosportal?characterEncoding=UTF-8&useSSL=true&verifyServerCertificate=false
URL ------------------- jdbc:mysql://localhost:3306/netqosportal?characterEncoding=UTF-8&useSSL=true&verifyServerCertificate=false
Checking dashboards, create snapshot of what dashboards exist...
Sep 18, 2025 11:41:50 AM com.ca.im.installanywhere.util.DbMigrateApp parseArgs
INFO: DbMigrateApp Arguments
------------------------
Sep 18, 2025 11:41:50 AM com.ca.im.installanywhere.util.DbMigrateApp parseArgs
INFO: xmlMigrateFile: /apps/CA/PerformanceCenter/Tools/bin/../../SQL/_create_snapshot_dashboards.xml
Sep 18, 2025 11:41:50 AM com.ca.im.installanywhere.util.DbMigrateApp parseArgs
INFO: dbuser: netqos
Sep 18, 2025 11:41:50 AM com.ca.im.installanywhere.util.DbMigrateApp parseArgs
INFO: connection: jdbc:mysql://localhost:3306/netqosportal?characterEncoding=UTF-8&useSSL=true&verifyServerCertificate=false
Sep 18, 2025 11:41:51 AM com.ca.im.installanywhere.util.DbMigrateApp main
SEVERE: com.ca.im.installanywhere.util.DbMigrateException: Unable to open database connection: (jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=UTF-8&useSSL=true&verifyServerCertificate=false for netqos)
        at com.ca.im.installanywhere.util.DbMigrateApp.setupConnection(DbMigrateApp.java:460)
        at com.ca.im.installanywhere.util.DbMigrateApp.runDBMigrate(DbMigrateApp.java:383)
        at com.ca.im.installanywhere.util.DbMigrateApp.runMigrateMode(DbMigrateApp.java:317)
        at com.ca.im.installanywhere.util.DbMigrateApp.run(DbMigrateApp.java:184)
        at com.ca.im.installanywhere.util.DbMigrateApp.main(DbMigrateApp.java:50)
Caused by: java.sql.SQLException: Access denied for user 'netqos'@'localhost' (using password: YES)
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114)
        at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:833)
        at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:416)
        at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:238)
        at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:180)
        at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
        at com.ca.im.installanywhere.util.DbMigrateApp.setupConnection(DbMigrateApp.java:456)
        ... 4 more

 

Sep 18, 2025 11:41:51 AM com.ca.im.installanywhere.util.DbMigrateApp main
INFO:
DbMigrate end (w/ exit status: 1)

Environment

DX NetOps CA Performance Management (CAPM) all currently supported releases

Cause

The issue is caused by invalid user or permissions when running the post-upgrade script, as shown:

Caused by: java.sql.SQLException: Access denied for user 'netqos'@'localhost' (using password: YES)

Resolution

Check the user account you're running the following under:

-bash-4.4$ /apps/CA/PerformanceCenter/Tools/bin/npcshell.sh dbmigrate -package com.ca.im.plugin.da -path /apps/CA/PerformanceCenter/SQL/plugins/polaris -host localhost -port 3306 -dbpass 'PASSWORD'

You should be able to login to Mysql directly under the same user account. For example, you would first login to the install OS user account. So if it is root, then login to the MySQL netqosportal DB under the root OS user account but using netqos as the DB user:

[root@portal /]# cd /opt/CA/MySql/bin

[root@portal /opt/CA/MySql/bin]# ./mysql -unetqos -pMyPassword netqosportal