Grouper Users - Open Discussion List

[Eileen Roach <>]

We're having a problem configuring the value for the hibernate.connection.url for our Oracle 10g RAC database.  We can't get the grouper shell (gsh) to work with the RAC TNSNames value.  Grouper and the UI work, just not the shell.  Here's the error we get when starting the shell:

[mwadmin@s-grouper bin]# ./gsh.sh
Using GROUPER_HOME: /build/grouper/bin/..
Using GROUPER_CONF: /build/grouper/bin/../conf
Using JAVA: /deploy/Tools/jdk1.6.0_24/bin/java
using MEMORY: 64m-512m
Grouper starting up: version: 1.6.3, build date: 2011/01/03 01:44:08, env: CPDEV SANDBOX
grouper.properties read from: /build/grouper/conf/grouper.properties
Grouper current directory is: /build/grouper/bin
log4j.properties read from:   /build/grouper/conf/log4j.properties
Grouper is logging to file:   /build/grouper/bin/../logs/grouper_error.log, at min level WARN for package: edu.internet2.middleware.grouper, based on log4j.properties
grouper.hibernate.properties: /build/grouper/conf/grouper.hibernate.properties
grouper.hibernate.properties: sbgroups@
sources.xml read from:        /build/grouper/conf/sources.xml
sources.xml groupersource id: g:gsa
sources.xml jdbc source id:   cp-ent-users: GrouperJdbcConnectionProvider
sources.xml jdbc source id:   jdbc: GrouperJdbcConnectionProvider
Grouper error: Error connecting to the database with credentials from grouper.hibernate.properties, url: , driver: oracle.jdbc.OracleDriver, user: sbgroups, java.sql.SQLException: Io exception: NL Exception was generated
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:190)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:363)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:468)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:839)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkDatabase(GrouperCheckConfig.java:705)
        at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkGrouperDb(GrouperCheckConfig.java:613)
        at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:78)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:135)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:16)

Couldnt startup grouper: null
java.lang.NullPointerException
        at org.apache.ddlutils.PlatformFactory.createNewPlatformInstance(PlatformFactory.java:83)
        at org.apache.ddlutils.PlatformFactory.createNewPlatformInstance(PlatformFactory.java:107)
        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.retrievePlatform(GrouperDdlUtils.java:207)
        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:334)
        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrap(GrouperDdlUtils.java:261)
        at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:83)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:135)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:16)
Exception in thread "main" java.lang.NullPointerException
        at org.apache.ddlutils.PlatformFactory.createNewPlatformInstance(PlatformFactory.java:83)
        at org.apache.ddlutils.PlatformFactory.createNewPlatformInstance(PlatformFactory.java:107)
        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.retrievePlatform(GrouperDdlUtils.java:207)
        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:334)
        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrap(GrouperDdlUtils.java:261)
        at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:83)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:135)
        at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:16)

I can get the shell to work if I specify just one node of the RAC database (hibernate.connection.url = "), but then neither Grouper nor the shell will work if node 1 is down. 

Any ideas?

Thanks,

Eileen

-- 

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 Eileen Roach
 Programmer/Analyst, Identity Management Group
 California Polytechnic State University, San Luis Obispo
 Phone: (805)756-6214  
 E-mail: