IPDB: Step 4. Reset nwipdbadptr postgreSQL User Password

Document created by RSA Information Design and Development on May 3, 2016Last modified by RSA Information Design and Development on Sep 1, 2016
Version 3Show Document
  • View in full screen mode
 

This topic describes the steps to reset the password for nwipdbadptr postgreSQL user (Component of the IPDB Extractor service). The IPDB Adaptor is a component of the IPDB Extractor service. nwipdbadptr is the postgreSQL database user that the IPDB Adaptor needs to get event meta data for the Reporting module.

There are two tasks that you must complete to configure the IPDB Adaptor:

  • Reset the default password for the nwipdbadptr user.
  • Add the IPDB Adaptor to the Reporting Engine.

To reset a password for the nwipdbadptr user:

  1. Log on to the Reporting Engine Appliance with super user credentials.
  2. Execute the following commands.

    su – postgres
    psql -d nwtmpdb
    ALTER ROLE nwipdbadptr  WITH PASSWORD  'password';
     \q
    Exit
    service postgresql restart

  3. Replace the password under IPDB Database Configuration on the General Tab of the Reporting Engine topic in the Reporting Engine Configuration Guide with the password that you reset in step 2.


Note: You use this password when you add a data source to a Reporting Engine topic in the Reporting Engine Configuration Guide

You are here: Configure the IPDB Extractor Service > Step 4. Reset nwipdbadptr postgreSQL User Password

Attachments

    Outcomes