Grouper Users - Open Discussion List

[Jeff McCullough <>]

Okay. Onward. 

In the SQL loader groups, there are two possible SQL queries. One is about the subjects/groups and the other is for group naming/descriptions. It appears they need to access views in the same DB. Is that correct or is there a way to have them access separate DBs? There are two scenarios that are possible: 1) two completely SOR DBs, 2) one SOR and the grouper DB. Does either work?

Thank you,

Jeff

On Oct 11, 2016, at 12:05 PM, Hyzer, Chris <> wrote:

Not that I know of, I think you need to construct the description from attributes in LDAP…

 

From:  [] On Behalf Of Jeff McCullough
Sent: Tuesday, October 11, 2016 2:39 PM
To: Gouper Users List <>
Subject: Re: [grouper-users] grouperLoaderLdapGroupDescriptionExpression

 

I see I confused what was possible there. Let me take a slightly different tack. The LDAP loader puts some auto created text into the description for the groups it is managing. For most groups it is exactly what is needed. While I may need to switch to an SQL based loader group, is there a way to have the LDAP loader leave the description field as is?

 

Jeff

 

 

On Oct 11, 2016, at 11:15 AM, Hyzer, Chris <> wrote:

 

groupAttributes are attributes retrieved from ldap, does the attribute “description” exist in ldap, and are you retrieving it?

 

if you leave this part out does it blank out a manual description or something?  If so is there a description you can construct from LDAP attributes?

 

On sql based loader groups it’s the SQL group sql query there is a col for description

 

Thanks

Chris

 

From:  [] On Behalf Of Jeff McCullough
Sent: Tuesday, October 11, 2016 1:27 AM
To: Gouper Users List <>
Subject: [grouper-users] grouperLoaderLdapGroupDescriptionExpression

 

 

Two questions:

 

1) I’m trying to use grouperLoaderLdapGroupDescriptionExpression with an LDAP loader group. I did the LDAP loader setup using GSH. The only additional thing I’m adding, compared to other LDAP loader groups, is the groupDescriptionExpressionName so the description doesn’t change:

 

attributeAssign.getAttributeValueDelegate().assignValue(LoaderLdapUtils.grouperLoaderLdapGroupDescriptionExpressionName(), "${groupAttributes['description']}");

 

I get the following error when the job is run:

 

// Error: unable to evaluate command: Sourced file: inline evaluation of: ``loaderRunOneJob(group);'' : Error invoking compiled command: : Error in compiled command: java.lang.RuntimeException: edu.internet2.middleware.grouper.exception.ExpressionLanguageMissingVariableException: variable 'groupAttributes' is not defined in script: 'groupAttributes['description’]'

Any ideas?

2) Is there a similar attribute for SQL based loader groups?

Thank you,

Jeff