Change database passwords that are used by WebSphere Portal

If database passwords are modified or have expired, specify the new passwords on the IBM WAS and on the IBM DB2 Universal Database™ Enterprise Server Edition server so that WebSphere Portal can access them.

Follow these steps to update your database passwords in the administrative console and on the DB2 server.

Before you begin

• WAS server must be running.

• If this is a clustered environment, have the Deployment Manager and the nodes up and the WebSphere Portal server stopped.

Steps for this task

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

2. Update the data sources for WebSphere Portal:

   1. Log in to the administrative console.

   2. Depending on your version of WAS, click the appropriate option:

      • For WAS v6.1:

        Click Security > Secure administration, applications, and infrastructure > Java Authentication and Authorization Service > J2C Authentication Data

      • For WAS v7:

        Click Security > Global security > Java Authentication and Authorization Service > J2C Authentication Data.

   3. Select the alias that you want to change; for example:

      • wpsDBAuth

      • jcrDBAuth

      • fbkDBAuth

      • lmDBAuth

      • wcmDBAuth

   4. Update the password accordingly.

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

3. If you are an administrator and need to change the DB2 password, change the database administrator user password on the system.

   1. Stop the DB2 server.

   2. Use the passwd command to change the password.

   3. Restart the DB2 server. You can verify the new password by running the db2 CONNECT TO WPSDB user db2admin using password task.

4. Restart WAS administrative server.

5. On the DB2 server, complete the following steps:

   1. Click Administrative Tools > Services.

   2. Stop all running DB2 services.

   3. For each service that your DB2 instance uses, display the context menu and select Properties.

   4. Select the Log On tab and change the DB2 administrator's user name and password.

   If you do not change the DB2 administrator's user name and password in the properties of each DB2 service, the DB2 database application will not start.

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

Results

WAS and WebSphere Portal have been updated to use your new database passwords. Verify that the WebSphere Portal appserver is running by opening the following URL in a browser: http://hostname.example.com:10040/wps/portal, where hostname.example.com is the fully qualified host name of the machine where WebSphere Portal is running and 10040 is the default transport port that is created by WAS; the port number may be different for your environment..

Parent topic:

Administer WebSphere Portal

---