grouper-users - Re: [grouper-users] Red Hat Linux installation conundrum for oracle.jdbc.driver.OracleDriver

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Red Hat Linux installation conundrum for oracle.jdbc.driver.OracleDriver

From: "James R. McCartney" <>
To: "Imholz, John J." <>, 'Chris Hyzer' <>, "" <>
Subject: Re: [grouper-users] Red Hat Linux installation conundrum for oracle.jdbc.driver.OracleDriver
Date: Thu, 27 Aug 2015 17:50:53 +0000
Accept-language: en-US

I guess you tested the simple things like basic connection and username/password. But I will list 2 steps here if you haven't...

From the host, you can try to telnet:

telnet grouper-oracle-v-mdc.musc.edu 1521

That would prove that you can make a basic TCP connection tot he database (will have to ^] then quit to disconnect).

From a host that has sqlplus or sqldeveloper, try and connect with the hostname, database name, username, and password.

host: grouper-oracle-v-mdc.musc.edu

database: grpr

user: grouper_v1_5

password: ?

Make sure that the database name is not obfuscated by your tnsnames file. This will prove that you have all the connect settings correct.

jdbc:oracle:thin:@grouper-oracle-v-mdc.musc.edu:1521:grpr]:

Database user [grouper_v1_5]:

From: <> on behalf of "Imholz, John J." <>
Date: Thursday, August 27, 2015 at 11:45 AM
To: 'Chris Hyzer' <>, "" <>
Subject: RE: [grouper-users] Red Hat Linux installation conundrum for oracle.jdbc.driver.OracleDriver

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 []
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