000032018 - No suitable driver found when testing a PostgreSQL database collector in RSA Identity Governance & Lifecycle

RSA Identity Governance & Lifecycle 7.1.1

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 to the RSA Identity Governance & Lifecycle server with appropriate permissions.

RSA Identity Governance & Lifecycle 7.1.1

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