Unable to login in the NFA console

Document ID : KB000071579
Last Modified Date : 21/02/2018
Show Technical Document Details
Introduction:
People cannot login to the NFA console using the admin user .
NFA not integrated in CAPC  ; So , no option to reset the password .
 
Environment:
NFA 9.3.*
win2008 / win2012
Instructions:
reset the admin password to admin using the sql cmd :
open a dos box on the console server
mysqldump reporter user_definitions > user.sql
mysql reporter
update user_definitions set Password="21232f297a57a5a743894a0e4a801fc3" where Name="admin";
quit

Then try to login using admin/admin