[OPEN-ILS-DEV] permission table not created

[Bill Russell]

Hi Dan,

In ~/eg-srcs/Evergreen-ILS-1.2.0/Open-ILS/src/sql/Pg$, I created a new
script based upon build-db.sh that only executed the two
006.permission files.

I got the same errors I included in the original message.

The problem seems to be with this section of 006.schema.permissions.sql

CREATE OR REPLACE FUNCTION permission.grp_ancestors ( INT ) RETURNS
SETOF permission.grp_tree AS $$
   SELECT   a.*
   FROM  connectby('permission.grp_tree','parent','id','name',$1,'100','.')


connectby is undefined.  The functions public.connectby are shown in
the schema doc. but I did not see these in the functions listed for
the public table created by the build-db.sh script.

While looking at the schemas in the evergreen database, I noticed that
AUTHORIZATION user for public was postgres.  The schemas had an
AUTHORIZATION user of evergreen.  Does this suggest anything.

I've used psql to drop the evergreen database and will redo the step
19 actions.   Will I have to repeat any steps other than those in 19?

thanks for the help
bill

On Oct 30, 2007 9:58 PM, Dan Scott <denials at gmail.com> wrote:
>
> On 30/10/2007, Bill Russell <brussell.ls at gmail.com> wrote:
> > Hi all,
> >
> > Downloaded Evergreen version 1.2.0 and OpenSRF 0.9 and began the
> > installation routine on Ubuntu 7.10.
> >
> > After a redo caused by the mixed case host name issue, I used tkabber
> > to verify ejabber connectivity; used psql and pgAdmin III to test -h
> > postgresql connectivity before doing the database creation,
> >
> > The permission table did not get created during the install.
> > According to pgAdmin III, 14 tables did get created.  The Evergreen
> > schema document,
> > http://open-ils.org/documentation/evergreen_1.1.3_erd.html  , shows 15
> > tables.
> >
> > >From trying to add the Outreach and Trustee groups (step 25), I don't
> > believe the application is going to run without this table.  Yes, the
> > other configuration choice bring up data entry forms.
> >
> > So I looked around in the installation files, but did not find the
> > database creation script(s).  Can someone either send me the section
> > of the script that creates the permission table or the path and name
> > of the script that creates the table.
> >
> > Bill
> >
> > Here are the error messages that I captured:
> >
> > CREATE TABLE
> > psql:006.schema.permissions.sql :59: ERROR:  function
> > connectby("unknown", "unknown", "unknown", "unknown", integer,
> > "unknown", "unknown") does not exist
> > LINE 3:  FROM connectby('permission.grp_tree' ,'parent','id','name',$...
> >               ^
> > HINT:  No function matches the given name and argument types. You may
> > need to add explicit type casts.
> > psql:006.schema.permissions.sql:80: ERROR:  current transaction is
> > aborted, commands ignored until end of transaction block
> > psql:006.schema.permissions.sql:87: ERROR:  current transaction is
> > aborted, commands ignored until end of transaction block
> > psql:006.schema.permissions.sql :125: ERROR:  current transaction is
> > aborted, commands ignored until end of transaction block
> > psql:006.schema.permissions.sql:163: ERROR:  current transaction is
> > aborted, commands ignored until end of transaction block
> > psql:006.schema.permissions.sql:209: ERROR:  current transaction is
> > aborted, commands ignored until end of transaction block
> > psql:006.schema.permissions.sql:217: ERROR:  current transaction is
> > aborted, commands ignored until end of transaction block
> > ROLLBACK
> > Password:
> > psql:006.data.permissions.sql:1: ERROR:  schema "permission" does not
> exist
> > psql:006.data.permissions.sql:2: ERROR:  schema "permission" does not
> exist
> > psql:006.data.permissions.sql :3: ERROR:  schema "permission" does not
> exist
> > psql:006.data.permissions.sql:4: ERROR:  schema "permission" does not
> exist
> > psql:006.data.permissions.sql:5: ERROR:  schema "permission" does not
> exist
> > psql:006.data.permissions.sql:6: ERROR:  schema "permission" does not
> exist
> > psql:006.data.permissions.sql:7: ERROR:  schema "permission" does not
> exist
> >
>
> Hi Bill:
>
>  The missing "connectby" function means that your PostgreSQL install is
> missing the contributed "tablefunc" extension (part of step 19 in the Ubuntu
> 7.04 instructions).
>
> Make sure you've followed all of the sub-steps of step 19, then run:
>
> cd OpenILS/src/sql/Pg
> sh build-db.sh {db-host} {db-port} {db-name} {db-user} {db-password}
>
> (substituting the appropriate values for {db-host} etc).
>
> Good luck.
>
> --
> Dan Scott
>  Laurentian University