ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Error executing Flow Forensics report on host

book

Article ID: 112323

calendar_today

Updated On:

Products

CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

After NFA upgrade the FF stop to work and send the messages:
Error executing Flow Forensics report on host

ReportService::Report Service:
NetQoS.ReporterAnalyzer.i18n.i18nException: Error executing Flow Forensics report on host 10.1.9.70.

Authentication to host '10.1.9.70' for user 'archive' using method 'mysql_native_password' failed with message: Access denied for user 'archive'@'%' to database 'nsas'
MySql.Data.MySqlClient.MySqlException (0x80004005): Authentication to host '10.1.9.70' for user 'archive' using method 'mysql_native_password' failed with message: Access denied for user 'archive'@'%' to database 'nsas' ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Access denied for user 'archive'@'%' to database 'nsas'
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
 

Cause

Upgrade lost the user 'archive' permission on 'nsas' database

Environment

9.3

Resolution

1) logon on Harvester machine

2) Stop all NFA Services

3) Have access to the "nsas" database in MySQL, run the following commands on the harvester Command Prompt:
mysql -u root mysql -P3307
grant all on nsas.* to 'archive'@'%';
exit;

4) Start all NFA Services