Grouper Users - Open Discussion List

[Dick Visser <>]

I just updated to r8374 and can confirm it now works OK:

............Starting: 628 records in the DB to be exported (not exact,
might be less)
DONE: 16:51:22: exported 299 records to: a string
Starting: 418 records in the DB to be exported (not exact, might be less)
DONE: 16:51:23: exported 88 records to: a string
Starting: 418 records in the DB to be exported (not exact, might be less)
DONE: 16:51:24: exported 88 records to: a string
grouper import: reading document: string, version: 2.1.1
XML file contains 88 records
16:51:24: Beginning import: database contains 628 records
Ending import: processed 88 records
Ending import: database contains 628 records
Ending import: 0 inserts, 0 updates, and 88 skipped records
DONE: 16:51:25: imported 88 records from: string
.Starting: 514 records in the DB to be exported (not exact, might be less)
DONE: 16:51:28: exported 514 records to: a string
Starting: 514 records in the DB to be exported (not exact, might be less)
DONE: 16:51:30: exported 514 records to: a string
grouper import: reading document: string, version: 2.1.1
XML file contains 514 records
16:51:30: Beginning import: database contains 514 records
Ending import: processed 514 records
Ending import: database contains 514 records
Ending import: 0 inserts, 0 updates, and 514 skipped records
DONE: 16:51:31: imported 514 records from: string
.......................
Time: 4,085.633

OK (2168 tests)

Thanks!!

Dick

On 2 August 2012 20:26, Shilen Patel 
<>
 wrote:
