[OPEN-ILS-GENERAL] error running perl perl Open-ILS/src/support-scripts/eg_db_config.pl

Fri Jun 29 10:54:37 EDT 2012

So  I am new to evergreen, I am trying to install it on a Red Hat Enterprise Linux Server release 6.2  server
and I am at the createdatabase step (step 9)

I ran the followign command

perl ./Open-ILS/src/support-scripts/eg_db_config.pl --update-config --service all --create-schema --create-offline --user evergreen --password evergreen1 --hostname localhost --port 5432 --database evergreen --admin-user egadmin --admin-pass egadmin1 1>/home/pxs125/perl_eg.log 2>&1

and I got many errors any help would be appreciated

here are the errors I got :

Can't exec "pg_config": No such file or directory at ./Open-ILS/src/support-scripts/eg_db_config.pl line 263.
Use of uninitialized value $temp[0] in scalar chomp at ./Open-ILS/src/support-scripts/eg_db_config.pl line 264.
Backed up original configuration file to '/disk/apps/openils/Evergreen-ILS-2.2.0/conf/opensrf.xml.2012.6.29.10.33.19'
********************************************************************************
* There is no configuration for full text search config, for the database      *
* version you have installed (92).  If you're not really sure why, you should  *
* proabably press 'Control-C' now, and abort.  To continue using the latest    *
* available version (91), press enter. For assistance, please email            *
* open-ils-general at list.georgialibraries.org or join #Evergreen on the         *
* freenode IRC network.                                                        *
********************************************************************************
DROP SCHEMA
BEGIN
CREATE SCHEMA
psql:000.functions.general.sql:14: ERROR:  could not access file "$libdir/plpgsql": No such file or directory
psql:000.functions.general.sql:16: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:000.functions.general.sql:18: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:000.functions.general.sql:22: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:000.functions.general.sql:29: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:000.functions.general.sql:34: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:000.functions.general.sql:37: ERROR:  current transaction is aborted, commands ignored until end of transaction block
ROLLBACK
BEGIN
SET
psql:000.english.pg91.fts-config.sql:28: ERROR:  could not access file "$libdir/plpgsql": No such file or directory
psql:000.english.pg91.fts-config.sql:30: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:000.english.pg91.fts-config.sql:32: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:000.english.pg91.fts-config.sql:33: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:000.english.pg91.fts-config.sql:35: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:000.english.pg91.fts-config.sql:36: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:000.english.pg91.fts-config.sql:37: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:000.english.pg91.fts-config.sql:38: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:000.english.pg91.fts-config.sql:39: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:000.english.pg91.fts-config.sql:40: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:000.english.pg91.fts-config.sql:41: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:000.english.pg91.fts-config.sql:42: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:000.english.pg91.fts-config.sql:43: ERROR:  current transaction is aborted, commands ignored until end of transaction block
ROLLBACK
DETAIL:  drop cascades to table offline.script
DROP SCHEMA
BEGIN
CREATE SCHEMA
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
COMMIT
DROP SCHEMA
DROP SCHEMA
BEGIN
CREATE SCHEMA
CREATE SCHEMA
COMMENT
CREATE TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
CREATE TABLE
psql:002.schema.config.sql:80: ERROR:  schema "evergreen" does not exist
psql:002.schema.config.sql:84: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.schema.config.sql:88: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.schema.config.sql:90: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.schema.config.sql:91: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.schema.config.sql:99: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.schema.config.sql:107: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.schema.config.sql:112: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.schema.config.sql:120: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.schema.config.sql:129: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.schema.config.sql:136: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.schema.config.sql:144: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.schema.config.sql:155: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.schema.config.sql:167: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.schema.config.sql:174: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.schema.config.sql:190: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.schema.config.sql:198: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.schema.config.sql:956: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.schema.config.sql:968: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.schema.config.sql:971: ERROR:  current transaction is aborted, commands ignored until end of transaction block
ROLLBACK
BEGIN
DROP AGGREGATE
DROP AGGREGATE
DROP AGGREGATE
DROP AGGREGATE
CREATE AGGREGATE
CREATE FUNCTION
CREATE AGGREGATE
CREATE FUNCTION
CREATE AGGREGATE
CREATE FUNCTION
CREATE AGGREGATE
COMMIT
BEGIN
psql:002.functions.config.sql:230: ERROR:  could not access file "$libdir/plpgsql": No such file or directory
psql:002.functions.config.sql:232: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:233: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:246: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:250: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:254: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:258: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:320: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:347: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:351: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:393: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:399: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:403: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:410: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:420: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:483: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:488: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:617: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:621: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:636: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:700: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:002.functions.config.sql:766: ERROR:  current transaction is aborted, commands ignored until end of transaction block
ROLLBACK
BEGIN
DETAIL:  drop cascades to table query.stored_query
drop cascades to table query.query_sequence
drop cascades to table query.datatype
drop cascades to table query.subfield
drop cascades to table query.function_sig
drop cascades to table query.function_param_def
drop cascades to table query.bind_variable
drop cascades to table query.expression
drop cascades to table query.case_branch
drop cascades to table query.from_relation
drop cascades to table query.record_column
drop cascades to table query.select_item
drop cascades to table query.order_by_item
drop cascades to view query.expr_xbet
drop cascades to view query.expr_xbind
drop cascades to view query.expr_xbool
drop cascades to view query.expr_xcase
drop cascades to view query.expr_xcast
drop cascades to view query.expr_xcol
drop cascades to view query.expr_xex
drop cascades to view query.expr_xfunc
drop cascades to view query.expr_xin
drop cascades to view query.expr_xisnull
drop cascades to view query.expr_xnull
drop cascades to view query.expr_xnum
drop cascades to view query.expr_xop
drop cascades to view query.expr_xser
drop cascades to view query.expr_xstr
drop cascades to view query.expr_xsubq
DROP SCHEMA
CREATE SCHEMA
COMMENT
CREATE TABLE
CREATE TABLE
CREATE TABLE
Setval
--------
   1000
