installer on new versions of oracle might need an updated driver or driver class

From: grouper-users-request On Behalf Of Imholz, John J.
Sent: Wednesday, August 26, 2015 7:51 AM
To: grouper-users
Subject: RE: [grouper-users] Red Hat Linux installation conundrum for oracle.jdbc.driver.OracleDriver

Are there any other suggestions to fix this problem?

I’m installing on Ubuntu and get the same error even after putting ojdbc7.jar in the /usr/local/grouper/grouper.apiBinary-2.2.1/lib/custom dir.

Enter the database URL [jdbc:oracle:thin:@grouper-oracle-v-mdc.musc.edu:1521:grpr]:
Database user [grouper_v1_5]:
Database password (note, you aren't setting the pass here, you are using an existing pass, this will be echoed back) [******]:
Editing /usr/local/grouper/grouper.apiBinary-2.2.1/conf/grouper.hibernate.properties:

• property hibernate.connection.url already was set to: jdbc:oracle:thin:@grouper-oracle-v-mdc.musc.edu:1521:grpr, not changing file
• property hibernate.connection.username already was set to: grouper_v1_5, not changing file
• property hibernate.connection.password already was set to: *****, not changing file
  Checking database with query: select 1 from dual
  Error: could not connect to the database:
  java.lang.RuntimeException: Error with query: select 1 from dual
  at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.listSelect(GiDbUtils.java:400)
  at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.listSelect(GiDbUtils.java:323)
  at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.select(GiDbUtils.java:334)
  at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.checkConnection(GiDbUtils.java:474)
  at edu.internet2.middleware.grouperInstaller.GrouperInstaller.checkDatabaseConnection(GrouperInstaller.java:7292)
  at edu.internet2.middleware.grouperInstaller.GrouperInstaller.mainInstallLogic(GrouperInstaller.java:5721)
  at edu.internet2.middleware.grouperInstaller.GrouperInstaller.access$300(GrouperInstaller.java:77)
  at edu.internet2.middleware.grouperInstaller.GrouperInstaller$GrouperInstallerMainFunction$1.logic(GrouperInstaller.java:969)
  at edu.internet2.middleware.grouperInstaller.GrouperInstaller.mainLogic(GrouperInstaller.java:1031)
  at edu.internet2.middleware.grouperInstaller.GrouperInstaller.main(GrouperInstaller.java:302)
  Caused by: java.lang.RuntimeException: Error connecting to: null
  at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.connection(GiDbUtils.java:310)
  at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.listSelect(GiDbUtils.java:364)
  ... 9 more
  Caused by: java.lang.RuntimeException: Problem loading class: oracle.jdbc.driver.OracleDriver
  at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.forName(GrouperInstallerUtils.java:712)
  at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.connection(GiDbUtils.java:304)
  ... 10 more
  Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
  at java.net.URLClassLoader$1.run(URLClassLoader.java:366)

jji
From: grouper-users-request@internet2.edu grouper-users-request@internet2.edu On Behalf Of Linda Toth
Sent: Thursday, August 13, 2015 6:43 PM
To: Andrew Morgan
Cc: grouper-users
Subject: Re: [grouper-users] Red Hat Linux installation conundrum for oracle.jdbc.driver.OracleDriver

Scott Koranda's suggestion did the trick. I placed the driver in ~/grouper.apiBinary-2.2.1/lib/custom and zipped right through.

Linda

Linda Toth
University of Alaska - Office of Information Technology (OIT) - Identity and Access Management
910 Yukon Drive, Suite 103
Fairbanks, Alaska 99775

On Thu, Aug 13, 2015 at 2:41 PM, Andrew Morgan wrote:
On Thu, 13 Aug 2015, Linda Toth wrote:
Good afternoon,

I tried out grouper installation first by installing in on my desktop (Mac
OS/X) and using the hsqldb. Although it was 100% smooth, I was able to
reason out what was needed to completed the installation and had grouper up
and running within a day.

The RHEL installation is not going well. In production, we will be using
Oracle rather than the bundled database.

By reading the documentation and reviewing the tutorial, it is implied that
all drivers needed for an installation are included in the installation
package. However, once I have entered the hibernate.connection.url,
hibernate.connection.username, and hibernate.connection.password, the
program throws the following exception trace (despite adding the
ojdbc14.jar driver to a library and including it in the classpath. The
lines indicating issues in finding ojdbc14.jar are in red):

Checking database with query: select 1 from dual

Error: could not connect to the database:

java.lang.RuntimeException: Error with query: select 1 from dual
Caused by: java.lang.RuntimeException: Error connecting to: null
Caused by: java.lang.RuntimeException: Problem loading class:
oracle.jdbc.driver.OracleDriver
Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

I ran into the same problem with the installer. My installation notes say:

Database user: grouper
Database password:
(can't find oracle.jdbc.driver.OracleDriver, continuing)
install patch grouper_v2_2_1_api_patch_0: t
install patch grouper_v2_2_1_api_patch_1: t
install patch grouper_v2_2_1_api_patch_2: t
install patch grouper_v2_2_1_api_patch_3: t
init the database: (press CTRL-C here to break out of the installer)

Then I proceeded with configuration by hand and initialized the database later:

cd /private/grouper/api/bin
./gsh -registry -check
schemaexport all tables: y
./gsh -registry -runsqlfile /private/grouper/api/ddlScripts/<filename>.sql
run the sql file: y

I'm not sure why the installer had that error, but I just skipped it.

Andy