Grouper Users - Open Discussion List

[Curt Blank <>]

GW Brown, Information Systems and Computing wrote:

> --On 25 January 2007 10:57 -0600 Curt Blank 
> <>
>  wrote:
>
> > Caused by: java.sql.SQLException: Table not found: GROUPER_FIELDS in
> > statement [select field0_.id as id, field0_.group_type as group_type,
> > field0_.field_type as field_type, field0_.field_name as field_name,
> > field0_.read_priv as read_priv, field0_.write_priv as write_priv,
> > field0_.nullable as nullable from grouper_fields field0_ order by
> > field_name asc]
>
>
> Looks like Grouper can connect to the database, but that it isn't 
> finding GROUPER_FIELDS. Can you see this table through the database 
> manager?

I do a SELECT FROM GROUPER_FIELDS and I get a Table not found error.

> You could also try stopping the database, restarting the webapp and 
> seeing what error you get  - presumably a connect error.

Below is what I get in the catalina.out file and in the browser when I 
start tomcat with the db running.

> What size is your grouper-qs/grouper/dist/run/grouper.script file? 
> Have you run any of the grouper ant targets that might impact the 
> database i.e. db-init or schemaexport?

-rw-r--r--  1 root root 52 Jan 25 11:20 grouper/dist/run/grouper.script
containing:
CREATE USER SA PASSWORD "" ADMIN
SET WRITE_DELAY 60

>db-init or schemaexport
No.

catalina.out db not running:

Jan 25, 2007 11:24:36 AM org.apache.catalina.core.AprLifecycleListener 
lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal performance 
in production environments was not found on the java.library.path: 
/usr/java/jdk1.5.0_10/jre/lib/amd64/server:/usr/java/jdk1.5.0_10/jre/lib/amd64:/usr/java/jdk1.5.0_10/jre/../lib/amd64
Jan 25, 2007 11:24:36 AM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Jan 25, 2007 11:24:36 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 530 ms
Jan 25, 2007 11:24:36 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jan 25, 2007 11:24:36 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.20
Jan 25, 2007 11:24:36 AM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Jan 25, 2007 11:24:37 AM org.apache.catalina.startup.HostConfig 
deployDescriptor
WARNING: A docBase /usr/local/tomcat/webapps/grouper inside the host 
appBase has been specified, and will be ignored
Jan 25, 2007 11:24:38 AM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Jan 25, 2007 11:24:38 AM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Jan 25, 2007 11:24:38 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/22  config=null
Jan 25, 2007 11:24:38 AM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
Jan 25, 2007 11:24:38 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 2361 ms

in browser db not running:

OK, an Exception:

java.lang.ExceptionInInitializerError
        at 
edu.internet2.middleware.grouper.GrouperHelper.getFieldsAsMap(GrouperHelper.java:2682)
        at 
edu.internet2.middleware.grouper.ui.SessionInitialiser.init(SessionInitialiser.java:174)
        at 
edu.internet2.middleware.grouper.ui.SessionInitialiser.init(SessionInitialiser.java:79)
        at 
org.apache.jsp.WEB_002dINF.jsp.initPreLoginSession_jsp._jspService(initPreLoginSession_jsp.java:100)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
        at 
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
        at 
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)
        at 
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)
        at 
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:966)
        at 
org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:602)
        at 
org.apache.struts.tiles.TilesUtilImpl.doInclude(TilesUtilImpl.java:101)
        at org.apache.struts.tiles.TilesUtil.doInclude(TilesUtil.java:137)
        at 
org.apache.struts.taglib.tiles.InsertTag.doInclude(InsertTag.java:758)
        at 
org.apache.struts.taglib.tiles.InsertTag$InsertHandler.doEndTag(InsertTag.java:890)
        at 
org.apache.struts.taglib.tiles.InsertTag.doEndTag(InsertTag.java:460)
        at 
org.apache.jsp.WEB_002dINF.jsp.template_jsp._jspx_meth_tiles_insert_0(template_jsp.java:395)
        at 
org.apache.jsp.WEB_002dINF.jsp.template_jsp._jspService(template_jsp.java:156)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
        at 
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
        at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
        at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
        at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
        at 
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1056)
        at 
