Forum OpenACS Q&A: Re: Error: Unable to source /web/service0/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist.

Collapse
4: Re: Error: Unable to source /web/service0/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist. (response to 1)
Posted by Ratnakar Sagare on 02/06/07 04:39 PM
Hi,
I faced same error while installing OACS 5.3 with AOLserver 4.5 & Postgres 8.2. on SUSE 10.2
After checking the error.log file, I found some problem with ../packages/acs-bootstrap-installer/installer/install.tcl (Log output is below)
It would be great if somebody points out what's wrong with this ....

Thanks,

Ratnakar

(Please forgive me for such a long log )
-------------error.log while installation of Kernel Datamodel---------------------
[06/Feb/2007:20:44:59][11064.3069545360][-conn:0-] Notice: CREATE FUNCTION

[06/Feb/2007:20:44:59][11064.3069545360][-conn:0-] Notice: DROP FUNCTION

[06/Feb/2007:20:44:59][11064.3069545360][-conn:0-] Notice: acs_privilege__create_privilege

[06/Feb/2007:20:44:59][11064.3069545360][-conn:0-] Notice: ---------------------------------

[06/Feb/2007:20:44:59][11064.3069545360][-conn:0-] Notice: 0

[06/Feb/2007:20:44:59][11064.3069545360][-conn:0-] Notice: (1 row)

[06/Feb/2007:20:44:59][11064.3069545360][-conn:0-] Notice: acs_privilege__add_child

[06/Feb/2007:20:44:59][11064.3069545360][-conn:0-] Notice: --------------------------

[06/Feb/2007:20:44:59][11064.3069545360][-conn:0-] Notice: 0

[06/Feb/2007:20:44:59][11064.3069545360][-conn:0-] Notice: (1 row)

