Forum .LRN Q&A: Newbie OpenACS/dotLrn install error take02

It looks like installing the OpenACS kernel data model...

bombed. The error.log had this to report:

PL/pgSQL function "acs_objects_insert_tr" line 6 at assignment
SQL statement "insert into acs_objects (object_id, object_type, context_id, creation_date, creation_user, creation_ip) values ( $1 , $2 , $3 , $4 , $5 , $6 )"
PL/pgSQL function "acs_object__new" line 24 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:367: ERROR: function bit(integer) does not exist
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
CONTEXT: SQL statement "SELECT "bit"( $1 )"
PL/pgSQL function "bitfromint4" line 2 at return
PL/pgSQL function "int_to_tree_key" line 22 at return
PL/pgSQL function "acs_objects_insert_tr" line 6 at assignment
SQL statement "insert into acs_objects (object_id, object_type, context_id, creation_date, creation_user, creation_ip) values ( $1 , $2 , $3 , $4 , $5 , $6 )"
PL/pgSQL function "acs_object__new" line 24 at SQL statement
psql:acs-create.sql:372: 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".
CONTEXT: SQL statement "SELECT acs_object_id_seq.nextval from dual"
PL/pgSQL function "acs_object__new" line 13 at select into variables
PL/pgSQL function "authority__new" line 38 at assignment
psql:acs-create.sql:399: ERROR: function bit(integer) does not exist
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
CONTEXT: SQL statement "SELECT "bit"( $1 )"
PL/pgSQL function "bitfromint4" line 2 at return
PL/pgSQL function "int_to_tree_key" line 22 at return
PL/pgSQL function "acs_objects_insert_tr" line 6 at assignment
SQL statement "insert into acs_objects (object_id, object_type, context_id, creation_date, creation_user, creation_ip, security_inherit_p) valu es ( $1 , $2 , $3 , $4 , $5 , $6 , $7 )"
PL/pgSQL function "acs_object__new" line 25 at SQL statement
PL/pgSQL function "authority__new" line 38 at assignment
psql:acs-create-2.sql:17: ERROR: insert or update on table "acs_privilege_hierarchy" violates foreign key constraint "acs_priv_hier_priv_fk"
DETAIL: Key (privilege)=(admin) is not present in table "acs_privileges".
CONTEXT: SQL statement "insert into acs_privilege_hierarchy (privilege, child_privilege) values ( $1 , $2 )"
PL/pgSQL function "acs_privilege__add_child" line 5 at SQL statement

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/www/oacs-test/packages/acs-bootstrap-installer/installer/install.tcl" line 37)
invoked from within
"source $__file "
[27/Jan/2006:20:53:40][28481.114696][-conn:oacs-test::4] Warning: tclfilter: install_handler return invalid result:

Collapse
Posted by Dave Bauer on
It looks like you have PostgreSQL 8.x installed.

.LRN 2.1.x is based on Openacs 5.1

Check the compatbility matrix to see what versions of software will work together.

https://openacs.org/doc/openacs-5-1/individual-programs.html

Collapse
Posted by Al Guyer on
That was the problem, THANKS!!! the dotLrn site installed without a hicup and is running beautifully!

Thanks again,

-al