Wednesday, September 23, 2009

How to Update the Database Administrator Password on Portal 6.0 and 6.1


Question
I have to change the database administrator password. Now how do I update Portal with the new DB password?

Answer
You can update the database administrator passwords for Portal by changing the datasource, as noted in the Portal infocenters:

Portal 6.0 -
http://publib.boulder.ibm.com/infocenter/wpdoc/v6r0/topic/com.ibm.wp.ent.doc/wpf/sec_pswds.html#sec_pswds__dbase

Portal 6.1 -
http://publib.boulder.ibm.com/infocenter/wpdoc/v6r1/topic/com.ibm.wp.ent.doc_v6101/config/db_passwords.html

This works fine as long as you don't run any Portal configuration tasks in the future. If you do run a configuration task that requires the database administrator password, however, the task will use the old value in the properties file instead of the new password, and the task will fail.

The recommended way to change database administrator passwords used by Portal, is to change them in the Portal properties file and run the connect-database task. This updates the datasources while maintaining current properties in the Portal configuration files:

Portal 6.0:

  1. For a cluster, start the deployment manager and node agent if they are not already running.
  2. Stop Portal
  3. Update the properties file with the new password(s) for each domain:
    PortalServer/config/wpconfig_dbtype.properties
  4. Navigate to the following directory:
    PortalServer/config/
  5. Start the connect-database task:
    Windows:
    WPConfig.bat connect-database
    AIX, Solaris, Linux, Unix:
    ./WPConfig.sh connect-database
  6. Start Portal

Portal 6.1:
  1. For a cluster, start the deployment manager and node agent if they are not already running.
  2. Stop Portal
  3. Update the properties file with the new password(s) for each domain:
    /ConfigEngine/properties/wkplc_dbtype.properties
  4. Navigate to the following directory:
    /ConfigEngine/
  5. Start the connect-database task:
    Windows:
    ConfigEngine.bat connect-database
    AIX, Solaris, Linux, Unix:
    ./ConfigEngine.sh connect-database
  6. Start Portal