[06/Feb/2007:20:44:59][11064.3069545360][-conn:0-] Error: Error sourcing /var/lib/aolserver/service0/packages/acs-bootstrap-installer/installer/install.tcl:
psql:lob.sql:34: WARNING: changing return type of function on_lobs_delete from "opaque" to "trigger"
psql:acs-metadata-create.sql:85: WARNING: changing return type of function acs_object_type_insert_tr from "opaque" to "trigger"
psql:acs-metadata-create.sql:134: WARNING: changing return type of function acs_object_type_update_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:188: ERROR: missing FROM-clause entry for table "acs_attribute_id_seq"
CONTEXT: SQL statement "SELECT acs_attribute_id_seq.nextval from dual"
PL/pgSQL function "acs_attribute__create_attribute" line 28 at select into variables
PL/pgSQL function "inline_0" line 20 at assignment
psql:acs-objects-create.sql:254: WARNING: changing return type of function acs_objects_mod_ip_insert_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:269: WARNING: changing return type of function acs_objects_last_mod_update_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:307: WARNING: changing return type of function acs_objects_insert_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:355: WARNING: changing return type of function acs_objects_update_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:456: WARNING: changing return type of function acs_objects_context_id_in_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:528: WARNING: changing return type of function acs_objects_context_id_up_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:540: WARNING: changing return type of function acs_objects_context_id_del_tr from "opaque" to "trigger"
psql:acs-relationships-create.sql:308: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_rel_type__create_type" line 23 at perform
psql:acs-relationships-create.sql:446: WARNING: changing return type of function acs_rels_in_tr from "opaque" to "trigger"
psql:authentication-create.sql:92: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
psql:community-core-create.sql:237: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type ( 'party', 'Party', 'MESSAGE KEY MISSING: 'acs-kernel.Parties'', 'acs_object', 'parties', 'party_id', 'party', 'f', null, 'party__name' )"
PL/pgSQL function "inline_0" line 7 at perform
psql:community-core-create.sql:547: ERROR: insert or update on table "acs_object_type_tables" violates foreign key constraint "acs_obj_type_tbls_obj_type_fk"
DETAIL: Key (object_type)=(user) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_type_tables (object_type, table_name, id_column) values ('user', 'user_preferences', 'user_id')"
PL/pgSQL function "inline_1" line 3 at SQL statement
psql:groups-create.sql:158: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(party) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "inline_0" line 7 at assignment
psql:groups-create.sql:424: WARNING: changing return type of function membership_rels_in_tr from "opaque" to "trigger"
psql:groups-create.sql:439: WARNING: changing return type of function composition_rels_in_tr from "opaque" to "trigger"
psql:groups-create.sql:452: ERROR: missing FROM-clause entry for table "acs_object_id_seq"
psql:groups-create.sql:457: ERROR: missing FROM-clause entry for table "acs_object_id_seq"
psql:rel-segments-create.sql:42: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(party) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type ( 'rel_segment', 'Relational Party Segment', 'Relational Party Segments', 'party', 'rel_segments', 'segment_id', 'rel_segment', 'f', null, 'rel_segment__name' )"
PL/pgSQL function "inline_0" line 7 at perform
psql:rel-segments-create.sql:292: WARNING: changing return type of function parties_in_tr from "opaque" to "trigger"
psql:rel-segments-create.sql:306: WARNING: changing return type of function parties_del_tr from "opaque" to "trigger"
psql:rel-segments-create.sql:329: WARNING: changing return type of function rel_segments_in_tr from "opaque" to "trigger"
psql:rel-segments-create.sql:346: WARNING: changing return type of function rel_segments_del_tr from "opaque" to "trigger"
psql:rel-constraints-create.sql:39: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type ( 'rel_constraint', 'Relational Constraint', 'Relational Constraints', 'acs_object', 'rel_constraints', 'constraint_id', 'rel_constraint', 'f', null, null )"
PL/pgSQL function "inline_0" line 2 at perform
psql:rel-constraints-create.sql:540: WARNING: changing return type of function rel_constraints_ins_tr from "opaque" to "trigger"
psql:rel-constraints-create.sql:590: WARNING: changing return type of function rel_constraints_del_tr from "opaque" to "trigger"
psql:acs-permissions-create.sql:184: WARNING: changing return type of function acs_priv_hier_ins_del_tr from "opaque" to "trigger"
psql:acs-permissions-create.sql:198: WARNING: changing return type of function acs_priv_del_tr from "opaque" to "trigger"
psql:acs-permissions-create.sql:421: WARNING: changing return type of function acs_permissions_lock_tr from "opaque" to "trigger"
psql:groups-body-create.sql:86: WARNING: changing return type of function membership_rels_in_tr from "opaque" to "trigger"
psql:groups-body-create.sql:113: WARNING: changing return type of function membership_rels_up_tr from "opaque" to "trigger"
psql:groups-body-create.sql:141: WARNING: changing return type of function membership_rels_del_tr from "opaque" to "trigger"
psql:groups-body-create.sql:250: WARNING: changing return type of function composition_rels_in_tr from "opaque" to "trigger"
psql:groups-body-create.sql:350: WARNING: changing return type of function composition_rels_del_tr from "opaque" to "trigger"
psql:journal-create.sql:35: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type ( 'journal_entry', 'Journal Entry', 'Journal Entries', 'acs_object', 'journal_entries', 'journal_id', 'journal_entry', 'f', null, null )"
PL/pgSQL function "inline_0" line 2 at perform
psql:site-nodes-create.sql:30: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type ( 'site_node', 'Site Node', 'Site Nodes', 'acs_object', 'site_nodes', 'node_id', 'site_node', 'f', null, null )"
PL/pgSQL function "inline_0" line 4 at perform
psql:site-nodes-create.sql:99: WARNING: changing return type of function site_node_insert_tr from "opaque" to "trigger"
psql:site-nodes-create.sql:159: WARNING: changing return type of function site_node_update_tr from "opaque" to "trigger"
psql:apm-create.sql:97: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type ( 'apm_package', 'Package', 'Packages', 'acs_object', 'apm_packages', 'package_id', 'apm_package', 'f', 'apm_package_types', 'apm_package__name' )"
PL/pgSQL function "inline_0" line 3 at perform
psql:apm-create.sql:129: ERROR: missing FROM-clause entry for table "acs_attribute_id_seq"
CONTEXT: SQL statement "SELECT acs_attribute_id_seq.nextval from dual"
PL/pgSQL function "acs_attribute__create_attribute" line 28 at select into variables
PL/pgSQL function "inline_1" line 5 at assignment
psql:apm-create.sql:588: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "inline_2" line 4 at assignment
psql:apm-create.sql:884: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "inline_4" line 4 at assignment
psql:apm-create.sql:961: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "inline_5" line 4 at assignment
psql:apm-create.sql:1038: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(apm_package) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "inline_6" line 5 at assignment
psql:apm-create.sql:1068: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(apm_package) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "inline_7" line 5 at assignment
psql:acs-create.sql:213: ERROR: insert or update on table "acs_objects" violates foreign key constraint "acs_objects_object_type_fk"
DETAIL: Key (object_type)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_objects (object_id, object_type, title, package_id, context_id, creation_date, creation_user, creation_ip, security_inherit_p) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 )"
PL/pgSQL function "acs_object__new" line 40 at SQL statement
PL/pgSQL function "inline_0" line 5 at assignment
psql:acs-create.sql:315: ERROR: insert or update on table "acs_objects" violates foreign key constraint "acs_objects_object_type_fk"
DETAIL: Key (object_type)=(user) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_objects (object_id, object_type, title) values (0, 'user', 'Unregistered Visitor')"
PL/pgSQL function "inline_2" line 8 at SQL statement
psql:acs-create.sql:360: ERROR: insert or update on table "acs_objects" violates foreign key constraint "acs_objects_object_type_fk"
DETAIL: Key (object_type)=(group) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_objects (object_id, object_type, title, package_id, context_id, creation_date, creation_user, creation_ip, security_inherit_p) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 )"
PL/pgSQL function "acs_object__new" line 40 at SQL statement
PL/pgSQL function "party__new" line 12 at assignment
PL/pgSQL function "acs_group__new" line 16 at assignment
PL/pgSQL function "inline_3" line 8 at assignment
psql:acs-create.sql:372: ERROR: insert or update on table "acs_objects" violates foreign key constraint "acs_objects_object_type_fk"
DETAIL: Key (object_type)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "insert into acs_objects (object_id, object_type, title, package_id, context_id, creation_date, creation_user, creation_ip, security_inherit_p) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 )"
PL/pgSQL function "acs_object__new" line 40 at SQL statement
PL/pgSQL function "acs_object__new" line 10 at return
psql:acs-create.sql:377: ERROR: insert or update on table "acs_magic_objects" violates foreign key constraint "acs_magic_objects_object_id_fk"
DETAIL: Key (object_id)=(-3) is not present in table "acs_objects".
psql:acs-create.sql:404: ERROR: missing FROM-clause entry for table "acs_object_id_seq"
CONTEXT: SQL statement "SELECT acs_object_id_seq.nextval from dual"
PL/pgSQL function "acs_object__new" line 17 at select into variables
PL/pgSQL function "authority__new" line 38 at assignment