(1 row)

CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE INDEX
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
CREATE TABLE
CREATE TABLE
CREATE INDEX
ALTER TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE VIEW
CREATE RULE
CREATE RULE
CREATE RULE
CREATE VIEW
CREATE RULE
CREATE RULE
CREATE RULE
CREATE VIEW
CREATE RULE
CREATE RULE
CREATE RULE
CREATE VIEW
CREATE RULE
CREATE RULE
CREATE RULE
CREATE VIEW
CREATE RULE......
psql:011.schema.authority.sql:60: ERROR:  schema "config" does not exist
psql:011.schema.authority.sql:66: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:81: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:82: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:83: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:84: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:85: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:86: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:87: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:93: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:94: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:95: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:105: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:106: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:107: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:108: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:116: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:117: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:128: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:129: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:130: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:131: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:132: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:135: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:137: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:139: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:141: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:143: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:227: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:236: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:239: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:241: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:242: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:243: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:317: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:321: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:325: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:011.schema.authority.sql:332: ERROR:  current transaction is aborted, commands ignored until end of transaction block
DETAIL:  drop cascades to table staging.user_stage
drop cascades to table staging.card_stage
drop cascades to table staging.mailing_address_stage
drop cascades to table staging.billing_address_stage
drop cascades to table staging.statcat_stage
DROP SCHEMA
BEGIN
CREATE SCHEMA
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
COMMIT
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
psql:020.schema.functions.sql:58: ERROR:  language "plperlu" does not exist
HINT:  Use CREATE LANGUAGE to load the language into the database.
psql:020.schema.functions.sql:62: ERROR:  language "plperlu" does not exist
HINT:  Use CREATE LANGUAGE to load the language into the database.
psql:020.schema.functions.sql:71: ERROR:  language "plperlu" does not exist
HINT:  Use CREATE LANGUAGE to load the language into the database.
psql:020.schema.functions.sql:80: ERROR:  language "plperlu" does not exist
HINT:  Use CREATE LANGUAGE to load the language into the database.
psql:020.schema.functions.sql:92: ERROR:  language "plperlu" does not exist
HINT:  Use CREATE LANGUAGE to load the language into the database.
psql:950.data.seed-values.sql:7: ERROR:  schema "config" does not exist
LINE 1: INSERT INTO config.bib_source (id, quality, source, transcen...
                    ^
psql:950.data.seed-values.sql:8: ERROR:  schema "config" does not exist
psql:950.data.seed-values.sql:15: ERROR:  schema "biblio" does not exist
LINE 1: INSERT INTO biblio.peer_type (id,name) VALUES
                    ^
psql:950.data.seed-values.sql:16: ERROR:  schema "biblio" does not exist
psql:950.data.seed-values.sql:18: ERROR:  schema "config" does not exist
LINE 1: INSERT INTO config.standing (id, value) VALUES (1, oils_i18n...
                    ^
psql:950.data.seed-values.sql:19: ERROR:  schema "config" does not exist
LINE 1: INSERT INTO config.standing (id, value) VALUES (2, oils_i18n...
                    ^
psql:950.data.seed-values.sql:20: ERROR:  schema "config" does not exist
psql:950.data.seed-values.sql:23: ERROR:  schema "config" does not exist
LINE 1: INSERT INTO config.standing_penalty (id,name,label,block_lis...
                    ^
psql:950.data.seed-values.sql:25: ERROR:  schema "config" does not exist
LINE 1: INSERT INTO config.standing_penalty (id,name,label,block_lis...
                    ^
psql:950.data.seed-values.sql:27: ERROR:  schema "config" does not exist
LINE 1: INSERT INTO config.standing_penalty (id,name,label,block_lis...
                    ^
psql:950.data.seed-values.sql:29: ERROR:  schema "config" does not exist
LINE 1: INSERT INTO config.standing_penalty (id,name,label,block_lis...
                    ^
psql:950.data.seed-values.sql:31: ERROR:  schema "config" does not exist
LINE 1: INSERT INTO config.standing_penalty (id,name,label,staff_ale...

DBD::Pg::st execute failed: ERROR:  schema "actor" does not exist
LINE 1: UPDATE actor.usr SET usrname = $1, passwd = $2 WHERE id = 1
               ^ at ./Open-ILS/src/support-scripts/eg_db_config.pl line 202.
Failed to set admin account. Error was ERROR:  schema "actor" does not exist
LINE 1: UPDATE actor.usr SET usrname = $1, passwd = $2 WHERE id = 1
               ^
Writing offline database configuration to /disk/apps/openils/Evergreen-ILS-2.2.0/conf/offline-config.pl


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20120629/cc0bb19b/attachment-0001.htm>