Grouper Users - Open Discussion List

[Dick Visser <>]

hi

I'm running gsh.sh -test -all on a pristine 2.1.1, which an empty
Postgres database.
This errors before the tests even begin - any idea what is wrong here?


Using GROUPER_HOME: /opt/GROUPER_2_1_1/grouper
Using GROUPER_CONF: /opt/GROUPER_2_1_1/grouper/conf
Using JAVA: java
using MEMORY: 64m-750m
Grouper starting up: version: 2.1.1, build date: 2012/07/25 10:47:37,
env: <no label configured>
grouper.properties read from: 
/opt/GROUPER_2_1_1/grouper/conf/grouper.properties
Grouper current directory is: /opt/GROUPER_2_1_1/grouper
log4j.properties read from:   /opt/GROUPER_2_1_1/grouper/conf/log4j.properties
Grouper is logging to file:
/opt/GROUPER_2_1_1/grouper/logs/grouper_error.log, at min level WARN
for package: edu.internet2.middleware.grouper, based on
log4j.properties
grouper.hibernate.properties:
/opt/GROUPER_2_1_1/grouper/conf/grouper.hibernate.properties
grouper.hibernate.properties:
grouper_user@jdbc:postgresql://ip6-localhost:5432/grouper
sources.xml read from:        /opt/GROUPER_2_1_1/grouper/conf/sources.xml
sources.xml groupersource id: g:gsa
sources.xml groupersource id: grouperEntities
sources.xml jdbc source id:   jdbc: GrouperJdbcConnectionProvider
Couldnt startup grouper: Problem adding include/exclude type: 
addIncludeExclude
java.lang.RuntimeException: Problem adding include/exclude type:
addIncludeExclude
        at 
edu.internet2.middleware.grouper.misc.GrouperStartup.initIncludeExcludeType(GrouperStartup.java:379)
        at 
edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:144)
        at 
edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.initializeSchemaForTests(RegistryInitializeSchema.java:248)
        at 
edu.internet2.middleware.grouper.helper.GrouperTest.setupTests(GrouperTest.java:840)
        at edu.internet2.middleware.grouper.AllTests.suite(AllTests.java:177)
        at edu.internet2.middleware.grouper.AllTests.main(AllTests.java:151)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:204)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:144)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)
Caused by: edu.internet2.middleware.grouper.internal.dao.GrouperDAOException:
Problem in HibernateSession: HibernateSession: isNew: true,
isReadonly: true, grouperTransactionType: READONLY_NEW,
Exception in uniqueResult: (class
edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from
Member as m where      m.subjectIdDb       = :sid    and
m.subjectSourceIdDb = :source and  m.subjectTypeId   = :type',
cacheable: true, cacheRegion:
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject,
tx type: null, tx type: nullBind var[0]: 'Param (class
java.lang.String): 'sid'->'GrouperSystem', Bind var[1]: 'Param (class
java.lang.String): 'type'->'application'Bind var[2]: 'Param (class
java.lang.String): 'source'->'g:isa',
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:495)
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:581)
        at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:323)
        at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:217)
        at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:199)
        at 
edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:345)
        at 
edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:309)
        at 
edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:428)
        at 
edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:378)
        at 
edu.internet2.middleware.grouper.misc.GrouperStartup.initIncludeExcludeType(GrouperStartup.java:319)
        ... 12 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute 
query
        at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
        at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.loader.Loader.doList(Loader.java:2536)
        at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2319)
        at org.hibernate.loader.Loader.list(Loader.java:2268)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
        at 
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
        at 
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
        at 
org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
        at 
edu.internet2.middleware.grouper.hibernate.ByHql.uniqueResult(ByHql.java:257)
        at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHqlStatic.java:332)
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)
        ... 20 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation
"grouper_members" does not exist
  Position: 693
        at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
        at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
        at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
        at 
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
        at 
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
        at org.hibernate.loader.Loader.doQuery(Loader.java:802)
        at 
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
        at org.hibernate.loader.Loader.doList(Loader.java:2533)
        ... 31 more
(note, might need to type in your response multiple times (Java stdin is 
flaky))
(note, you can whitelist or blacklist db urls and users in the
grouper.properties)
Are you sure you want to schemaexport all tables
(dropThenCreate=T,writeAndRunScript=T) in db user 'grouper_user', db
url 'jdbc:postgresql://ip6-localhost:5432/grouper'? (y|n):
(END)




-- 
Dick Visser
System & Networking Engineer
TERENA Secretariat
Singel 468 D, 1017 AW Amsterdam
The Netherlands