NFA 22.2.6 Migrator Error: Access denied for user

Products

• CA Network Flow Analysis (NetQos / NFA)
• DX NetOps

Issue/Introduction

While upgrading to Network Flow Analysis 22.2.6, you may run into a migrator failure. When trying to run the runMigrator.vbs or runMigrator.sh script again, you may notice this error when checking the <installdir>/CA/NFA/migrator/migrator.log:

2023-02-27 13:15:13.591 FATAL [main] [com.ca.im.migrator.TheSet.play(Unknown Source)] - Error playing back movie
com.ca.im.migrator.exceptions.MigratorException: Movie playback failed.
 at com.ca.im.migrator.business.Projector.play(Unknown Source) ~[migrator.jar:?]
 at com.ca.im.migrator.TheSet.play(Unknown Source) ~[migrator.jar:?]
 at com.ca.im.migrator.TheSet.migrate(Unknown Source) ~[migrator.jar:?]
 at com.ca.im.migrator.MigratorApp.main(Unknown Source) ~[migrator.jar:?]
Caused by: com.ca.im.migrator.exceptions.SqlActionExecutionException: SQL action failed
 at com.ca.im.migrator.business.action.SqlAction.execute(Unknown Source) ~[migrator.jar:?]
 ... 4 more
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)
 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[migrator.jar:?]
 at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[migrator.jar:?]
 at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828) ~[migrator.jar:?]
 at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448) ~[migrator.jar:?]
 at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) ~[migrator.jar:?]
 at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[migrator.jar:?]
 at java.sql.DriverManager.getConnection(Unknown Source) ~[java.sql:?]
 at java.sql.DriverManager.getConnection(Unknown Source) ~[java.sql:?]
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:155) ~[migrator.jar:?]
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:146) ~[migrator.jar:?]
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:205) ~[migrator.jar:?]
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:179) ~[migrator.jar:?]
 at com.ca.im.migrator.data.ConnectionPool.getConnection(Unknown Source) ~[migrator.jar:?]
 at com.ca.im.migrator.data.BaseDao.executeNonQuery(Unknown Source) ~[migrator.jar:?]
 at com.ca.im.migrator.business.action.SqlAction.execute(Unknown Source) ~[migrator.jar:?]
 ... 4 more
2023-02-27 13:15:13.633 INFO [main] [com.ca.im.migrator.business.Library.putMovie(Unknown Source)] - Writing movie file D:\CA\NFA\console_movie.xml
2023-02-27 13:15:13.761 INFO [main] [com.ca.im.migrator.MigratorApp.main(Unknown Source)] - Exiting with code 1

 

Environment

NFA 22.2.6 only.

Cause

With the upgrade to NFA 22.2.6 comes the upgrade from MySQL 5.7 to MySQL 8.0. MySQL 8.0 came a change that needed to be made in the migrator.jar file which the .vbs or .sh script references. This change was not found until after NFA 22.2.6 was shipped.

Resolution

This fix is only needed if you need to re-run the runMigrator.vbs or runMigrator.sh script to complete an upgrade to NFA 22.2.6. This will be resolved in NFA 22.2.7+.

1. Download the attached file: NFA_22.2.6_PTF_002.zip and copy it to the NFA server in need.
2. Extract the contents and read the readme.txt included.
3. To patch the migrator, it is as simply as replacing the <installdir>/CA/NFA/migrator/migrator.jar with the newly patched version.
4. Once the file is replace, you can proceed to run the runMigrator.vbs or runMigrator.sh scripts as you normally would.