Updating the database user registry | HCL Digital Experience

After you create and use the database user registry, you can update the database user ID, password, and where the data is stored. This task does not change the DN structure that is stored in the database repository.

Before you begin

If you plan to change the database where data is stored, populate the new database with all necessary VMM tables and create the data sources in WebSphere® Application Server. Then, run this task. Read the following information for information about setting up a VMM database. After you populate the new database, restart the WebSphere_Portal server.

If you change the database administrator password, complete the steps in Changing database passwords that are used by HCL Portal before you run this task.

About this task

Note: Use the wp_add_DB.properties helper file in the wp_profile_root/ConfigEngine/config/helpers directory to ensure that the correct properties are entered. In the following instructions, where the step refers to the wkplc.properties file, use your wp_add_DB.properties helper file.

Procedure

  1. Prepare your servers.
    • In a stand-alone server environment, you can complete the following task when the servers are either stopped or started.
    • In a clustered environment, start the deployment manager and node agent. Then, verify that they are able to synchronize.
  2. Go to the wp_profile_root/ConfigEngine/properties directory.
  3. Open the wkplc.properties file with a text editor.
  4. Enter the following parameters in the wkplc.properties file under Federated DB repository heading:
    Note: Go to the properties file for specific information about the parameters.
    • federated.db.DataSourceName
    • federated.db.DbType
    • federated.db.DbUrl
    • federated.db.id
    • federated.db.DbUser
    • federated.db.DbPassword
  5. Save your changes to the wkplc.properties file.
  6. Open a command prompt.
  7. Change to the wp_profile_root/ConfigEngine directory.
  8. Run the following task to delete the required repository:
    • AIX® HP-UX Linux™ Solaris: ./ConfigEngine.sh wp-update-db -DWasPassword=password
    • IBM® i: ConfigEngine.sh wp-update-db -DWasPassword=password
    • Windows™: ConfigEngine.bat wp-update-db -DWasPassword=password
    • z/OS®: ./ConfigEngine.sh wp-update-db -DWasPassword=password
  9. Stop and restart the appropriate servers to propagate the changes. For instructions, go to Starting and stopping servers, deployment managers, and node agents.