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

NOOB: The file aolserver is complaining about doesn't appear to be in cvs. Perhaps there is a slight of hand that I am missing, but when I do a...

cvs -d :pserver:mailto:anonymous@cvs.openacs.org:/cvsroot co -r oacs-5-3 openacs-4

and then look in...

[root@jester installer]# pwd
/home/public/download/openacs/openacs-4/packages/acs-bootstrap-installer/installer
[root@jester installer]# ls -l
total 40
drwxr-xr-x 2 root root 4096 Jan 31 14:12 CVS
-rw-r--r-- 1 root root 14694 Jun 3 2006 index.tcl
-rw-r--r-- 1 root root 4493 Jan 26 2005 install.tcl

the packages-install.tcl script doesn't exist.

AOLServer and PG are running fine. Got through the initial OpenACS install process, and the database was created, but when I bring up nsd-postgres and access the OpenACS package install page, the next button doesn't go anywhere. Mega Anti Climax.

I am conducting a compressed CMS server package evaluation of a bunch of platforms for a large educational concern, and my time/budget for OpenACS/dotlrn is just about expired. I have the feeling that I am really close, so if there is anyone out there in the community who can help me get over the hump, it would be greatly appreciated. It would be a shame to triage dotlrn simply because I'm too stupid to get it to install cleanly.

Thx in advance.

~jj

JJ, you must have missed some steps in the installation process.

You downloaded the files into /home/public/download/openacs/openacs-4 but they *should* reside in /web/service0. If you have a symlink, then all should be fine.

Furthermore, if you run into installation problems like these, there are a couple of options if you want to do an evaluation:

a) Get the windows version
b) test it on the test servers

It is really strange that you run into these problems, you must have missed one step in the installation instructions as I just did a rerun of my script at http://cognovis.de/developer/en/openacs_setup and it works like a charm. I made it more bullet proof, just copy paste.

What I learned is that I will definitely create a downloadable package with Postgres, AOLserver, OpenACS / .LRN with my install scripts. But that is something for the future, for now, just use the scripts provided :).

Collapse
Posted by Malte Sussdorff on
As we are getting questions and problems like Jester's all the time (and I am really thankful that he has the patience to stick around), I changed the link for "Unleash OpenACS" to the wiki with the installation instructions. After all, downloading does not help....

Furthermore, I made my scripts more bullet proof and put them in order for the impatient. They show up on top of the installation instructions, where you come to when you click on "Unleash OpenACS".

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

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

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

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

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

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