Forum OpenACS Development: Response to Problems installing OpenACS 4.x from scratch

Collapse
4: Response to Problems installing OpenACS 4.x from scratch (response to 1)
Posted by Leif Jensen on 05/16/01 10:52 PM
Yes, thanks it was psql not being able to find the database, which is on another machine. Setting various PGHOST, PGDATABASE, PGxxx fixed that.

  But, alas, it didn't quite finish 😟. After a lot of CREATE and single rows, I got 'Failed to install ACS kernel, version 4.2. ..'. TI have been running on a late PostgreSQL 7.1beta, so I installed the latest 7.1.1 and started all over. This didn't change anything and the log shows:

NOTICE:  identifier "__exec_2_apm_package_version_enable" will be truncated to "__exec_2_apm_package
_version_en"
[16/May/2001:20:38:37][4212.4101][-conn0-] Notice: dbinit: sql(ljserv.local.leifjensen.com::leifjens
en): 'create function __exec_2_apm_package_version_enable () returns varchar as '

        begin
          apm_package_version.enable(
            version_id => ''0''
          );
        end;

                      ' language 'plpgsql''
[16/May/2001:20:38:37][4212.4101][-conn0-] Notice: Querying 'select __exec_2_apm_package_version_ena
ble ();'
NOTICE:  identifier "__exec_2_apm_package_version_enable" will be truncated to "__exec_2_apm_package
_version_en"
[16/May/2001:20:38:37][4212.4101][-conn0-] Error: Ns_PgExec: result status: 7 message: ERROR:  parse
r: parse error at or near "apm_package_version"

[16/May/2001:20:38:37][4212.4101][-conn0-] Error: dbinit: error(ljserv.local.leifjensen.com::leifjen
sen,ERROR:  parser: parse error at or near "apm_package_version"
): 'select __exec_2_apm_package_version_enable ()'
[16/May/2001:20:38:37][4212.4101][-conn0-] Notice: Querying 'drop function __exec_2_apm_package_vers
ion_enable ();'
NOTICE:  identifier "__exec_2_apm_package_version_enable" will be truncated to "__exec_2_apm_package
_version_en"
[16/May/2001:20:38:37][4212.4101][-conn0-] Notice: dbinit: sql(ljserv.local.leifjensen.com::leifjens
en): 'drop function __exec_2_apm_package_version_enable ()'
[16/May/2001:20:38:37][4212.4101][-conn0-] Error: Error sourcing /web/leifjensen/packages/acs-bootst
rap-installer/installer/install-data-model.tcl:
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")
    while executing
"ns_db 0or1row $db "select $function_name ()""
    invoked from within
"db_exec_plpgsql $db $full_statement_name $sql  $statement_name"
    invoked from within
"if {[regexp -nocase -- {^s*select} $test_sql match]} {
            ns_log Notice "PLPGSQL: bypassed anon function"
            set selection [db_exec..."
    ("uplevel" body line 5)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle db {
        # plsql calls that are simple selects bypass the plpgsql
        # mechanism for creating anonymous functions (OpenACS - ..."
    (procedure "db_exec_plsql" line 13)
    invoked from within
"db_exec_plsql apm_package_version_enable {
        begin
          apm_package_version.enable(
            version_id => :version_id
          );
        end;
    }"
    (procedure "apm_version_enable" line 3)
    invoked from within
"apm_version_enable -callback apm_ns_write_callback [apm_package_install -callback apm_ns_write_call
back "[file join [acs_root_dir] packages acs-kernel..."
    (file "/web/leifjensen/packages/acs-bootstrap-installer/installer/install-data-model.tcl" line 6
3)
    invoked from within
"source $__file "

  Greetings,