Portal, Express Beta Version 6.1 Operating systems: i5/OS, Linux,Windows

Updating the database user registry on Windows

After creating and using the database user registry in the default federated repository, you may find that your database user registry is not working exactly as you would like. You can easily update the database user registry and make the necessary changes.

1. Use a text editor to open the wkplc.properties file, located in the wp_profile\ConfigEngine\properties directory.
2. Enter the following parameters in the wkplc.properties file to connect remotely to the database and to the WebSphere Application Server:

   1. For ConnectionType, type remote to access the WebSphere Application Server Administrative Console remotely.
   2. For WasSoapPort, type the port number to use to access the WebSphere Application Server Administrative Console remotely.
   3. For WasUserId and WasPassword, type the WebSphere Application Server administrative user ID and password used to access the WebSphere Application Server Administrative Console remotely.
   4. Restart the server accepting SOAP requests at the port provided in the WasSoapPort parameter; by default it is the WebSphere_Portal server.
3. Update the following required parameters in the wkplc.properties file under the Federated DB repository heading:

   1. For federated.db.datasourcename, type the name of the data source. CAUTION:The federated.db.datasourcename value must be different than the value for the DataSourceName parameter in the wkplc_comp.properties file.
   2. For federated.db.databaseType, type the database type.
   3. For federated.db.dbURL, type the database URL.
   4. For federated.db.id, type the unique ID for the federated repository.
4. Update the following optional parameters in the wkplc.properties file under the Federated DB repository heading:

   1. For federated.db.dbAdminId, type the database administrator ID.
   2. For federated.db.dbAdminPassword, type the password for the database administrator ID.
   3. For federated.db.adapterClassName, type the adapter class name.
   4. For federated.db.JDBCDriverClass, type the JDBC drive class name.
   5. For federated.db.supportSorting, type true to support sorting or false to not support sorting.
   6. For federated.db.supportTransaction, type true to support transactions or false to not support transactions.
   7. For federated.db.isExtIdUnique, type true if the external ID is unique or false if the external ID is not unique.
   8. For federated.db.supportExternalName, type true if the external names are supported or false if external names are not supported.
   9. For federated.db.entityRetrievalLimit, type a numeric value to specify the retrieval limit on database entries.
   10. For federated.db.saltLength, type a numeric value for the salt length in bits; the default value is 12.
   11. For federated.db.encryptionKey, type the encryption key; the default value is rZ15ws0ely9yHk3zCs3sTMv/ho8fY17s.
5. Run the ConfigEngine.bat wp-update-db task, located in the wp_profile\ConfigEngine directory to add a database user registry to the default federated repository.
6. Save your changes to the wkplc.properties file.
7. Perform the following steps to stop and restart the server1 and WebSphere_Portal servers:

   1. Open a command prompt and change to the wp_profile_root\bin directory.
   2. Enter the stopServer.bat server1 -user admin_userid -password admin_password command to stop the WebSphere Application Server.
   3. Enter the stopServer.bat WebSphere_Portal -user admin_userid -password admin_password command to stop the WebSphere Portal Express server.
   4. Enter the startServer.bat server1 command.
   5. Enter the startServer.bat WebSphere_Portal command.