Change database passwords that are used by WebSphere Portal
If database passwords are modified or have expired, specify the new passwords on the IBM WebSphere Application Server and on the IBM DB2 Universal Databaseā¢ Enterprise Server Edition server so that IBM WebSphere Portal can access them.
Follow these steps to update database passwords in the WAS administrative console and on the DB2server.
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.
- If the Virtual Member Manager (VMM) is using the database, see the WAS product documentation for instructions on updating the VMM database password.
Repeat for each JDBC Provider, data source, and alias that is affected.
- Check if the database user has become disabled due to invalid login attempts. Re-enable the database user if necessary.
- Update the data sources for WebSphere Portal:
- Log in to the WAS administrative console.
- Click Security -> Global security -> Java Authentication and Authorization Service -> J2C Authentication Data.
- Select the alias that you want to change; for example:
wpsDBAuth
jcrDBAuth
fbkDBAuth
lmDBAuth
wcmDBAuth
- Update the password accordingly.
- Click Apply, and then click Save to save the configuration. You are informed that security.xml has been changed.
- If you are an administrator and need to change the DB2 password, you need to change the database administrator user password on the system.
- Stop the DB2 server.
- Use the passwd command to change the password.
- Restart the DB2 server.
You can verify the new password by running the db2 CONNECT TO WPSDB user db2admin using password task.
- Restart the WAS administrative server.
- On the DB2 server...
- Click Administrative Tools -> Services.
- Stop all running DB2 services.
- For each service that DB2 instance uses, display the menu and select Properties.
- 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.
Results:
WAS and WebSphere Portal have been updated to use new database passwords. Verify that the WebSphere Portal application server is running by opening the following URL in a browser: http://hostname.example.com:10039/wps/portal, where hostname.example.com is the fully qualified host name of the machine where WebSphere Portal is running and 10039 is the default transport port that is created by WAS; the port number may be different for environment..
Parent
Update user ID and passwords