Forum OpenACS Development: Re: postgresql 8.2 installation
any clues what can be generating that error?
i reboot the machine and restart openacs server.
at the browser o got the message:
OpenACS Installation: Welcome
Thank you for installing the Open Architecture Community System (OpenACS), a suite of fully-integrated enterprise-class solutions for collaborative commerce. This is the OpenACS Installer which performs all the steps necessary to get the OpenACS Community System running on your server.
Please read the Release Notes before proceeding to better understand what is contained in this release.
Your PostgreSQL driver is correctly installed and configured.
The OpenACS data model is already installed. Click Next to scan the available packages.
at errors.log i got:
[30/Nov/2007:04:22:56][20035.3083843264][-main-] Notice: Bootstrap: Installation is not complete - sourcing the installer.
[30/Nov/2007:04:22:56][20035.3083843264][-main-] Notice: Sourcing files for postload...
[30/Nov/2007:04:22:56][20035.3083843264][-main-] Notice: Done.
[30/Nov/2007:04:22:56][20035.3083843264][-main-] Notice: Executing initialization code blocks...
[30/Nov/2007:04:22:56][20035.3083843264][-main-] Notice: nsmain: AOLserver/4.5.0 running
[30/Nov/2007:04:22:56][20035.3083843264][-main-] Notice: nsmain: security info: uid=1002, euid=1002, gid=1001, egid=1001
[30/Nov/2007:04:22:56][20035.3073538992][-sched-] Notice: sched: starting
[30/Nov/2007:04:22:56][20035.3083843264][-main-] Notice: driver: starting: nssock
[30/Nov/2007:04:22:56][20035.3062524848][-nssock:driver-] Notice: starting
[30/Nov/2007:04:22:56][20035.3062524848][-nssock:driver-] Notice: nssock: listening on 192.168.1.15:8090
[30/Nov/2007:04:25:29][20035.3061173168][-conn:0-] Notice: exiting: timeout waiting for connection
any clues?
but at the browser i don't have the form anymore. only that message if a button that takes to a blank page
in order to turn around the problem i downloaded openacs-core-5.3.0 from openacs website and I ran the installation process again.
I followed pg-82 scripts:
http://www.openacs.org/xowiki/How_to_install_in_Postgres_8%2ex
then i got the followed error. the function was created at psql "dbname", but it seems it didn't succeed:
[30/Nov/2007:05:50:26][20206.3061529520][-conn:0-] Notice: --------------------------
[30/Nov/2007:05:50:26][20206.3061529520][-conn:0-] Notice: 0
[30/Nov/2007:05:50:26][20206.3061529520][-conn:0-] Notice: (1 row)
[30/Nov/2007:05:50:26][20206.3061529520][-conn:0-] Error: Error sourcing /usr/local/aolserver/servers/openacs/openacs/packages/acs-bootstrap-installer/installer/install.tcl:
psql:postgresql.sql:44: WARNING: nonstandard use of escape in a string literal
LINE 1: ...ion instr(varchar,char,integer,integer) returns integer as '
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
psql:postgresql.sql:142: WARNING: nonstandard use of escape in a string literal
LINE 1: ...unction get_func_drop_command (varchar) returns varchar as '
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
psql:postgresql.sql:172: WARNING: nonstandard use of \\ in a string literal
LINE 1: ...replace function drop_package (varchar) returns varchar as '
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
psql:postgresql.sql:172: WARNING: nonstandard use of \\ in a string literal
LINE 1: SELECT $1 || '\\_\\_' || '%'
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
QUERY: SELECT $1 || '\\_\\_' || '%'
CONTEXT: SQL statement in PL/PgSQL function "drop_package" near line 8
psql:postgresql.sql:201: WARNING: nonstandard use of escape in a string literal
LINE 1: ...reate or replace function number_src(text) returns text as '
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
psql:postgresql.sql:251: WARNING: nonstandard use of escape in a string literal
LINE 1: ...on get_func_definition (varchar,oidvector) returns text as '
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
psql:postgresql.sql:251: WARNING: nonstandard use of \' in a string literal
LINE 1: SELECT $1 || ') returns ' || $2 || ' as \'\n' || $3 |...
^
HINT: Use '' to write quotes in strings, or use the escape string syntax (E'...').
QUERY: SELECT $1 || ') returns ' || $2 || ' as \'\n' || $3 || '\' language \'plpgsql\';'
CONTEXT: SQL statement in PL/PgSQL function "get_func_definition" near line 44
psql:postgresql.sql:251: WARNING: nonstandard use of \' in a string literal
LINE 1: ... || ') returns ' || $2 || ' as \'\n' || $3 || '\' langua...
^
HINT: Use '' to write quotes in strings, or use the escape string syntax (E'...').
QUERY: SELECT $1 || ') returns ' || $2 || ' as \'\n' || $3 || '\' language \'plpgsql\';'
CONTEXT: SQL statement in PL/PgSQL function "get_func_definition" near line 44
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"
LINE 1: select acs_attribute_id_seq.nextval from dual
^
QUERY: select acs_attribute_id_seq.nextval from dual
CONTEXT: PL/pgSQL function "acs_attribute__create_attribute" line 28 at SQL statement
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', '#acs-kernel.Party#', '#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"
LINE 4: (acs_object_id_seq.nextval, 'membership_rel', 'group');
^
psql:groups-create.sql:457: ERROR: missing FROM-clause entry for table "acs_object_id_seq"
LINE 4: (acs_object_id_seq.nextval, 'composition_rel', 'group');
^
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', '#acs-kernel.lt_Relational_Party_Segm#', '#acs-kernel.lt_Relational_Party_Segm_1#', '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', '#acs-kernel.lt_Relational_Constraint#', '#acs-kernel.lt_Relational_Constraint_1#', '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"
LINE 1: select acs_attribute_id_seq.nextval from dual
^
QUERY: select acs_attribute_id_seq.nextval from dual
CONTEXT: PL/pgSQL function "acs_attribute__create_attribute" line 28 at SQL statement
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', '#acs-kernel.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"
LINE 1: select acs_object_id_seq.nextval from dual
^
QUERY: select acs_object_id_seq.nextval from dual
CONTEXT: PL/pgSQL function "acs_object__new" line 17 at SQL statement
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 "/usr/local/aolserver/servers/openacs/openacs/packages/acs-bootstrap-installer/installer/install.tcl" line 37)
invoked from within
"source $__file "
[30/Nov/2007:05:52:25][20206.3061529520][-conn:0-] Notice: exiting: timeout waiting for connection