test

Sun Java System Portal Server 7.1 Update 1 Community Guide

Chapter 11 Configuring Surveys and Polls Portlets

This chapter contains the following:

Configuring Security for Surveys Portlet Datasource

For each service using a relational database, a separate database instance is configured with default userid and password. The default userid is portal and the default password is a random string generated during installation. Change the default password and the access permissions of the properties files containing the password.

ProcedureTo Change the Default Database Password

  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 surveysdb_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.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');

  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 surveysdb_portal-ID database with new password.

  5. For each portal instance:

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

    2. Open the PortalServer-DataDir/portals/portal-ID/portletapps/surveys/tokens.properties file and change the password value for the DB_ADMIN_PASSWORD and DB_PASSWORD properties to the new password that you set in step 2.

    3. Change the permissions for the PortalServer-DataDir/portals/portal-ID/portletapps/surveys/tokens.properties file so that it is readable and writable only by the owner.

      For example, type chmod 600 tokens.properties.

    4. Restart the web container.

Configuring Tokens for Surveys and Polls Portlet

The Surveys and Polls portlets include the following tokens in the PortalServer-base/portletapps/surveys/tokens.properties file:

%DERBY_LIB_DIR%

Specifies the library where Java DB class files derbyclient.jar are located.

%DERBY_HOST%

Specifies the host server that host the Java DB.

%DERBY_PORT%

Specifies the port that the Java DB server host listens to for database requests.

%PORTAL_ID%

Specifies the Portal's ID.