Error executing Flow Forensics report on host

Document ID : KB000112323
Last Modified Date : 11/09/2018
Show Technical Document Details
Issue:
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()
 
Environment:
9.3
Cause:
Upgrade lost the user 'archive' permission on 'nsas' database
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