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

[David Busby]

Patrick,
  Also, pg_config is in the:
  postgresql-devel RPM for Redhat
  postgresql-common on Debian/Ubuntu
  dev-db/postgresql-base on Gentoo

--
David Busby
Edoceo, Inc.
http://edoceo.com/
206.282.6500


On Fri, Jun 29, 2012 at 11:39 AM, Justin Hopkins
<justin at mobiusconsortium.org> wrote:
> 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
>>
>>
>>
>