Grouper Users - Open Discussion List

["Gettes, Michael" <>]

Hi all,

I am trying to configure (in docker containers, of course) grouper to use OracleDB.  I have been doing this for some time with no issue but I have been using the syntax of jdbc:oracle:thin:@FULL-TNS-NAMES-ENTRY-SINGLE-STRING

I want to switch to using jdbc:oracle:thin:@tnsEntryName.  The page  https://docs.oracle.com/cd/B19306_01/java.102/b14355/urls.htm#i1070726 towards the bottom where it says "Thin-style Service Name Syntax” indicates this is possible.  I have configured -Doracle.net.tns_admin=/ in GSH_JVMARGS env variable for docker and I test it with GSH and it appears to work fine.  I do a look up against the subject source and no issues.  HOWEVER, I then go and fire up the UI with the same config I get the error below.  Has anyone else gotten this to work either with Docker or not?

ui_1        | tomcat;console;dev;;Subject API error: problem with subject.properties source id: UFperson, Error connecting to the database with credentials from subject.properties, url: jdbc:oracle:thin:@SHIBPRD, driver: oracle.jdbc.driver.OracleDriver, user: XXXXXX, java.sql.SQLRecoverableException: IO Error: Unknown host specified 
ui_1        | tomcat;console;dev;; at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:548)
ui_1        | tomcat;console;dev;; at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:564)
ui_1        | tomcat;console;dev;; at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:251)
ui_1        | tomcat;console;dev;; at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:29)
ui_1        | tomcat;console;dev;; at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:563)
ui_1        | tomcat;console;dev;; at java.sql.DriverManager.getConnection(DriverManager.java:664)
ui_1        | tomcat;console;dev;; at java.sql.DriverManager.getConnection(DriverManager.java:247)
ui_1        | tomcat;console;dev;; at edu.internet2.middleware.subject.provider.JDBCSourceAdapter2.checkConfig(JDBCSourceAdapter2.java:218)
ui_1        | tomcat;console;dev;; at edu.internet2.middleware.subject.SubjectCheckConfig.checkConfig(SubjectCheckConfig.java:106)
ui_1        | tomcat;console;dev;; at edu.internet2.middleware.grouper.misc.GrouperCheckConfig$1.callback(GrouperCheckConfig.java:522)
ui_1        | tomcat;console;dev;; at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:974)
ui_1        | tomcat;console;dev;; at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkConfig(GrouperCheckConfig.java:518)
ui_1        | tomcat;console;dev;; at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:313)
ui_1        | tomcat;console;dev;; at edu.internet2.middleware.grouper.ui.GrouperUiFilter.init(GrouperUiFilter.java:781)
ui_1        | tomcat;console;dev;; at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279)
ui_1        | tomcat;console;dev;; at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260)
ui_1        | tomcat;console;dev;; at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:105)
ui_1        | tomcat;console;dev;; at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4599)
ui_1        | tomcat;console;dev;; at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5242)
ui_1        | tomcat;console;dev;; at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
ui_1        | tomcat;console;dev;; at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
ui_1        | tomcat;console;dev;; at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
ui_1        | tomcat;console;dev;; at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
ui_1        | tomcat;console;dev;; at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:596)
ui_1        | tomcat;console;dev;; at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1805)
ui_1        | tomcat;console;dev;; at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
ui_1        | tomcat;console;dev;; at java.util.concurrent.FutureTask.run(FutureTask.java:266)
ui_1        | tomcat;console;dev;; at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
ui_1        | tomcat;console;dev;; at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
ui_1        | tomcat;console;dev;; at java.lang.Thread.run(Thread.java:748)
ui_1        | tomcat;console;dev;;Caused by: oracle.net.ns.NetException: Unknown host specified 
ui_1        | tomcat;console;dev;; at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:188)
ui_1        | tomcat;console;dev;; at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:130)
ui_1        | tomcat;console;dev;; at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:428)
ui_1        | tomcat;console;dev;; at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:897)
ui_1        | tomcat;console;dev;; at oracle.net.ns.NSProtocol.connect(NSProtocol.java:271)
ui_1        | tomcat;console;dev;; at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1663)
ui_1        | tomcat;console;dev;; at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:385)
ui_1        | tomcat;console;dev;; ... 29 more
ui_1        | tomcat;console;dev;;