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.


          • 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": ...
          • Vectorwise Username and Password Creation over the build 12.5 and above

            Steps to Create a new user in VerctorWise database Steps if the HighPerf Reprting Engine is installed in the same server where the NetFlow Analyzer is installed: 1. Stop the NetFlow Analyzer service. 2. Download and extract the file named ...