grouper-users - [grouper-users] Grouper 2.4 problem in subject.properties
Subject: Grouper Users - Open Discussion List
List archive
- From: "Guenther, Dean R." <>
- To: "" <>
- Subject: [grouper-users] Grouper 2.4 problem in subject.properties
- Date: Fri, 12 Oct 2018 00:15:33 +0000
- Accept-language: en-US
- Authentication-results: spf=none (sender IP is ) ;
- Ironport-phdr: 9a23:ArLPihWFRZ1MUyAj58xoO7YhsxrV8LGtZVwlr6E/grcLSJyIuqrYbROPt8tkgFKBZ4jH8fUM07OQ7/i/HzRYqb+681k6OKRWUBEEjchE1ycBO+WiTXPBEfjxciYhF95DXlI2t1uyMExSBdqsLwaK+i764jEdAAjwOhRoLerpBIHSk9631+ev8JHPfglEnjWwba9wIRmssQndqtQdjJd/JKo21hbHuGZDdf5MxWNvK1KTnhL86dm18ZV+7SleuO8v+tBZX6nicKs2UbJXDDI9M2Ao/8LrrgXMTRGO5nQHTGoblAdDDhXf4xH7WpfxtTb6tvZ41SKHM8D6Uaw4VDK/5KptVRTmijoINyQh/W/XlMJ+kb5brhyiqRx+34Hbb5qYO+Bicq/BZ94WWXZNUthXWidcAo28dYwPD+8ZMOpWrof9ukUBrR2iBQmsGuzv0CdEjWL406IkyeshFxzN0hA6E94ArX/Zq9r1NLoMXuCz0KnIzSvMb+lN1Dbz84jIbwotru+RUrJtaMfcz1QkGQ3CjlWVs4PlPjWV2/wPs2eG9OVvSfiji2g9pAF0vDej3t8shZPTho0Pz1DI7yN5z5wwJdKmUEJ7bsSkEJxNtyGCKYR2WNkuTHtwuCYi0rEGu4O0czMWx5g9xh7QdvqKeJWL7BL7TOudPCt0iX1/dL+whRu+60etxvDmWsS1zVpGtjdJn9fDu3wXyhDf9NWLRuFg8kqu2TuDzR7f5+NcLUA6i6XWKIItz7s1m5UOsUnOHCH2lUDsg6KWeUgr4O2l6+rkb7r4qJKRMo55hRz+P6kgnMG0HP42PRIUX2eB/OSxzL3j8lP9QLVNlvA4irXUvpfGKckVv6K3DQhb34g65xa4FDipzs4UnX4aLFJZYx2HiJXpO1fTL/ziFfe/mVOskCt1yP/aIr3hA5LNLn7ZnLfmYLZ990pcyA00zdBc/Z5bFrYBIPfrVk/wstzXEAM5PhSpz+r7B9hxzIwTVGCVDqKWLa/eq16F6v83L+mJfoAVuTL9K/Y/5/7piH80gVAdfbS30psRdHC4HuppI1+CbHvimdcBDH0GsRQjQ+z3kFGCSyJcZ26uX6Ig4TE2EI2mDZ3ERoCwmLyOwj27EoRLZmBdFF+MC2zoep6AW/cNcyKSPtRhniIeWbigTY8hyQ+htBX8y7V5MurY5DcUuoz+29hotKXvkkR4+iZzEtyQySSQVGxuhUsJQSM7xqZyvRY7x1uem+AsjOZfCMRe/bZUSQogLrbdyfB3Edb/RliHc9uUHgWIWNKjVHseU983398DeQI1N9iriFj5mWDiV7AImrqXBJEu2r3Hwj78K9srmCWO77Uok1RzGpgHDmahnKMqr1KJVYfUj0WUkbqrfq0A3SnLsX2O1neKoFoFAVxrSauQW3cZawOWttn/6k7YB56WQbU8ekokq4aZL7dSLNjgjFFIXvDmbdvDbmStm2qqLQmT2/WBYJe5M2g=
- Spamdiagnosticmetadata: NSPM
- Spamdiagnosticoutput: 1:99
|
I have a new Grouper 2.4 install (thanks to Chris and Chad, I needed Java 1.8) I’ve put together what I thought was a correct subject.properties (below) but when I try and start grouper it complains that it is unable to init subject.properties. But I can’t tell from the error what I’m missing. Here is the stack trace: Using GROUPER_CONF: /opt/grouper/grouper.installer-2.4.0/grouper.apiBinary-2.4.0/conf Using JAVA: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.181-3.b13.el7_5.x86_64/bin/java using MEMORY: 64m-750m log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.DailyRollingFileAppender. Grouper starting up: version: 2.4.0, build date: 2018/08/23 07:48:38, env: dev grouperPatchStatus read from: /opt/grouper/grouper.installer-2.4.0/grouper.apiBinary-2.4.0/grouperPatchStatus.properties api patches installed: 0, 1, 2 pspng patches installed: 0 grouper.properties read from: /opt/grouper/grouper.installer-2.4.0/grouper.apiBinary-2.4.0/conf/grouper.properties Grouper current directory is: /opt/grouper/grouper.installer-2.4.0/grouper.apiBinary-2.4.0/conf log4j.properties read from: /opt/grouper/grouper.installer-2.4.0/grouper.apiBinary-2.4.0/conf/log4j.properties Grouper is logging to file: /opt/grouper/grouper.installer-2.4.0/grouper.apiBinary-2.4.0/logs/grouper_error.log, at min level WARN for package: edu.internet2.middleware.grouper, based on log4j.properties grouper.hibernate.properties: /opt/grouper/grouper.installer-2.4.0/grouper.apiBinary-2.4.0/conf/grouper.hibernate.properties grouper.hibernate.properties: groupersystem@jdbc:oracle:thin:@idm-grouper-db-d1n01.it.wsu.edu:1521:MIM problem with sources Couldnt startup grouper: Error initializing SourceManager java.lang.RuntimeException: Error initializing SourceManager at edu.internet2.middleware.subject.provider.SourceManager.init(SourceManager.java:326) at edu.internet2.middleware.subject.provider.SourceManager.<init>(SourceManager.java:256) at edu.internet2.middleware.subject.provider.SourceManager.getInstance(SourceManager.java:266) at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:284) at edu.internet2.middleware.grouper.app.loader.GrouperLoader.main(GrouperLoader.java:107) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:216) at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:150) at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31) Caused by: edu.internet2.middleware.subject.SourceUnavailableException: Unable to init subject.properties JDBC source, source: GrouperPersonRegistry at edu.internet2.middleware.subject.provider.JDBCSourceAdapter.init(JDBCSourceAdapter.java:815) at edu.internet2.middleware.subject.provider.SourceManager.loadSource(SourceManager.java:351) at edu.internet2.middleware.subject.provider.SourceManager.parseConfig(SourceManager.java:365) at edu.internet2.middleware.subject.provider.SourceManager.init(SourceManager.java:323) ... 11 more Caused by: edu.internet2.middleware.subject.SourceUnavailableException: dbTableOrView not defined, source: GrouperPersonRegistry at edu.internet2.middleware.subject.provider.JDBCSourceAdapter2.setupDataSource(JDBCSourceAdapter2.java:658) at edu.internet2.middleware.subject.provider.JDBCSourceAdapter.init(JDBCSourceAdapter.java:759) ... 14 more Exception in thread "main" java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:226) at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:150) at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:216) ... 2 more Caused by: java.lang.RuntimeException: Error initializing SourceManager at edu.internet2.middleware.subject.provider.SourceManager.init(SourceManager.java:326) at edu.internet2.middleware.subject.provider.SourceManager.<init>(SourceManager.java:256) at edu.internet2.middleware.subject.provider.SourceManager.getInstance(SourceManager.java:266) at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:284) at edu.internet2.middleware.grouper.app.loader.GrouperLoader.main(GrouperLoader.java:107) ... 7 more Caused by: edu.internet2.middleware.subject.SourceUnavailableException: Unable to init subject.properties JDBC source, source: GrouperPersonRegistry at edu.internet2.middleware.subject.provider.JDBCSourceAdapter.init(JDBCSourceAdapter.java:815) at edu.internet2.middleware.subject.provider.SourceManager.loadSource(SourceManager.java:351) at edu.internet2.middleware.subject.provider.SourceManager.parseConfig(SourceManager.java:365) at edu.internet2.middleware.subject.provider.SourceManager.init(SourceManager.java:323) ... 11 more Caused by: edu.internet2.middleware.subject.SourceUnavailableException: dbTableOrView not defined, source: GrouperPersonRegistry at edu.internet2.middleware.subject.provider.JDBCSourceAdapter2.setupDataSource(JDBCSourceAdapter2.java:658) at edu.internet2.middleware.subject.provider.JDBCSourceAdapter.init(JDBCSourceAdapter.java:759) ... 14 more What am I missing in the subject.properties? I’m not using sources.xml. subjectApi.source.jdbc.id = GrouperPersonRegistry subjectApi.source.jdbc.name = Grouper Person Registry subjectApi.source.jdbc.types = person subjectApi.source.jdbc.adapterClass = edu.internet2.middleware.grouper.subj.GrouperJdbcSourceAdapter2 subjectApi.source.jdbc.param.jdbcConnectionProvider.value = edu.internet2.middleware.grouper.subj.GrouperJdbcConnectionProvider subjectApi.source.jdbc.param.identifierAttributes.value = LOGINID subjectApi.source.jdbc.param.subjectIdentfierAttribute0.value = EXTERNALSYSTEMID subjectApi.source.jdbc.param.emailAttributeName.value = USERPRINCIPALNAME subjectApi.source.jdbc.param.maxResults.value = 1000 subjectApi.source.jdbc.param.maxPageSize.value = 100 subjectApi.source.jdbc.param.maxActive.value = 16 subjectApi.source.jdbc.param.maxIdle.value = 16 subjectApi.source.jdbc.param.maxWait.value = -1 subjectApi.source.jdbc.param.dbDriver.value = oracle.jdbc.driver.OracleDriver subjectApi.source.jdbc.param.dbUrl.value = jdbc:oracle:thin:@grouper-db.wsu.edu:1521:MIM subjectApi.source.jdbc.param.dbUser.value = ServiceAccount subjectApi.source.jdbc.param.dbPwd.value = ****************** subjectApi.source.jdbc.param.SubjectID_AttributeType.value = EXTERNALSYSTEMID subjectApi.source.jdbc.param.Name_AttributeType.value = DISPLAYNAME subjectApi.source.jdbc.param.Description_AttributeType.value = DESCRIPTION subjectApi.source.jdbc.param.subjectVirtualAttribute_0_searchAttribute0.value = ${subject.name},${subjectUtils.defaultIfBlank(subject.getAttributeValue('DISPLAYNAME'), "")},${subjectUtils.defaultIfBlank(subject.getAttributeValue('LOGINID'),
"")},${subjectUtils.defaultIfBlank(subject.description, "")},${subjectUtils.defaultIfBlank(subject.getAttributeValue('USERPRINCIPALNAME'), "")} subjectApi.source.jdbc.param.sortAttribute0.value = EXTERNALSYSTEMID subjectApi.source.jdbc.param.sortAttribute1.value = LOGINID subjectApi.source.jdbc.param.searchAttribute0.value = searchAttribute0 subjectApi.source.jdbc.param.useInClauseForIdAndIdentifier.value = true subjectApi.source.jdbc.param.identifierAttributes.value = LOGINID subjectApi.source.jdbc.param.emailAttributeName.value = USERPRINCIPALNAME subjectApi.source.jdbc.param.subjectIdentifierAttribute0.value = LOGINID subjectApi.source.jdbc.search.searchSubject.param.inclause.value = s.subjectid = ? subjectApi.source.jdbc.search.searchSubjectByIdentifier.param.inclause.value = a.value = ? subjectApi.source.jdbc.internalAttributes = searchAttribute0 |
- [grouper-users] Grouper 2.4 problem in subject.properties, Guenther, Dean R., 10/12/2018
- [grouper-users] RE: Grouper 2.4 problem in subject.properties, Black, Carey M., 10/12/2018
- [grouper-users] Re: Grouper 2.4 problem in subject.properties, Guenther, Dean R., 10/12/2018
- [grouper-users] RE: Grouper 2.4 problem in subject.properties, Black, Carey M., 10/12/2018
Archive powered by MHonArc 2.6.19.