Grouper Users - Open Discussion List

[Shilen Patel <>]

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: [] 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