org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:261)
        at 
org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:237)
        at 
org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:300)
        at 
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:231)
        at 
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
        at 
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at 
edu.internet2.middleware.grouper.ui.LoginCheckFilter.doFilter(LoginCheckFilter.java:167)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:204)
        at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
        at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
        at 
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
        at 
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
        at 
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
        at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)
Caused by: edu.internet2.middleware.grouper.GrouperRuntimeException: unable 
to find all fields: Cannot open connection
        at edu.internet2.middleware.grouper.FieldFinder.findAll(Unknown 
Source)
        at edu.internet2.middleware.grouper.FieldFinder.(Unknown Source)
        ... 63 more
Caused by: net.sf.hibernate.exception.GenericJDBCException: Cannot open 
connection
        at 
net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90)
        at 
net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79)
        at 
net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
        at net.sf.hibernate.impl.BatcherImpl.convert(BatcherImpl.java:328)
        at 
net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:295)
        at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3373)
        at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3333)
        at 
net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:67)
        at 
net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:784)
        at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
        at 
net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
        at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
        at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
        at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
        at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
        at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
        ... 65 more
Caused by: java.sql.SQLException: socket creation error
        at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
        at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbcDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:140)
        at 
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:51)
        at 
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
        at 
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
        at 
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
        at 
net.sf.hibernate.connection.DBCPConnectionProvider.getConnection(DBCPConnectionProvider.java:41)
        at 
net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:292)
        ... 76 more


   Access Grouper

Login <http://grouper02.imt.uwm.edu:8080/grouper/callLogin.do>


   Grouper - intro

Grouper is a system for creating and maintaining institutional groups in 
a central repository. Such groups may be used for many different 
reasonpurposes e.g. for mailing lists, or for determining which set of 
people are allowed to access specific web applications, or for sharing 
resources. The goal is to create a group once, but use it as often as 
necessary in as wide a range of systems as possible.

In order to use Grouper effectively you must first understand some key 
concepts:

Group
   A group represents a collection of 'items' which are themselves
   considered to be members of the group. 

Subject
   A subject is an abstraction for any 'item' which may be a member of
   a group. A subject has a 'type' e.g. person or group. To specify
   that group B is a member of group A is to specify that all members
   of group B are also members of group A. In the future, other subject
   types may be available to define computers or applications.

Membership
   A specific relationship between a subject and a group.

Stem
   A stem is a name space in which groups exist. Stems are hierarchical
   so one way of thinking about stems is as folders. Folders may
   contain subfolders or files while stems can contain substems or
   groups. Stems can be used to collect together related groups and
   provide a means of controlling access to groups. Some examples of
   stems are:

       * uob:faculties:artf:fren = University of Bristol: Faculties:
         Arts Faculty: Department of French
       * uob:personal:[username] = University of Bristol: Personal
         groups: [name]

   In this web application, groups and stems are distinguished by the
   addition of square brackets [] around group names.

Privileges
   Grouper provides fine control over who can create stems and groups,
   who can change the membership of a group, and who can grant
   privileges for specific stems or groups to others. In fact,
   privileges are granted to subjects. By granting a privilege to a
   subject which is a group, all members of that group are granted the
   privilege (for as long as they are a member of the group).

   GrouperAll is a /special internal subject/. Any privilege granted to
   GrouperAll is, in effect, granted to all subjects.

   GrouperSystem is also a special internal subject which has implicit
   admin privileges for stems and groups.

   A /wheel/ group, if defined, conveys implicit GrouperSystem
   privileges to its members. Members of this group, by default, act as
   themselves with privileges limited to those assigned to them. This
   UI allows wheel group members to opt to /Act as admin/.

   *Stem privileges* 

   Create
       subject may create groups in this stem
   Stem
       subject may create stems in this stem


   *Group privileges*

   Member
       subject is a member of this group
   Optin
       subject may elect to become a member of this group
   Optout
       subject may elect to stop being a member of this group
   View
       subject may see that this group exists
   Read
       subject may see the membership list for this group
   Update
       subject may modify the membership of this group
   Admin
       subject may modify the membership of this group, delete the
       group or assign privileges for the group

logo
Grouper logo

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