NFA Password reset for pgsql database till version 11001

NFA Password reset for pgsql database till version 11001

Kindly follow steps as given below to reset the password.

Note : Make sure that NetFlow Analyzer Service is running before following the below steps

1. Open a command prompt

2. Go to the <NETFLOW_HOME>\pgsql\bin directory

3. Type
For Windows    :   psql -U postgres -p 13310 -h 127.0.0.1 -d netflow
For Linux        :   ./psql -U postgres -p 13310 -h 127.0.0.1 -d netflow


4. Execute the following query:

update AaaPassword set PASSWORD='Ok6/FqR5WtJY5UCLrnvjQQ==', SALT='12345678' from AaaLogin,AaaAccount,AaaAccPassword where AaaLogin.LOGIN_ID = AaaAccount.LOGIN_ID and AaaAccount.ACCOUNT_ID = AaaAccPassword.ACCOUNT_ID and AaaPassword.PASSWORD_ID = AaaAccPassword.PASSWORD_ID and AaaLogin.NAME = 'admin';

6. Type quit to quit pssql

7. Type exit to exit command prompt

8. Login as admin / admin. You can change the password again if you wish
          • Related Articles

          • NFA Password Reset steps for Mysql database till version 10250

            Kindly follow steps as given below to reset the password. Please note that the NetFlow Analyzer Server is running before doing the below steps. 1. Open a command prompt 2. Go to the <NETFLOW_HOME>\mysql\bin directory 3. Type For Windows    :   mysql ...
          • NFA and NCM 12 Default Admin password Reset_postgres Database

            Forgot Password: The Forgot Password option in the login page can be used to reset the password. Make sure the Mail Server Settings and User's email ID are configured. The auto generated password will be sent to the email ID entered as the User's ...
          • Admin Password Reset for NetFlow Analzer with database MSSQL till build 11001

            1. Open the Management Studio on the MSSQL server 2. Select the netFlow database. Right click on netflow database and click on New Query 3. Execute the following query update AaaPassword set PASSWORD='Ok6/FqR5WtJY5UCLrnvjQQ==', SALT='12345678' from ...
          • Total database consumption of space by NFA

            Note: This feature works in 123288 and above releases only and is applicable for both PGSQL and MSSQL.  NetFlow Analyzer stores two kinds of data(i.e RAW data and Aggregated data), we can separately get the total amount of table space taken by NFA by ...
          • Steps to add password to postgres database in NFA12 & NCM12

            1) Start OpManager service 2)Connect  to OpManager database :   a)Go to OpManager\pgsql\bin folder   b)Type psql -U postgres -h 127.0.0.1 -p13306  OpManagerDB   c)Once connected to the Database, execute the below query to set password          ALTER ...