To Change the Password for the Database

1. Restart Java DB.

   See Starting, Stopping, and Disabling the Java DB in Sun Java System Portal Server 7.1 Configuration Guide for more information.

2. Change the password for the default user, portal, by connecting to the communitymc_portal-ID database.

   For example, if you are using a GUI like SQuirrel-j, use the SQL editor to execute the following command after connecting to the database.

   CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.portal', 'your-new-password');

3. Restart Java DB.

   See Starting, Stopping, and Disabling the Java DB in Sun Java System Portal Server 7.1 Configuration Guide for more information.

4. Verify that the password was set correctly by connecting to the communitymc_portal-ID database with the new password.

5. For each portal instance:

   1. Refer to the web container's documentation and change the password for the jdbc/communitymc datasource to the new password that was set in step 2.

   2. Open the PortalServer-DataDir/portals/portal-ID/config/portal.dbadmin file and change the password value for the property community.db.password to the new password that you set in step 2.

   3. Change the permission for the PortalServer-DataDir/portals/portal-ID/config/portal.dbadmin file so that it is readable and writable only by the owner.

      For example, type chmod 600 portal.dbadmin.

   4. Restart the web container.