Grouper Users - Open Discussion List

[Scott Koranda <>]

Hi,

> Yes, sorry, ldappc is not compatible with grouper 1.4.0.

Ah. That is unfortunate for me.

I would recommend adding a note about the incomaptibility to
the top of the page at

https://wiki.internet2.edu/confluence/display/GrouperWG/Grouper+Product

I must not understand the usual use case scenarios for
Grouper. 

Are there organizations that use Grouper without reflecting
the group membership into an LDAP? If so, what tools are used
to query Grouper for the membership information? Are they all
"once off" tools developed for use with a particular
organization?

I had understood that "everyone" used Grouper with ldappc so that
standard LDAP clients could leverage the group membership
information to make authorization decisions. This is not the
case?

> I did change ldappc to use grouper1.4 in branch: 
> ldappc_branch_grouper_1_4_20081204

I see it in the CVS. Thanks.

> Though Im not setup with maven to build it yet...

Which version of Maven would you recommend if I want to check
this out of CVS myself and try to get it to build?

We had hoped to have Grouper + ldappc in production by the end
of the week, so I am prepared to invest the time.

Thanks,

Scott

> 
> As to when there will be a distribution of ldappc, I think the answer is 
> hopefully soon...  Tom B and Tom Z, can you comment?
> 
> Chris
> 
> > -----Original Message-----
> > From: Scott Koranda 
> > [mailto:]
> > Sent: Tuesday, January 13, 2009 1:03 PM
> > To: 
> > 
> > Subject: Re: [grouper-users] error using ldappc 1.1.1 with Grouper
> > 1.4.0
> >
> > > Hi,
> > >
> > > I am using version 1.1.1 of ldappc with Grouper API 1.4.0 and
> > > I am seeing this error:
> > >
> > > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> > Unknown column 'hib3groupd0_.uuid' in 'field list'
> > >
> > > I am using a copy of grouper.hibernate.properties that appears
> > > to work fine with the API when driven via gsh, the UI, or via
> > > web services.
> > >
> > > I am using mysql-connector-java-5.1.7-bin.jar.
> > >
> > > Any ideas?
> > >
> >
> > I edited the grouper.hibernate.properties file being used by
> > ldappc and set
> >
> > hibernate.show_sql                    = true
> >
> > So this is the SQL that ldappc is calling and which is
> > failing:
> >
> > select hib3groupd0_.id as id3_, hib3groupd0_.uuid as uuid3_,
> > hib3groupd0_.parent_stem as parent3_3_,
> > hib3groupd0_.creator_id as creator4_3_,
> > hib3groupd0_.create_time as create5_3_,
> > hib3groupd0_.modifier_id as modifier6_3_,
> > hib3groupd0_.modify_time as modify7_3_,
> > hib3groupd0_.create_source as create8_3_,
> > hib3groupd0_.modify_source as modify9_3_ from grouper_groups
> > hib3groupd0_ where hib3groupd0_.uuid=?
> >
> > Looking at the grouper_groups table in MySQL I see this:
> >
> > mysql> describe grouper_groups;
> > +--------------------------+--------------+------+-----+---------+-----
> > --+
> > | Field                    | Type         | Null | Key | Default |
> > Extra |
> > +--------------------------+--------------+------+-----+---------+-----
> > --+
> > | id                       | varchar(128) | NO   | PRI | |       |
> > | parent_stem              | varchar(128) | NO   | MUL | |       |
> > | creator_id               | varchar(128) | NO   | MUL | |       |
> > | create_time              | bigint(20)   | NO   | MUL | |       |
> > | modifier_id              | varchar(128) | YES  | MUL | NULL |       |
> > | modify_time              | bigint(20)   | YES  | MUL | NULL |       |
> > | hibernate_version_number | bigint(20)   | YES  |     | NULL |       |
> > +--------------------------+--------------+------+-----+---------+-----
> > --+
> > 7 rows in set (0.03 sec)
> >
> > Obviously there are columns in the SQL query that do not
> > appear in the table definition.
> >
> > Is ldappc 1.1.1 not compatible with Grouper 1.4.0?
> >
> > If not, when is a version of ldappc expected that will be
> > compatible?
> >
> > Thanks,
> >
> > Scott