RSA Identity Governance & Lifecycle 7.1.1, 7.2.x, 7.5.x, 8.0

RSA Identity Governance & Lifecycle 7.0.x and 7.1.0
 

RSA Identity Governance & Lifecycle 6.9.1

1. The default URL for the PostgreSQL database connection contains an extra instance of the string jdbc:, as in the example below:

jdbc:jdbc:postgresql://<host>:<port>/db

2. There is no PostgreSQL JDBC driver on the application server or the existing PostgreSQL JDBC driver on the server is incompatible with your current version of RSA Identity Governance & Lifecycle.

1. URL: Remove the extra jdbc: string in the URL.
2. DRIVER: Download an appropriate PostgreSQL JDBC driver and add it to the RSA Identity Governance & Lifecycle server.

RSA Governance & Lifecycle 7.5.x, 8.0

URL:

The extra jdbc: string in the database connection URL has been removed starting in RSA Identity Governance & Lifecycle 7.1.1 and therefore does not need to be removed in this version.

DRIVER:

1. Access the PostgreSQL website  to download the latest PostgreSQL JDBC42 driver that is compatible with SecurID Governance & Lifecycle JDK 1.8 (i.e postgresql-9.4.1212..jar)
2. Click the Upload button on the "External Jars" page from the Collectors > External Jars menu and upload the Jar file you obtained in step 1.  Note that an ACM restart is not required after uploading the jar.
3. Try testing the collector again. You should get a Connection Successful message.       

RSA Identity Governance & Lifecycle 7.1.1, 7.2.x

URL:

The extra jdbc: string in the database connection URL has been removed starting in RSA Identity Governance & Lifecycle 7.1.1 and therefore does not need to be removed in this version.

DRIVER:

1. Access the PostgreSQL website  to download the latest PostgreSQL JDBC42 driver that is compatible with RSA Identity Governance & Lifecycle JDK 1.8 (i.e postgresql-9.4.1212..jar)
2. Add the PostgresSQL driver to the RSA Identity Governance & Lifecycle libraries inside the aveksa.ear file.

1. Login as the oracle user.
2. Make sure that RSA Identity Governance & Lifecycle  is running.

acm status

3. Go to the $AVEKSA_HOME/deploy directory

cd $AVEKSA_HOME/deploy

4. Run the customizeACM.sh script to extract the .ear file, specifying the location of the .ear file that you want to modify. Enter

customizeACM.sh -c $AVEKSA_HOME/archive/{ear file to modify}

The contents of the .ear are extracted to a directory called /tmp/customizeACM/.

5. Copy the downloaded driver postgresql-9.4.1212.jar (in Step 1) to the /tmp/customizeACM/aveksa.ear/aveksa.war/WEB-INF/LocalAgent/common/lib/ directory.

cp <location of postgresql-9.4.1212.jar> /tmp/customizeACM/aveksa.ear/aveksa.war/WEB-INF/LocalAgent/common/lib/

6. Make sure the file ownership is set to oracle:oinstall and the file permissions are set to rw- for both owner and group owner.

cd /tmp/customizeACM/aveksa.ear/aveksa.war/WEB-INF/LocalAgent/common/lib/
chown oracle:oinstall postgresql-9.4.1212.jar
chmod 660 postgresql-9.4.1212.jar

7. Login as the oracle user and run the customizeACM.sh script again to rebuild the .ear file. 

cd $AVEKSA_HOME/deploy
customizeACM.sh -d

3. Try testing the collector again. You should get a Connection Successful message.       

RSA Identity Governance & Lifecycle 7.0.x and 7.1.0

URL:

Edit the collector Database Connection URL and remove the extra jdbc: value. Change:

FROM:

jdbc:jdbc:postgresql://<host>:<port>/<database>

TO:

jdbc:postgresql://<host>:<port>/<database>

DRIVER:

1. Access the PostgreSQL website  and download the PostgreSQL JDBC41 driver that is compatible with RSA Identity Governance & Lifecycle  7.0.x  JDK 1.7  (i.e postgresql-9.4.1212.jre7.jar)
2. Follow the DRIVER steps under RSA Identity Governance & Lifecycle 7.1.1 above replacing postgresql-9.4.1212.jar with postgresql-9.4.1212.jre7.jar.

RSA Identity Governance & Lifecycle 6.9.1

URL:

Follow the URL steps under RSA Identity Governance & Lifecycle 7.0.x and 7.1.0 above.

DRIVER:

1. Access the PostgreSQL website  to download the PostgreSQL JDBC4 driver that is compatible with RSA Identity Governance & Lifecycle JDK 1.6 (i.e postgresql-9.4-1205.jdbc4.jar)
2. Login as the oracle user.
3. Copy the downloaded postgresql-9.4.1205.jdbc4.jar to $AVEKSA_HOME/jboss/server/default/deploy/aveksa.ear/aveksa.war/WEB-INF/LocalAgent/common/lib/.

cp <location of postgresql-9.4-1205.jdbc4.jar $AVEKSA_HOME/jboss/server/default/deploy/aveksa.ear/aveksa.war/WEB-INF/LocalAgent/common/lib/

4. Make sure the file ownership is set to oracle:oinstall and the file permissions to rw- for both owner and group.

cd $AVEKSA_HOME/jboss-4.2.2.GA/server/default/deploy/aveksa.ear/aveksa.war/WEB-INF/LocalAgent/common/lib/
chown oracle:oinstall postgresql-9.4-1205.jdbc4.jar
chmod 660 postgresql-9.4-1205.jdbc4.jar

5. Restart RSA Identity Governance & Lifecycle.

acm restart