NFA 21.2.8 access denied for user

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

Starting in Network Flow Analysis 21.2.8, we no longer ship the MySQL with the anonymous use enabled.

When logging on to NFA now you will see:

Environment

NFA 21.2.8+

Cause

This was done for security reasons.

Resolution

When accessing Network Flow Analysis you need to specify the user and password now.

 

For example you can use the 'netqos' user for situations where you don't need root access:

mysql -unetqos -p <databaseName>

(default password is 'netqos')

 

If you need root access, you can access the databases with the 'root' user:

mysql -uroot -p <databaseName>

(default password is 'root@123')

 

If you want to change the default password you could:
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/network-flow-analysis/21-2/installing/post-installation-or-upgrade-tasks/configure-mysql-user-password.html

Please note that the password for a user should be the same in both the NFA Harvester and the NFA Console servers.

Additional Information

If you have any scripts running, ensure that they utilize the above resolutions up top.

Passwords for scripts could be included inline if you want like this:

mysql -unetqos -pnetqos  <databaseName>......