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
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;