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

Fri Jun 29 14:39:59 EDT 2012

Looks to me like you don't have pg_config installed or not in your $PATH. Since pg_config is used to find other variables (like $libdir)  I think that's the source of the following errors.

Cheers,
Justin

On Jun 29, 2012, at 9:54 AM, St-Jacques, Patrick wrote:

> 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
>  
>  
>  