Unable to login in the NFA console. Need to check users and password reset for admin account

Products

• Network Flow Analysis

Issue/Introduction

People cannot login to the NFA console using the admin user.
Since NFA is not integrated in NetOps Portal, there is no option to reset the password.
 

Environment

NFA 

Resolution

Reset the admin password to admin using the sql cmd:

1. open a dos box on the console server
   
   
2. Run;
   
   

   mysqldump reporter user_definitions > user.sql
   mysql reporter
   

    

3. At the MySQL prompt, run;
   
   update user_definitions set Password="edbd881f1ee2f76ba0bd70fd184f87711be991a0401fd07ccd4b199665f00761afc91731d8d8ba6cbb188b2ed5bfb465b9f3d30231eb0430b9f90fe91d136648" where Name="admin";
   quit
   
   

4. Then try to login using admin/admin