[OPEN-ILS-DEV] permission table not created

[Dan Scott]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.georgialibraries.org/pipermail/open-ils-dev/attachments/20071030/d9c644ab/attachment.html