Grouper Users - Open Discussion List

[Tom Barton <>]

Ooops! That we didn't get that dealt with before release is my fault - 
sorry!

Yes, do get a recent maven version and try to build it. That's likely 
the quickest way to proceed, and likely to succeed.

We'll get this dealt with soon for those who'd really rather not make 
heroic efforts...

Tom

Scott Koranda wrote:
> 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