Grouper Users - Open Discussion List

["GW Brown, Information Systems and Computing" <>]

Hi Joy,

Try adding a readOnly init-param, value=false to sources.xml - see 
<http://anoncvs.internet2.edu/cgi-bin/viewcvs.cgi/*checkout*/subject/doc/jdbc-adapter-user-guide.html?rev=HEAD&cvsroot=I2MI&content-type=text/html>

Gary

--On 04 October 2005 11:19 -0400 Joy Veronneau 
<>
 wrote:

> Hi Tom et al,
>
> With the additional error logging, I get this in the log file (see
> below) - I'm not sure what it means.
>
> Thanks for your help-
>
> Joy
>
> On Oct 4, 2005, at 10:22 AM, Tom Barton wrote:
>
> > Joy,
> >
> > This error indicates that the Subject API is not successfully
> > retrieving the GrouperSystem subject from any configured source.
> > Things to double-check are:
> >
> > 1. The WEB-INF/classes/sources.xml file is configured correctly.
> >
> > 2. The subject table contains an entry with subjectid =
> > 'GrouperSystem'.
> >
> > 3. The subjectattribute table contains rows with
> > (subjectid='GrouperSystem',name='loginid',value='GrouperSystem')
> > (subjectid='GrouperSystem',name='description',value not NULL)
> >
> > You can enable logging appropriate to see how the Subject API is
> > working by ensuring that WEB-INF/classes/log4j.properties declares
> > debug level for log4j.logger.edu.internet2.middleware.subject and
> > log4j.logger.edu.internet2.middleware.subject.provider.
> >
> > Please let me know if this helps.
> > Tom
> >
> > Joy Veronneau wrote:
>
> more grouper.log
> 2005-10-04 11:13:17,260 DEBUG SourceManager: Instantiating new Digester.
> 2005-10-04 11:13:17,260 DEBUG SourceManager: Instantiating new Digester.
> 2005-10-04 11:13:17,260 DEBUG SourceManager: Instantiating new Digester.
> 2005-10-04 11:13:17,268 DEBUG SourceManager: Parsing config input
> stream: 
> java.io.ByteArrayInputStream@5b675e
> 2005-10-04 11:13:17,268 DEBUG SourceManager: Parsing config input
> stream: 
> java.io.ByteArrayInputStream@5b675e
> 2005-10-04 11:13:17,268 DEBUG SourceManager: Parsing config input
> stream: 
> java.io.ByteArrayInputStream@5b675e
> 2005-10-04 11:13:17,388 DEBUG SourceManager: Loading source:
> grouperAdapter
> 2005-10-04 11:13:17,388 DEBUG SourceManager: Loading source:
> grouperAdapter
> 2005-10-04 11:13:17,388 DEBUG SourceManager: Loading source:
> grouperAdapter
> 2005-10-04 11:13:17,431 DEBUG SourceManager: Loading source:
> personJDBCAdapter
> 2005-10-04 11:13:17,431 DEBUG SourceManager: Loading source:
> personJDBCAdapter
> 2005-10-04 11:13:17,431 DEBUG SourceManager: Loading source:
> personJDBCAdapter
> 2005-10-04 11:13:17,455 DEBUG JDBCSourceAdapter: Loading JDBC driver:
> oracle.jdbc.driver.OracleDriver
> 2005-10-04 11:13:17,455 DEBUG JDBCSourceAdapter: Loading JDBC driver:
> oracle.jdbc.driver.OracleDriver
> 2005-10-04 11:13:17,455 DEBUG JDBCSourceAdapter: Loading JDBC driver:
> oracle.jdbc.driver.OracleDriver
> 2005-10-04 11:13:17,457  INFO JDBCSourceAdapter: JDBC driver loaded.
> 2005-10-04 11:13:17,457  INFO JDBCSourceAdapter: JDBC driver loaded.
> 2005-10-04 11:13:17,457  INFO JDBCSourceAdapter: JDBC driver loaded.
> 2005-10-04 11:13:17,514 DEBUG JDBCSourceAdapter: Initializing  connection
> factory.
> 2005-10-04 11:13:17,514 DEBUG JDBCSourceAdapter: Initializing  connection
> factory.
> 2005-10-04 11:13:17,514 DEBUG JDBCSourceAdapter: Initializing  connection
> factory.
> 2005-10-04 11:13:17,521 DEBUG JDBCSourceAdapter: Connection factory
> initialized.
> 2005-10-04 11:13:17,521 DEBUG JDBCSourceAdapter: Connection factory
> initialized.
> 2005-10-04 11:13:17,521 DEBUG JDBCSourceAdapter: Connection factory
> initialized.
> 2005-10-04 11:13:17,579  INFO JDBCSourceAdapter: Data Source  initialized.
> 2005-10-04 11:13:17,579  INFO JDBCSourceAdapter: Data Source  initialized.
> 2005-10-04 11:13:17,579  INFO JDBCSourceAdapter: Data Source  initialized.
> 2005-10-04 11:13:20,480 DEBUG JDBCSourceAdapter: SQLException  occurred:
> Cannot get a connection, pool exhausted
> org.apache.commons.dbcp.SQLNestedException: Cannot get a connection,
> pool exhausted
>          at org.apache.commons.dbcp.PoolingDataSource.getConnection
> (PoolingDataSource.java:103)
>          at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.getSubjectBy
> Identifier(Unknown Source)
>          at
> edu.internet2.middleware.grouper.SubjectFactory.getSubjectByIdentifier
> (Unknown Source)
>          at
> edu.internet2.middleware.grouper.SubjectFactory.getSubjectByIdentifier
> (Unknown Source)
>          at
> edu.internet2.middleware.grouper.ui.LoginCheckFilter.doFilter
> (LoginCheckFilter.java:218)
>          at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:166)
>          at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:146)
>          at org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.java:209)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
>          at org.apache.catalina.core.StandardPipeline.invoke
> (StandardPipeline.java:433)
>          at org.apache.catalina.core.ContainerBase.invoke
> (ContainerBase.java:948)
>          at org.apache.catalina.core.StandardContextValve.invoke
> (StandardContextValve.java:144)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
>          at org.apache.catalina.authenticator.AuthenticatorBase.invoke
> (AuthenticatorBase.java:504)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
>          at org.apache.catalina.core.StandardPipeline.invoke
> (StandardPipeline.java:433)
>          at org.apache.catalina.core.ContainerBase.invoke
> (ContainerBase.java:948)
>          at org.apache.catalina.core.StandardContext.invoke
> (StandardContext.java:2358)
>          at org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:133)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
>          at org.apache.catalina.valves.ErrorDispatcherValve.invoke
> (ErrorDispatcherValve.java:118)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
>          at org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:116)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
>          at org.apache.catalina.core.StandardPipeline.invoke
> (StandardPipeline.java:433)
>          at org.apache.catalina.core.ContainerBase.invoke
> (ContainerBase.java:948)
>          at org.apache.catalina.core.StandardEngineValve.invoke
> (StandardEngineValve.java:127)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
>          at org.apache.catalina.core.StandardPipeline.invoke
> (StandardPipeline.java:433)
>          at org.apache.catalina.core.ContainerBase.invoke
> (ContainerBase.java:948)
>          at org.apache.coyote.tomcat4.CoyoteAdapter.service
> (CoyoteAdapter.java:152)
>          at org.apache.coyote.http11.Http11Processor.process
> (Http11Processor.java:799)
>          at org.apache.coyote.http11.Http11Protocol
> $Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
>          at org.apache.tomcat.util.net.TcpWorkerThread.runIt
> (PoolTcpEndpoint.java:577)
>          at org.apache.tomcat.util.threads.ThreadPool
> $ControlRunnable.run(ThreadPool.java:683)
>          at java.lang.Thread.run(Thread.java:595)
> Caused by: java.util.NoSuchElementException: Could not create a
> validated object, cause: setReadOnly: Read-only connections not  supported
>          at  org.apache.commons.pool.impl.GenericObjectPool.borrowObject
> (GenericObjectPool.java:806)
>          at org.apache.commons.dbcp.PoolingDataSource.getConnection
> (PoolingDataSource.java:95)
>          ... 35 more
> 2005-10-04 11:13:20,480 DEBUG JDBCSourceAdapter: SQLException  occurred:
> Cannot get a connection, pool exhausted
> org.apache.commons.dbcp.SQLNestedException: Cannot get a connection,
> pool exhausted
>          at org.apache.commons.dbcp.PoolingDataSource.getConnection
> (PoolingDataSource.java:103)
>          at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.getSubjectBy
> Identifier(Unknown Source)
>          at
> edu.internet2.middleware.grouper.SubjectFactory.getSubjectByIdentifier
> (Unknown Source)
>          at
> edu.internet2.middleware.grouper.SubjectFactory.getSubjectByIdentifier
> (Unknown Source)
>          at
> edu.internet2.middleware.grouper.ui.LoginCheckFilter.doFilter
> (LoginCheckFilter.java:218)
>          at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:166)
>          at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:146)
>          at org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.java:209)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
>          at org.apache.catalina.core.StandardPipeline.invoke
> (StandardPipeline.java:433)
>          at org.apache.catalina.core.ContainerBase.invoke
> (ContainerBase.java:948)
>          at org.apache.catalina.core.StandardContextValve.invoke
> (StandardContextValve.java:144)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
>          at org.apache.catalina.authenticator.AuthenticatorBase.invoke
> (AuthenticatorBase.java:504)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
>          at org.apache.catalina.core.StandardPipeline.invoke
> (StandardPipeline.java:433)
>          at org.apache.catalina.core.ContainerBase.invoke
> (ContainerBase.java:948)
>          at org.apache.catalina.core.StandardContext.invoke
> (StandardContext.java:2358)
>          at org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:133)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
>          at org.apache.catalina.valves.ErrorDispatcherValve.invoke
> (ErrorDispatcherValve.java:118)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
>          at org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:116)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
>          at org.apache.catalina.core.StandardPipeline.invoke
> (StandardPipeline.java:433)
>          at org.apache.catalina.core.ContainerBase.invoke
> (ContainerBase.java:948)
>          at org.apache.catalina.core.StandardEngineValve.invoke
> (StandardEngineValve.java:127)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
>          at org.apache.catalina.core.StandardPipeline.invoke
> (StandardPipeline.java:433)
>          at org.apache.catalina.core.ContainerBase.invoke
> (ContainerBase.java:948)
>          at org.apache.coyote.tomcat4.CoyoteAdapter.service
> (CoyoteAdapter.java:152)
>          at org.apache.coyote.http11.Http11Processor.process
> (Http11Processor.java:799)
>          at org.apache.coyote.http11.Http11Protocol
> $Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
>          at org.apache.tomcat.util.net.TcpWorkerThread.runIt
> (PoolTcpEndpoint.java:577)
>          at org.apache.tomcat.util.threads.ThreadPool
> $ControlRunnable.run(ThreadPool.java:683)
>          at java.lang.Thread.run(Thread.java:595)
> Caused by: java.util.NoSuchElementException: Could not create a
> validated object, cause: setReadOnly: Read-only connections not  supported
>          at  org.apache.commons.pool.impl.GenericObjectPool.borrowObject
> (GenericObjectPool.java:806)
>          at org.apache.commons.dbcp.PoolingDataSource.getConnection
> (PoolingDataSource.java:95)
>          ... 35 more
> 2005-10-04 11:13:20,480 DEBUG JDBCSourceAdapter: SQLException  occurred:
> Cannot get a connection, pool exhausted
> org.apache.commons.dbcp.SQLNestedException: Cannot get a connection,
> pool exhausted
>          at org.apache.commons.dbcp.PoolingDataSource.getConnection
> (PoolingDataSource.java:103)
>          at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.getSubjectBy
> Identifier(Unknown Source)
>          at
> edu.internet2.middleware.grouper.SubjectFactory.getSubjectByIdentifier
> (Unknown Source)
>          at
> edu.internet2.middleware.grouper.SubjectFactory.getSubjectByIdentifier
> (Unknown Source)
>          at
> edu.internet2.middleware.grouper.ui.LoginCheckFilter.doFilter
> (LoginCheckFilter.java:218)
>          at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:166)
>          at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:146)
>          at org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.java:209)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
>          at org.apache.catalina.core.StandardPipeline.invoke
> (StandardPipeline.java:433)
>          at org.apache.catalina.core.ContainerBase.invoke
> (ContainerBase.java:948)
>          at org.apache.catalina.core.StandardContextValve.invoke
> (StandardContextValve.java:144)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
>          at org.apache.catalina.authenticator.AuthenticatorBase.invoke
> (AuthenticatorBase.java:504)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
>          at org.apache.catalina.core.StandardPipeline.invoke
> (StandardPipeline.java:433)
>          at org.apache.catalina.core.ContainerBase.invoke
> (ContainerBase.java:948)
>          at org.apache.catalina.core.StandardContext.invoke
> (StandardContext.java:2358)
>          at org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:133)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
>          at org.apache.catalina.valves.ErrorDispatcherValve.invoke
> (ErrorDispatcherValve.java:118)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
>          at org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:116)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
>          at org.apache.catalina.core.StandardPipeline.invoke
> (StandardPipeline.java:433)
>          at org.apache.catalina.core.ContainerBase.invoke
> (ContainerBase.java:948)
>          at org.apache.catalina.core.StandardEngineValve.invoke
> (StandardEngineValve.java:127)
>          at org.apache.catalina.core.StandardPipeline
> $StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
>          at org.apache.catalina.core.StandardPipeline.invoke
> (StandardPipeline.java:433)
>          at org.apache.catalina.core.ContainerBase.invoke
> (ContainerBase.java:948)
>          at org.apache.coyote.tomcat4.CoyoteAdapter.service
> (CoyoteAdapter.java:152)
>          at org.apache.coyote.http11.Http11Processor.process
> (Http11Processor.java:799)
>          at org.apache.coyote.http11.Http11Protocol
> $Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
>          at org.apache.tomcat.util.net.TcpWorkerThread.runIt
> (PoolTcpEndpoint.java:577)
>          at org.apache.tomcat.util.threads.ThreadPool
> $ControlRunnable.run(ThreadPool.java:683)
>          at java.lang.Thread.run(Thread.java:595)
> Caused by: java.util.NoSuchElementException: Could not create a
> validated object, cause: setReadOnly: Read-only connections not  supported
>          at  org.apache.commons.pool.impl.GenericObjectPool.borrowObject
> (GenericObjectPool.java:806)
>          at org.apache.commons.dbcp.PoolingDataSource.getConnection
> (PoolingDataSource.java:95)
>          ... 35 more
>  >



----------------------
GW Brown, Information Systems and Computing