Repeat the following instructions for each portal in your environment. Replace the <portal-ID> string with actual portalid (for example, portal1, portal2, and so on).
Restart the Java DB.
Use Java DB CLI or any other equivalent tool to change the password for default user "portal" by connecting to the filesharingdb_portal-ID database. If you are using Squirrel-j, you need to execute the following steps on your sql editor.
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY ('derby.authentication.provider', 'BUILTIN'); CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY ('derby.connection.requireAuthentication', 'true'); CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY ('derby.user.portal', 'your-new-password'); CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY ('derby.database.fullAccessUsers', 'portal'); CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY ('derby.database.defaultConnectionMode', 'noAccess'); |
Restart Java DB.
Use Java DB command line or any other equivalent tool to connect to the filesharingdb_portal-ID database with new password to verify that the password was set correctly.
For each portal instance do the following.
Refer to Web container's administrator guide and change the password for the jdbc/FileSharingDB datasource to the new password that was set in step 2.
Open PortalServer-DataDir/portals/portal-ID/portletapps/filesharing/tokens.properties file and change the password value for the property DB_ADMIN_PASSWORD and DB_PASSWORD to the new password that you set using the Java DB CLI or any other equivalent tool in step 2.
Change permission of the PortalServer-DataDir/portals/portal-ID/portletapps/filesharing/tokens.properties file so that it is readable and writable only by the owner (for example, chmod 600 tokens.properties).
Restart the web container.