Grouper Developers Forum

["Dr. Loris Bennett" <>]

On Fri, 2009-02-27 at 10:16 -0500, Chris Hyzer wrote:
> I tried this and it worked, but tried to add constraints that were
>  already there [another issue].  I can fix that.  Attached is the
>  script mine generated (and scrubbed) to add views.  If you run that
>  against your DB, you will have the views again.

Thanks, this worked fine.

> Regarding the IDs, I have an idea.  I think you might have multiple
>   schemas in one DB (or multiple something there) which have the same
>   table name.  Im not saying that is a bad thing, and it should be
>   supported by apache ddlutils, but maybe that is the problem. 
>  Attached  in gif is my postgres structure.  I have one DB, with a
>  schema named  "public", and one user which connects to it.  What is
>  your structure? Can you send me a screenshot like this with pgAdmin?  

Yes, I do have multiple schemata from different versions of Grouper (see
attachment), which all belong to the same DB user. When installing a new
version of Grouper, up to now I have usually saved copied of the old
schema. I should probably tidy up (= delete) most of this stuff and just
keep dumps as backup.

What would the preferred method of switching to a new version in a
production environment?

Loris

> Note, I am
>  running pgadmin on windows, and tunneling traffic through SSH to my
>  postgres linux box.  If this isn’t the problem, maybe I can give you a
>  small jdbc metadata program which can figure out the problem if I have
>  the stack that you emailed before.
> 
> Regards,
> Chris
> 
> Ps. Here is the bug about adding constraints not there:
> 
> https://bugs.internet2.edu/jira/browse/GRP-237
> 
> 
> 
> > -----Original Message-----
> > From: Dr. Loris Bennett 
> > [mailto:]
> > Sent: Friday, February 27, 2009 9:57 AM
> > To: Chris Hyzer
> > Cc: Grouper Dev Mailing List
> > Subject: RE: [grouper-dev] Creation of "common views" when DB is
> > initialised?
> > 
> > On Fri, 2009-02-27 at 09:37 -0500, Chris Hyzer wrote:
> > > When it says its up to date, it is just looking at what version is in
> > the grouper_ddl table, it isn’t actually checking the structure.
> > >
> > > If you do a:
> > >
> > > gsh.sh -registry -deep
> > 
> > This gives me the error
> > 
> >         Grouper ddl object type 'Grouper' has dbVersion: 0 and java
> >         version: 13
> >         org.apache.ddlutils.model.ModelException: There are multiple
> >         column with the name id in the table grouper_attributes
> > 
> > Didn't we have something like that before, due to some issue with
> > postgres?
> > 
> > > or:
> > >
> > > gsh.sh -registry -deep -runscript
> > >
> > > That will generate and/or run the script that will check all the
> > tables and cols and views and stuff.  It should recreate all your
> > views, though it is a probably a good idea in non-dev to run the first
> > one, and look at the script that will run (and potentially edit it if
> > there are problems).  :)  Let me know if there are issues.
> > >
> > > Regards,
> > > Chris
> > >
> > > > -----Original Message-----
> > > > From: Dr. Loris Bennett 
> > > > [mailto:]
> > > > Sent: Friday, February 27, 2009 9:28 AM
> > > > To: Chris Hyzer
> > > > Cc: Grouper Dev Mailing List
> > > > Subject: RE: [grouper-dev] Creation of "common views" when DB is
> > > > initialised?
> > > >
> > > > On Fri, 2009-02-27 at 08:46 -0500, Chris Hyzer wrote:
> > > > > 1. Have you looked at grouper_groups_v?  It might be too
> > heavyweight
> > > > for what you need
> > > >
> > > > Now, you mention it, I did have a look at that before. However, my
> > > > current DB doesn't contain any views at all. Backups of the DB for
> > > > previous Grouper version do, I now notice.
> > > >
> > > >         bin/gsh.sh -registry -check
> > > >
> > > > on the current, view-less DB says
> > > >
> > > >         database table/object structure (ddl) is up to date
> > > >
> > > > Did something not get initialised or did I just misclick somewhere
> > and
> > > > delete all the views?
> > > >
> > > > Cheers
> > > >
> > > > Loris
> > > >
> > > > > 2. In grouper 1.5, those cols are moving to the grouper_groups
> > table,
> > > > so the view might not be necessary
> > > > >
> > > > > But yes, we can add this or other views to core grouper if people
> > > > find them useful...  I already would like to see a better
> > lightweight
> > > > membership view:
> > > > >
> > > > > https://bugs.internet2.edu/jira/browse/GRP-231
> > > > >
> > > > > Chris
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: Dr. Loris Bennett 
> > > > > > [mailto:]
> > > > > > Sent: Friday, February 27, 2009 7:20 AM
> > > > > > To: Grouper Dev Mailing List
> > > > > > Subject: [grouper-dev] Creation of "common views" when DB is
> > > > > > initialised?
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > > I am just trying out some stuff with grouperloader and,
> > following
> > > > one
> > > > > > of
> > > > > > Chris' examples, using a view which provides me with id, name,
> > > > > > displayName, description for groups. Such a view seems to me to
> > be
> > > > so
> > > > > > useful that I feel it would be nice if it were created when the
> > > > grouper
> > > > > > DB is initialised.
> > > > > >
> > > > > > I am sure there may well be other canditates for "common
> > views".
> > > > > >
> > > > > > Thoughts?
> > > > > >
> > > > > > Loris
> > > > > >
> > > > > > --
> > > > > > Dr. Loris Bennett (Mr.)
> > > > > > Freie Universität Berlin
> > > > > > ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer
> > Center
> > > > > > Compute & Media Service
> > > > > > Fabeckstr. 32, Room 221
> > > > > > D-14195 Berlin
> > > > > > Tel ++49 30 838 51024
> > > > > > Fax ++49 30 838 56721
> > > > > > Email 
> > > > > > 
> > > > > > Web www.zedat.fu-berlin.de
> > > > >
> > > > --
> > > > Dr. Loris Bennett (Mr.)
> > > > Freie Universität Berlin
> > > > ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer Center
> > > > Compute & Media Service
> > > > Fabeckstr. 32, Room 221
> > > > D-14195 Berlin
> > > > Tel ++49 30 838 51024
> > > > Fax ++49 30 838 56721
> > > > Email 
> > > > 
> > > > Web www.zedat.fu-berlin.de
> > >
> > --
> > Dr. Loris Bennett (Mr.)
> > Freie Universität Berlin
> > ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer Center
> > Compute & Media Service
> > Fabeckstr. 32, Room 221
> > D-14195 Berlin
> > Tel ++49 30 838 51024
> > Fax ++49 30 838 56721
> > Email 
> > 
> > Web www.zedat.fu-berlin.de
> 
-- 
Dr. Loris Bennett (Mr.)
Freie Universität Berlin
ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer Center
Compute & Media Service
Fabeckstr. 32, Room 221
D-14195 Berlin
Tel ++49 30 838 51024
Fax ++49 30 838 56721
Email 

Web www.zedat.fu-berlin.de

Attachment: Screenshot-pgAdmin III.png
Description: PNG image