Steps to add password to postgres database in NFA12 & NCM12

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 USER Postgres WITH PASSWORD 'mike';
     (Replace your password with mike)


3)Shut down OpManager service


4)Edit the file databaseparams.conf  using wordpad and make the following changes :

From


# login password for the database if any
# password postgres AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB

to

# login password for the database if any
password mike AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB

(Remove the comment before the password and change the password from postgres to mike)


5)Edit the file "pg_hba" under Opmanager\pgsql\data using wordpad and modify the following, save the file

From

# IPv4 local connections:
host    all             all             127.0.0.1/32            trust


# IPv6 local connections:
#host    all             all             ::1/128                trust

to

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5


# IPv6 local connections:
#host    all             all             ::1/128                 md5

( replace from trust to md5 )


6)Restart OpManager service , now you should be able to use password while connecting to OpManagerDB.


Applicable for OpManager version 11xxx installed on Windows box.


                New to ADManager Plus?

                  New to ADSelfService Plus?

                    • Related Articles

                    • 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 ...
                    • 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 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    :   ...
                    • Postgres database corruption

                      Please follow the steps, the there is database corruption with the below error message due to low disk space in the drive: org.postgresql.util.PSQLException: ERROR: could not read block 0 in file "base/16384/116045": ...
                    • NCM/NFA 12100 Consolidated Fix

                      Note: This is applicable only for NCM/NFA/FWA Build 12100. Make sure to take the backup of the installation before applying the patch. Patch: 1. Stop NCM(OpManager) Service. 2. Download the patch file from the link here 3. Copy and extract (using ...