IPDB: Step 4: Reset nwipdbadptr postgreSQL User Password

Document created by RSA Information Design and Development on Jul 28, 2016
Version 1Show 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';
    service postgresql restart
  1. Replace the password under IPDB Database Configuration on the General Tab of the Reporting Engine with the password that you reset in step 2.

Note: You use this password when you add a data source to a Reporting Engine.

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