Change database passwords that are used by WebSphere Portal

 

+
Search Tips   |   Advanced Search

 

If database passwords are modified or expired, the new passwords must be updated in WAS so that WebSphere Portal can access them. Follow these steps to update the database passwords using the WAS Administrative console.

The WAS administrive server must be running for these tasks.

  1. Update version 5 data sources.

    1. Go to...

      WAS_administrative_console | Security | JAAS Configurations | J2C Authentication Data
    2. Select the alias that you want to change. Some examples are listed here.

      • fbkDBAuth
      • wmmDBAuth
      • wpsDBAuth

    3. Update the password accordingly.
    4. Click Apply, and click Save to save the configuration. You are informed that security.xml has been changed.

  2. Update Version 4 data sources (required for version 5).

    1. Click Resources, then JDBC Providers.
    2. Select the wpcp50JDBC resource.
    3. Under Additional Properties select Data Sources (version 4.0).
    4. Select the data source that you want to change. Some examples are listed here:

      • feedbackDS

      • persDS

      • wcmDS

    5. Update the password accordingly.
    6. Click Apply, and click Save to save the configuration. You are informed that security.xml has been changed.

  3. Update the file WCM.properties with the updated password.

    • Locate the file in the following directory:
      /QIBM/UserData/WebAS5/Base/<instance>/wpcp/config/<instance>/author/WCM.properties

    • Locate the wcm.database.password property, and update the password.

  4. Update the wpconfig.properties file to reflect the changed values.

  5. Check if the database user has become disabled due to invalid login attempts. Re-enable the database user if necessary.

  6. Restart WAS administrative server.

Repeat for each JDBC Provider, data source, and alias that is affected.

Be sure to update wpconfig.properties with the correct settings for all database users and passwords, as these may be used in the future during updates.

Results

WAS and WebSphere Portal have been updated to use the new database passwords. Verify that the WebSphere Portal application server is running by opening the following URL in a browser: http://<hostname.yourco.com>:<port_number>/wps/portal, where <hostname.yourco.com> is the fully qualified host name of the machine where WebSphere Portal is running and <port_number> is the transport port that is created by WAS.

 

Related information