IBM Support

How to change the database password on WebSphere Lombardi Edition (WLE) 7.1 Simple Install

Technote (FAQ)


Question

How do you change the database password on WebSphere Lombardi Edition (WLE) 7.1 Simple Install?

Answer

Below are the steps to change the password on a WLE Simple Install. It's worthwhile to note this is available only on Windows systems and comes pre-installed with DB2.

  • Shut down WLE. You can do this from the

      Start->All Programs->WebSphere Lombardi Edition 7->Stop Servers
  • Change the password for Windows user WSLE to the new password.
  • Encrypt the new_passwordand write this down. Use the "Encrypting passwords" section in the Process Center Installation and Configuration Guide for Windows (PDF) to do this.
  • Change the password in

      C:\IBM\Lombardi7\internal-provider\98Database.xml

    to the new encrypted password.

      <encrypted-password> new_password</encrypted-password>
  • Change the password in

      C:\IBM\Lombardi7\internal-provider\securitydb.jocl

      <string value="new_password"/>

  • Change the password in

      C:\IBM\Lombardi7\process-center\config\system\98Database.xml

      <encrypted-new_password</encrypted-password>

  • Change the password for the following services in the Windows services panel (in the "Log On" tab)
    • DB2 - DBCOPY1 - DB2
    • DB2 Governor
    • DB2 Remote Command Server (DB2COPY1)
    • DB2DAS - DB2DAS00
  • Start the WLE from servers

      Start->All Programs->WebSphere Lombardi Edition 7->Start Servers
  • Run the command

      $WAS_HOME/bin/wsadmin.bat -conntype NON wasadmin> securityoff
  • Restart the WLE servers.
  • Log on tohttps://server_name:port_number/ibm/console/login.do



    you should only be promoted for the username tw_user

  • Using the left hand menu pane, navigate to

    Resources -> JDBC -> Datasources

  • One at a time, go into all 4 Teamworks datasources.
    • Click "Custom Properties" and go to the second page of each (arrow at the bottom of the page) and change the password to the new_password.
    • For each data source click "Apply" and then "Save"
  • Now, go into:

    Security -> Global Security -> Expand Java Authentication and Authorization Service (JAAS) -> J2C authentication data

    Change the password for

    • LombardiCell01/performancedblogon
    • LombardiCell01/processdblogon
  • Under Security->Global Security tick Enable administrative security if it is not already checked.
  • Restart the WLE Servers
  • Test - log back on to was admin console (you should now be prompted for username and password) and try connectivity on all Lombardi datasources (navigated to resources/jdbc/datasources).
  • Test - Logon to Lombardi Process portal

Product Alias/Synonym

WLE Lombardi Teamworks

Document information

More support for: WebSphere Lombardi Edition
DB2

Software version: 7.1

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1447788

Modified date: 04 February 2011