[OPEN-ILS-DEV] permission table not created

[Bill Russell]

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