Grouper Users - Open Discussion List

[Chris Hyzer <>]

Im looking here:

https://spaces.internet2.edu/display/Grouper/Grouper+Book+-+Installing+the+quickstart+-+Linux

Are you going against hsql?  Did you start the DB?  From: WEB-INF/lib

java -cp hsqldb.jar org.hsqldb.Server -database.0 file:grouper -dbname.0 
grouper

I don't see where the DDL is initted in the DB...

Can you go to WEB-INF/bin, and run:

./gsh.sh -registry -runscript?

Thanks,
Chris

-----Original Message-----
From: Ryan Suarez 
[mailto:]
 
Sent: Friday, September 30, 2011 1:50 PM
To: Chris Hyzer
Cc: 

Subject: Re: [grouper-users] SEVERE: Error filterStart

Sorry, I've turned up logging (still new to Tomcat).  It's spitting out 
stack traces now which should be more helpful:
http://pastebin.com/adkMd2YD

---
2011-09-30 13:41:54,669: [main] ERROR 
GrouperDdlUtils.bootstrapHelper(406) - Grouper ddl object type 'Grouper' 
has dbVersion: 23 and java version: 25
2011-09-30 13:41:55,735: [main] ERROR 
GrouperDdlUtils.bootstrapHelper(666) - Grouper database schema DDL 
requires updates
(should run script manually and carefully, in sections, verify data 
before drop statements, backup/export important data before starting, 
follow change log on confluence, dont run exact same script in multiple 
envs - generate a new one for each env),
script file is:
/opt/tomcat/webapps/grouper/WEB-INF/classes/ddlScripts/grouperDdl_20110930_13_41_55_727.sql
Grouper database schema DDL requires updates
(should run script manually and carefully, in sections, verify data 
before drop statements, backup/export important data before starting, 
follow change log on confluence, dont run exact same script in multiple 
envs - generate a new one for each env),
script file is:
/opt/tomcat/webapps/grouper/WEB-INF/classes/ddlScripts/grouperDdl_20110930_13_41_55_727.sql
Couldnt startup grouper: unable to retrieve GrouperSystem: Database 
schema ddl is not up to date, or has issues, check logs and config ddl 
in grouper.properties and run: gsh -registry -check,
Problem in HibernateSession: null,
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',
edu.internet2.middleware.grouper.exception.GrouperException: unable to 
retrieve GrouperSystem: Database schema ddl is not up to date, or has 
issues, check logs and config ddl in grouper.properties and run: gsh 
-registry -check,
---

Any ideas?