invoked from within
"db_source_sql_file -callback apm_ns_write_callback acs-kernel-create.sql"
(procedure "install_do_data_model_install" line 7)
invoked from within
"install_do_data_model_install"
invoked from within
"if { ![install_good_data_model_p] } {
install_do_data_model_install
} else {
ns_write "Kernel data model already installed."
# If kernel i..."
(file "/var/lib/aolserver/service0/packages/acs-bootstrap-installer/installer/install.tcl" line 37)
invoked from within
"source $__file "
-----------------------------------------------------

Collapse
5: Re: Error: Unable to source /web/service0/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist. (response to 4)
Posted by Vinod Kurup on 02/06/07 05:45 PM
Hi Ratnakar,

Installing on Postgres 8.1+ requires a few extra steps, mentioned here:

https://openacs.org/xowiki/How_to_install_in_Postgres_8%2ex

Vinod

Collapse
6: Re: Error: Unable to source /web/service0/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist. (response to 5)
Posted by Ratnakar Sagare on 02/07/07 02:38 PM
Hi Vinod,

Finally it worked !!!

There was an error with while configuring Postgres 8.2.1 first time & I foolishly ignored that.
This time I chose Postgres 8.1.4 and it worked like anything.

Thanks a lot for the help !!!

Ratnakar

Collapse
7: Re: Error: Unable to source /web/service0/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist. (response to 5)
Posted by Kurt S on 05/29/07 05:59 AM
I have done the above steps for my install of Postgres, but still get the same error.

PG: 8.2.4 ACS: 5.2.3

PL/pgSQL function "inline_2" line 54 at perform

invoked from within
"db_source_sql_file -callback apm_ns_write_callback acs-kernel-create.sql"
(procedure "install_do_data_model_install" line 7)
invoked from within
"install_do_data_model_install"
invoked from within
"if { ![install_good_data_model_p] } {
install_do_data_model_install
} else {
ns_write "Kernel data model already installed."
# If kernel i..."
(file "/var/lib/aolserver/aolacs/packages/acs-bootstrap-installer/installer/install.tcl" line 37)
invoked from within
"source $__file "
[28/May/2007:22:46:00][12816.3068345248][-conn:0-] Notice: exiting: timeout waiting for connection

Collapse
8: Re: Error: Unable to source /web/service0/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist. (response to 7)
Posted by Rick Yun on 07/28/07 08:48 AM
I'm also still getting the exact same error as Kurt after changing the compatibility flags.

Postgresql 8.2.14, AOLserver 4.5, ACS 5.3.2.

After much toil and several attempts at clean re-installs, I'm thinking about throwing in the towel with this combo and trying older packages.

I'm new to linux/openACS, so would rather spend my time learning the OpenACS features at this point. Any suggestions on whether this is going to be a simple fix, or a particular combo that works? It seems someone had luck with PG 8.1.4. How about you, Kurt?

Rick

Collapse
9: Re: Error: Unable to source /web/service0/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist. (response to 8)
Posted by Rick Yun on 07/28/07 10:44 PM
Success! Never mind my last post ... I did get everything to work with PG 8.1.8. I think that my earlier troubles may have been due to typo in my install.tcl file which I discovered, and not a compatibility issues after all.

Rick