Administer > Security Configuration > Providing a Password for Embedded Database Tools

Providing a Password for Embedded Database Tools

To run embedded database tools (such as psql), NNMi requires a password. NNMi provides a default password, which the user should change using the nnmchangeembdbpw.ovpl script.

Note You must be logged in as administrator on Windows systems or root on Linux systems to run the nnmchangeembdbpw.ovpl script. For more information, see the nnmchangeembdbpw.ovpl reference page, or the Linux manpage

If you have configured NNMi in an High Availability (HA) environment, run the nnmchangeembdbpw.ovpl script on the Primary Cluster Node only.

On the Primary Cluster Node only:

  1. Place the Primary Cluster Node into maintenance mode.

    See Maintenance Mode for more information about placing nodes in maintenance mode.

  2. Stop all NNMi processes:

    Windows: %NNM_BIN%\ovstop -c

    Linux: $NNM_BIN/ovstop -c

  3. Restart nnmsdbmgr:

    Windows: %NNM_BIN%\ovstart nnmsdbmgr

    Linux: $NNM_BIN/ovstart nnmsdbmgr

  4. To change the embedded database password, run the nnmchangeembdbpw.ovpl script.

    Windows: %NNM_BIN%\nnmchangeembdbpw.ovpl

    Linux: $NNM_BIN/nnmchangeembdbpw.ovpl

  5. To ensure the change is copied to the replication directory, so it can be copied to the Secondary Cluster Note, run the nnmdatareplication.ovpl script:

    Windows: %NNM_DATA%\misc\nnm\ha\nnmdatareplication.ovpl NNM

    Linux: $NNM_DATA/misc/nnm/ha/nnmdatareplication.ovpl NNM

  6. Restart all NNMi processes:

    Windows: %NNM_BIN%\ovstart

    Linux: $NNM_BIN/ovstart

  7. Take the Primary Cluster Node out of Maintenance Mode.

  8. Fail over to the Secondary Cluster Node.

    Note The Secondary Cluster Node must NOT be in Maintenance Mode in order to have the Postgres password replicated.

The application automatically copies the password to the Secondary Cluster Node when the NNMi Resource Group is started on this node.

Send Help Center feedback