Configuring Configuration Settings in the P6 Progress Reporter Administrator

Contents

To set your Configuration settings:

1. Open the P6 Progress Reporter Administrator.
2. Select the Configuration tab.

   Notes:

   • You must set all settings in the Database section for P6 Progress Reporter.
   • The first time you log into the server configuration area of the P6 Progress Reporter Administrator, you must enter the database connection settings and successfully connect to the P6 EPPM database before accessing other server configuration tabs. After you connect to the database successfully, you will be prompted to reboot the application server instance.
3. In the Database section:
   1. In the Configuration Home field, enter the location of the P6 Progress Reporter configuration and logging files on the application server.

      For Windows, the configuration home is: \Documents and Settings\machine user name\.oracle\primavera\progressreporter.

      For Linux, the configuration home is: user home directory/.oracle/primavera/ progressreporter

      Note: Modifying the Configuration Home field changes only where the database connection settings are stored when saved. If you change the configuration home, you must configure your application server to point to the new location and then restart the application server instance. See P6 Progress Reporter and WebLogic Configuration Guide or P6 Progress Reporter and WebSphere Configuration Guide for instructions on how to point your application server to the new configuration home location.

   2. In the Config Database URL field, enter the web address used to establish a connection to the P6 EPPM database.

      Oracle format:

      jdbc:oracle:thin:@db_serverIP:db_port:db_sid

      Oracle example:

      jdbc:oracle:thin:@serverIP:1521:pmdb

      Microsoft SQL format:

      dbc:sqlserver://serverIP:db_port;database=db_name

      Microsoft SQL example:

      dbc:sqlserver://serverIP:1433;database=pmdb

   3. In the Public Group ID field, enter the ID used to connect to the P6 EPPM database.

      The default Public Group ID is 1. You must set the Public Group ID to "1" for a standard configuration.

   4. In the Username field, enter the user name for the public P6 EPPM database login.

      The default user name is pubuser.

   5. In the Password field, enter the password for the public P6 EPPM database login.
4. In the PM Database Instance section:
   1. In the P6 Configuration field, select one configuration from the list.

      The PM Database field will populate with the list of database instances configured to the selected configuration.

   2. In the PM Database field, select the database from the list to complete the configuration.
   3. Test the database connection for both the databases using the Test Connection button.
5. In the Application Server section:
   1. Select the Ignore Daylight Savings Time option to disregard the daylight savings time setting on the server. This setting should match the equivalent setting in the P6 Administrator application if you deployed P6 Progress Reporter and P6 in the same domain.
   2. In the LDAP SSL Certificate Store field, enter the location of the SSL certificate on the application server.

      To use this certificate for all P6 Progress Reporter encryption requests, enable SSL in the P6 Administrator application:

      1. Open the P6 Administrator application.
      2. In the Authentication tab, expand your configuration.
      3. Expand Authentication.
      4. In the Login Mode field, choose LDAP.
      5. Expand Authentication/LDAP.
      6. In the SSL Certificate Store field, enter the full path to the keystore that holds the SSL certificate for the LDAP server.
      7. In the SSL Store Password field, enter the password for the keystore that holds the SSL certificate.
      8. Restart the application server instance.
   3. Return to the P6 Progress Reporter Administrator
   4. In the SSL Store Password field, enter the password for the SSL certificate store.
   5. Click Save.

      Note: The values entered must match the corresponding settings for P6 if you deployed both components on the same application server.

Tips

Changes to Configuration tab settings always require you reboot the application server instance.