Grouper Users - Open Discussion List

["Imholz, John J." <>]

I reset grouper.apiBinary-2.2.1, then added ojdbc7.jar to /lib/custom, and added the line:

 

hibernate.connection.driver_class = oracle.jdbc.OracleDriver

 

in /config/grouper.hibernate.properties

 

Ran the installer, and still got:

 

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)

 

 

I’m confused as to why you wanted to try this, because the ojdbc7.jar has the OracleDrive class in oracle/jdbc/driver.

 

Jji

 

From: Chris Hyzer [mailto:]
Sent: Thursday, August 27, 2015 12:21 PM
To: Imholz, John J. <>;
Subject: RE: [grouper-users] Red Hat Linux installation conundrum for oracle.jdbc.driver.OracleDriver

 

You should never edit any base config files, only add/edit things to the override (in this case grouper.hibernate.properties)

 

Thanks,

Chris

 

From: Imholz, John J. []
Sent: Thursday, August 27, 2015 9:56 AM
To: Chris Hyzer;
Subject: RE: [grouper-users] Red Hat Linux installation conundrum for oracle.jdbc.driver.OracleDriver

 

The grouper.apiBinary-2.2.1/conf/grouper.hibernate.properties has very little in it, you’re suggesting to add a line?

 

Or modify grouper.hibernate.base.properties ?

 

jji

 

From: Chris Hyzer []
Sent: Wednesday, August 26, 2015 6:01 PM
To: Imholz, John J. <>;
Subject: RE: [grouper-users] Red Hat Linux installation conundrum for oracle.jdbc.driver.OracleDriver

 

 

I think you might need to change the grouper.hibernate.properties to have a driver class of oracle.jdbc.OracleDriver instead of oracle.jdbc.driver.OracleDriver.  Does that help?  We might need to adjust the installer for new versions of Oracle…

 

Thanks,

Chris

 

From: [] On Behalf Of Imholz, John J.
Sent: Wednesday, August 26, 2015 7:51 AM
To:
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: [] On Behalf Of Linda Toth
Sent: Thursday, August 13, 2015 6:43 PM
To: Andrew Morgan <>
Cc:
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

Tel: 907-450-8320

Fax: 907-450-8381

 | www.alaska.edu/oit/

 

 

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