> The two failures that Chris had below should now be resolved in the 2.1
> branch.
>
> Thanks!
>
> -- Shilen
>
> From: Chris Hyzer 
> <>
> Date: Thu, 26 Jul 2012 17:07:15 +0000
> To: Dick Visser 
> <>,
>  
> ""
> <>
> Subject: RE: [grouper-users] test -all errors
>
> I started postgres 9.1 on windows.
>
>
>
> Create new login role:
>
>
>
> CREATE ROLE grouper_new LOGIN
>
>    VALID UNTIL 'infinity';
>
>
>
> Set password:
>
>
>
> ALTER ROLE grouper_new ENCRYPTED PASSWORD 'xxxxxxx';
>
>
>
> Create a database:
>
>
>
> CREATE DATABASE grouper_new
>
>   WITH ENCODING='UTF8' OWNER=grouper_new CONNECTION LIMIT=-1;
>
>
>
> Edit the grouper.hibernate.properties:
>
>
>
> hibernate.connection.url = jdbc:postgresql://localhost:5432/grouper_new
>
>
>
> hibernate.connection.username         = grouper_new
>
>
>
> hibernate.connection.password         = xxxxx
>
>
>
> (assume schema is “public”)
>
>
>
> Create the database:
>
>
>
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin>gsh -registry
> –runscript
>
>
>
> Make sure registry is ok
>
>
>
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin>gsh -registry –check
>
>
>
> Run the tests
>
>
>
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin>gsh -test –all
>
>
>
> I get two errors, I will open a jira, but different than what you got I
> think…
>
>
>
> https://bugs.internet2.edu/jira/browse/GRP-825
>
>
>
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin>gsh -registry
> -runscript
>
> Using GROUPER_HOME:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin\..
>
> Using GROUPER_CONF:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin\../conf
>
> Using JAVA:                   "c:\dev_inst\java/bin/java"
>
> using MEMORY:                 64m-750m
>
> Grouper starting up: version: 2.1.1, build date: 2012/07/02 13:18:13, env:
> <no label configured>
>
> grouper.properties read from:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\conf\grouper.properties
>
> Grouper current directory is:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin
>
> log4j.properties read from:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\conf\log4j.properties
>
> Grouper is logging to file:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin\..\logs\grouper_error.log,
> at min level WARN for package: edu.inter
>
> net2.middleware.grouper, based on log4j.properties
>
> grouper.hibernate.properties:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\conf\grouper.hibernate.properties
>
> grouper.hibernate.properties:
> grouper_new@jdbc:postgresql://localhost:5432/grouper_new
>
> sources.xml read from:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\conf\sources.xml
>
> sources.xml groupersource id: g:gsa
>
> sources.xml groupersource id: grouperEntities
>
> sources.xml jdbc source id:   jdbc: GrouperJdbcConnectionProvider
>
> (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=F,writeAndRunScript=T) in db user 'grouper_new', db url
> 'jdbc:postgresql://localhost:
>
> 5432/grouper_new'? (y|n):
>
> y
>
> Continuing...
>
> Grouper ddl object type 'Grouper' has dbVersion: 0 and java version: 26
>
> Grouper ddl object type 'Subject' has dbVersion: 0 and java version: 1
>
> 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 chang
>
> e log on confluence, dont run exact same script in multiple envs - generate
> a new one for each env),
>
> script file is:
>
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\ddlScripts\grouperDdl_20120725_23_49_27_907.sql
>
> Script was executed successfully
>
>
>
>
>
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin>gsh -registry -check
>
> Using GROUPER_HOME:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin\..
>
> Using GROUPER_CONF:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin\../conf
>
> Using JAVA:                   "c:\dev_inst\java/bin/java"
>
> using MEMORY:                 64m-750m
>
> Grouper starting up: version: 2.1.1, build date: 2012/07/02 13:18:13, env:
> <no label configured>
>
> grouper.properties read from:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\conf\grouper.properties
>
> Grouper current directory is:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin
>
> log4j.properties read from:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\conf\log4j.properties
>
> Grouper is logging to file:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin\..\logs\grouper_error.log,
> at min level WARN for package: edu.inter
>
> net2.middleware.grouper, based on log4j.properties
>
> grouper.hibernate.properties:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\conf\grouper.hibernate.properties
>
> grouper.hibernate.properties:
> grouper_new@jdbc:postgresql://localhost:5432/grouper_new
>
> sources.xml read from:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\conf\sources.xml
>
> sources.xml groupersource id: g:gsa
>
> sources.xml groupersource id: grouperEntities
>
> sources.xml jdbc source id:   jdbc: GrouperJdbcConnectionProvider
>
> (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=F,writeAndRunScript=F) in db user 'grouper_new', db url
> 'jdbc:postgresql://localhost:
>
> 5432/grouper_new'? (y|n):
>
> y
>
> Continuing...
>
> NOTE: database table/object structure (ddl) is up to date
>
>
>
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin>gsh -test -all
>
> Using GROUPER_HOME:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin\..
>
> Using GROUPER_CONF:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin\../conf
>
> Using JAVA:                   "c:\dev_inst\java/bin/java"
>
> using MEMORY:                 64m-750m
>
> Grouper starting up: version: 2.1.1, build date: 2012/07/02 13:18:13, env:
> <no label configured>
>
> grouper.properties read from:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\conf\grouper.properties
>
> Grouper current directory is:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin
>
> log4j.properties read from:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\conf\log4j.properties
>
> Grouper is logging to file:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin\..\logs\grouper_error.log,
> at min level WARN for package: edu.inter
>
> net2.middleware.grouper, based on log4j.properties
>
> grouper.hibernate.properties:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\conf\grouper.hibernate.properties
>
> grouper.hibernate.properties:
> grouper_new@jdbc:postgresql://localhost:5432/grouper_new
>
> sources.xml read from:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\conf\sources.xml
>
> sources.xml groupersource id: g:gsa
>
> sources.xml groupersource id: grouperEntities
>
> sources.xml jdbc source id:   jdbc: GrouperJdbcConnectionProvider
>
> (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_new', db url
> 'jdbc:postgresql://localhost:
>
> 5432/grouper_new'? (y|n):
>
> y
>
> Continuing...
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrExternalSubjectInvite:externalSubjectInvite
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrExternalSubjectInvite:externalSubjectInviteExpireDate
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrExternalSubjectInvite:externalSubjectInviteDate
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrExternalSubjectInvite:externalSubjectEmailAddress
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrExternalSubjectInvite:externalSubjectInviteGroupUuids
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrExternalSubjectInvite:externalSubjectInviteMemberId
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrExternalSubjectInvite:externalSubjectInviteUuid
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrExternalSubjectInvite:externalSubjectInviteEmailWhenRegistered
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrExternalSubjectInvite:externalSubjectInviteEmail
>
> Grouper note: auto-created attributeDefName: etc:attribute:rules:rule
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleActAsSubjectId
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleActAsSubjectIdentifier
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleActAsSubjectSourceId
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleCheckType
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleCheckOwnerId
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleCheckOwnerName
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleCheckStemScope
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleCheckArg0
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleCheckArg1
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleIfOwnerId
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleIfOwnerName
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleIfConditionEl
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleIfConditionEnum
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleIfConditionEnumArg0
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleIfConditionEnumArg1
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleIfStemScope
>
> Grouper note: auto-created attributeDefName: etc:attribute:rules:ruleThenEl
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleThenEnum
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleThenEnumArg0
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleThenEnumArg1
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleThenEnumArg2
>
> Grouper note: auto-created attributeDefName: etc:attribute:rules:ruleValid
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:rules:ruleRunDaemon
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:permissionLimits:limitExpression
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:permissionLimits:limitIpOnNetworks
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:permissionLimits:limitIpOnNetworkRealm
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:permissionLimits:limitLabelsContain
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:permissionLimits:limitAmountLessThan
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:permissionLimits:limitAmountLessThanOrEqual
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:permissionLimits:limitWeekday9to5
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrLoader:attributeLoader
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrLoader:attributeLoaderType
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrLoader:attributeLoaderDbName
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrLoader:attributeLoaderScheduleType
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrLoader:attributeLoaderQuartzCron
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrLoader:attributeLoaderIntervalSeconds
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrLoader:attributeLoaderPriority
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrLoader:attributeLoaderAttrsLike
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrLoader:attributeLoaderAttrQuery
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrLoader:attributeLoaderAttrSetQuery
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrLoader:attributeLoaderActionQuery
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:attrLoader:attributeLoaderActionSetQuery
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdap
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapType
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapServerId
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapFilter
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapQuartzCron
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapSearchDn
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapSubjectAttribute
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapSourceId
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapSubjectIdType
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapAndGroups
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapSearchScope
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapPriority
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapGroupsLike
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapGroupAttribute
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapExtraAttributes
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapErrorUnresolvable
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapGroupNameExpression
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapGroupDisplayNameExpression
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapGroupDescriptionExpression
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapSubjectExpression
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapGroupTypes
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapReaders
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapViewers
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapAdmins
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapUpdaters
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapOptins
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:loaderLdap:grouperLoaderLdapOptouts
>
> Grouper note: auto-created attributeDefName:
> etc:attribute:entities:entitySubjectIdentifier
>
> .........................................
>
> .........................................
>
> .........................db prompting has been disabled (e.g. due to
> testing), so this user 'grouper_new' and url
> 'jdbc:postgresql://localhost:5432/gr
>
> ouper_new' are allowed for: delete all grouper data
>
> .........null
>
> ...Would obliterate stem: test
>
> Would obliterate stem: test:sub1
>
> Would obliterate stem: test:sub1:sub12
>
> Would be done deleting group: test:sub1:sub12:testGroup
>
> Would be done deleting group: test:sub1:sub12:testGroup2
>
> Would be done deleting group: test:sub1:sub12:testGroup3
>
> Would be done deleting attributeDef: test:sub1:sub12:testAttributeDef
>
> Would be done deleting attributeDef: test:sub1:sub12:testAttributeDef2
>
> Would be done deleting attributeDef: test:sub1:sub12:testAttributeDef3
>
> Would be done obliterating stem: test:sub1:sub12
>
> Would be done deleting group: test:sub1:testGroup
>
> Would be done deleting group: test:sub1:testGroup2
>
> Would be done deleting group: test:sub1:testGroup3
>
> Would be done deleting attributeDef: test:sub1:testAttributeDef
>
> Would be done deleting attributeDef: test:sub1:testAttributeDef2
>
> Would be done deleting attributeDef: test:sub1:testAttributeDef3
>
> Would be done obliterating stem: test:sub1
>
> Would obliterate stem: test:sub2
>
> Would obliterate stem: test:sub2:sub22
>
> Would be done deleting group: test:sub2:sub22:testGroup
>
> Would be done deleting group: test:sub2:sub22:testGroup2
>
> Would be done deleting group: test:sub2:sub22:testGroup3
>
> Would be done deleting attributeDef: test:sub2:sub22:testAttributeDef
>
> Would be done deleting attributeDef: test:sub2:sub22:testAttributeDef2
>
> Would be done deleting attributeDef: test:sub2:sub22:testAttributeDef3
>
> Would be done obliterating stem: test:sub2:sub22
>
> Would be done deleting group: test:sub2:testGroup
>
> Would be done deleting group: test:sub2:testGroup2
>
> Would be done deleting group: test:sub2:testGroup3
>
> Would be done deleting attributeDef: test:sub2:testAttributeDef
>
> Would be done deleting attributeDef: test:sub2:testAttributeDef2
>
> Would be done deleting attributeDef: test:sub2:testAttributeDef3
>
> Would be done obliterating stem: test:sub2
>
> Would be done deleting group: test:testGroup
>
> Would be done deleting group: test:testGroup2
>
> Would be done deleting group: test:testGroup3
>
> Would be done deleting attributeDefName: test:testAttributeDefName
>
> Would be done deleting attributeDefName: test:testSub1AttributeDefName
>
> Would be done deleting attributeDefName: test:testSub12AttributeDefName
>
> Would be done deleting attributeDefName: test:testSub13AttributeDefName
>
> Would be done deleting attributeDefName: test:testSub2AttributeDefName
>
> Would be done deleting attributeDefName: test:testAttributeDefName2
>
> Would be done deleting attributeDefName: test:testAttributeDefName3
>
> Would be done deleting attributeDefName: test:testSub22AttributeDefName
>
> Would be done deleting attributeDefName: test:testSub23AttributeDefName
>
> Would be done deleting attributeDefName: test:testSub112AttributeDefName
>
> Would be done deleting attributeDefName: test:testSub122AttributeDefName
>
> Would be done deleting attributeDefName: test:testSub123AttributeDefName
>
> Would be done deleting attributeDefName: test:testSub222AttributeDefName
>
> Would be done deleting attributeDefName: test:testSub2222AttributeDefName
>
> Would be done deleting attributeDefName: test:testSub2223AttributeDefName
>
> Would be done deleting attributeDef: test:testAttributeDef
>
> Would be done deleting attributeDef: test:testAttributeDef2
>
> Would be done deleting attributeDef: test:testAttributeDef3
>
> Would be done obliterating stem: test
>
> ....
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .....................................loader ran successfully, inserted 3
> memberships, deleted 0 memberships, total membership count: 3
>
> loader ran successfully, inserted 0 memberships, deleted 0 memberships,
> total membership count: 3
>
> ....
>
> ........member_uuid='afee96549e0349ac8c3cc060c46cba89'
> subject='a'/'person'/'jdbc' group='i2:a:a list='members' delete
>
> .member_uuid='2c6830a9c13b4e109216c9a8a747a895' subject='a'/'person'/'jdbc'
> group='i2:a:a list='customList' delete
>
> .member_uuid='31be0f8989724ab6a4209a31c1913b44' subject='a'/'person'/'jdbc'
> group='i2:a:a list='admins' delete
>
> member_uuid='31be0f8989724ab6a4209a31c1913b44' subject='a'/'person'/'jdbc'
> group='i2:a:a list='optins' delete
>
> member_uuid='31be0f8989724ab6a4209a31c1913b44' subject='a'/'person'/'jdbc'
> group='i2:a:a list='optouts' delete
>
> member_uuid='31be0f8989724ab6a4209a31c1913b44' subject='a'/'person'/'jdbc'
> group='i2:a:a list='readers' delete
>
> member_uuid='31be0f8989724ab6a4209a31c1913b44' subject='a'/'person'/'jdbc'
> group='i2:a:a list='updaters' delete
>
> member_uuid='31be0f8989724ab6a4209a31c1913b44' subject='a'/'person'/'jdbc'
> group='i2:a:a list='viewers' delete
>
> .member_uuid='3af1d2beaa574e4983143ea66f903221' subject='a'/'person'/'jdbc'
> stem='i2 list='creators' delete
>
> member_uuid='3af1d2beaa574e4983143ea66f903221' subject='a'/'person'/'jdbc'
> stem='i2 list='stemmers' delete
>
> ..............................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> ..........{
>
>   "esbEvent":[
>
>     {
>
>       "sourceId":"g:isa",
>
>       "subjectId":"GrouperSystem"
>
>     }
>
>   ]
>
> }
>
> ...............................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .................
>
>
>
> Searching for missing self groupSets for attribute defs
>
> Found 0 missing groupSets
>
>
>
>
>
> Searching for all composite groups to cache for later use
>
> Searching for missing self groupSets for groups
>
> Found 0 missing groupSets
>
>
>
>
>
> Searching for missing self groupSets for stems
>
> Found 0 missing groupSets
>
>
>
>
>
> Searching for missing immediate groupSets where the owner is an attribute
> def
>
> Found 0 missing groupSets
>
>
>
>
>
> Searching for missing immediate groupSets where the owner is a group
>
> Found 0 missing groupSets
>
>
>
>
>
> Searching for missing immediate groupSets where the owner is a stem
>
> Found 0 missing groupSets
>
> ........................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> ..........F.F..............................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> .........................................
>
> ......................Rule 0: attributeAssignTypeId:
> 1b779ef1795147db95042b542fcd52ce, actAsSourceId: g:isa, actAsSubjectId:
> GrouperSystem, checkOwner
>
> Name: stem:c, checkType: membershipRemove, ifConditionEnum:
> thisGroupHasImmediateEnabledMembership, thenEl:
> ${ruleElUtils.removeMemberFromGroupId(owne
>
> rGroupId, memberId)},
>
> Rule 1: attributeAssignTypeId: 408e6b28c7cb4c9c9ea2d1a3afe872be,
> actAsSourceId: g:isa, actAsSubjectId: GrouperSystem, checkOwnerName: stem:b,
> checkTyp
>
> e: membershipRemove, ifConditionEnum:
> thisGroupHasImmediateEnabledMembership, thenEl:
> ${ruleElUtils.removeMemberFromGroupId(ownerGroupId, memberId)},
>
>
>
> ..........Rule 0: attributeAssignTypeId: 1e1f821df02b4710b933d14721ef3e47,
> actAsSourceId: g:isa, actAsSubjectId: GrouperSystem, checkOwnerName: stem:c
>
> , checkType: membershipRemove, ifConditionEnum:
> thisGroupHasImmediateEnabledMembership, thenEl:
> ${ruleElUtils.removeMemberFromGroupId(ownerGroupId, me
>
> mberId)},
>
> Rule 1: attributeAssignTypeId: 29776468b0554600980d568e5ecd7d44,
> actAsSourceId: g:isa, actAsSubjectId: GrouperSystem, checkOwnerName: stem:b,
> checkTyp
>
> e: membershipRemove, ifConditionEnum:
> thisGroupHasImmediateEnabledMembership, thenEl:
> ${ruleElUtils.removeMemberFromGroupId(ownerGroupId, memberId)},
>
>
>
>
>
> .........
>
> ..........{
>
>   "RuleDefinition":{
>
>     "actAs":{
>
>       "sourceId":"source",
>
>       "subjectId":"subjectId"
>
>     },
>
>     "check":{
>
>       "checkOwnerId":"a group",
>
>       "checkType":"flattenedMembershipRemove"
>
>     },
>
>     "ifCondition":{
>
>       "ifConditionEl":"if condition"
>
>     },
>
>     "runDaemonBoolean":true,
>
>     "then":{
>
>       "thenEl":"then part"
>
>     }
>
>   }
>
> }
>
> ...............................
>
> .........................Took: 31ms
>
> ................
>
> .....................Took: 35ms
>
> .Took: 47ms
>
> ...................
>
> ...................................{"id":"g:isa","initParams":{"subjectVirtualAttribute_0_searchAttribute0":"${subject.name},${subject.id}","searchAtt
>
> ribute0":"searchAttribute0","sortAttribute0":"sortAttribute0","subjectVirtualAttribute_0_sortAttribute0":"${subject.name}"},"internalAttributes":["sor
>
> tAttribute0","searchAttribute0"],"name":"Grouper: Internal Source
> Adapter","subjectType":null,"subjectTypes":[{"name":"application"}]}
>
> ......
>
> .........................................
>
> .........................................
>
> ......................................userAudit export: Exported 79
> auditTypes
>
> userAudit export: Exported auditEntries:  21 / 200 ( 10%) 01:48:13.594
>
> userAudit export: Exported auditEntries:  41 / 200 ( 20%) 01:48:13.600
>
> userAudit export: Exported auditEntries:  61 / 200 ( 30%) 01:48:13.605
>
> userAudit export: Exported auditEntries:  81 / 200 ( 40%) 01:48:13.609
>
> userAudit export: Exported auditEntries: 101 / 200 ( 50%) 01:48:13.614
>
> userAudit export: Exported auditEntries: 121 / 200 ( 60%) 01:48:13.619
>
> userAudit export: Exported auditEntries: 141 / 200 ( 70%) 01:48:13.624
>
> userAudit export: Exported auditEntries: 161 / 200 ( 80%) 01:48:13.629
>
> userAudit export: Exported auditEntries: 181 / 200 ( 90%) 01:48:13.634
>
> userAudit export: Exported auditEntries: 200 / 200 (100%) 01:48:13.645
>
> userAudit import: reading document:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin\testUserAuditExport.xml,
> version: 2.1.1
>
> userAudit import: completed with members:      total: 1, new: 0, existing:
> 1, changed: 0
>
> userAudit import: completed with auditTypes:   total: 79, new: 0, existing:
> 79, changed: 0
>
> userAudit import: completed with auditEntries: total: 200, new: 0, existing:
> 200, changed: 0
>
> userAudit import: reading document:
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin\testUserAuditExport.xml,
> version: 2.1.1
>
> userAudit import: completed with members:      total: 1, new: 0, existing:
> 1, changed: 0
>
> userAudit import: completed with auditTypes:   total: 79, new: 79, existing:
> 0, changed: 0
>
> userAudit import: completed with auditEntries: total: 200, new: 200,
> existing: 0, changed: 0
>
> ...
>
> ............Starting: 514 records in the DB to be exported (not exact, might
> be less)
>
> DONE: 01:48:36: exported 514 records to: a string
>
> Starting: 514 records in the DB to be exported (not exact, might be less)
>
> DONE: 01:48:37: exported 514 records to: a string
>
> grouper import: reading document: string, version: 2.1.1
>
> XML file contains 514 records
>
> 01:48:38: Beginning import: database contains 514 records
>
> Ending import: processed 514 records
>
> Ending import: database contains 514 records
>
> Ending import: 0 inserts, 0 updates, and 514 skipped records
>
> DONE: 01:48:39: imported 514 records from: string
>
> .Starting: 628 records in the DB to be exported (not exact, might be less)
>
> DONE: 01:48:49: exported 299 records to: a string
>
> Starting: 418 records in the DB to be exported (not exact, might be less)
>
> DONE: 01:48:50: exported 88 records to: a string
>
> Starting: 418 records in the DB to be exported (not exact, might be less)
>
> DONE: 01:48:51: exported 88 records to: a string
>
> grouper import: reading document: string, version: 2.1.1
>
> XML file contains 88 records
>
> 01:48:51: Beginning import: database contains 628 records
>
> Ending import: processed 88 records
>
> Ending import: database contains 628 records
>
> Ending import: 0 inserts, 0 updates, and 88 skipped records
>
> DONE: 01:48:52: imported 88 records from: string
>
> .......................
>
> Time: 6,959.843
>
> There were 2 failures:
>
> 1)
> testGroupRename(edu.internet2.middleware.grouper.member.TestMemberAttributes)junit.framework.ComparisonFailure:
> null expected:<edu:Test[2]> but was
>
> :<edu:Test[]>
>
>         at
> edu.internet2.middleware.grouper.member.TestMemberAttributes.testGroupRename(TestMemberAttributes.java:475)
>
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>         at edu.internet2.middleware.grouper.AllTests.main(AllTests.java:157)
>
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>         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)
>
> 2)
> testGroupMove(edu.internet2.middleware.grouper.member.TestMemberAttributes)junit.framework.ComparisonFailure:
> null expected:<edu[2]:Test> but was:<
>
> edu[]:Test>
>
>         at
> edu.internet2.middleware.grouper.member.TestMemberAttributes.testGroupMove(TestMemberAttributes.java:498)
>
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>         at edu.internet2.middleware.grouper.AllTests.main(AllTests.java:157)
>
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>         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)
>
>
>
> FAILURES!!!
>
> Tests run: 2168,  Failures: 2,  Errors: 0
>
>
>
>
>
> C:\apps\grouper_postgres\grouper.apiBinary-2.1.1\bin>
>
>
>
>
>
> -----Original Message-----
> From: 
> 
> [mailto:]
>  On Behalf Of Dick Visser
> Sent: Wednesday, July 25, 2012 4:52 AM
> To: 
> 
> Subject: [grouper-users] test -all errors
>
>
>
> 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



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