Forum OpenACS Development: Has anyone installed HEAD on Postgresql 7.4.1?

Collapse
1: Has anyone installed HEAD on Postgresql 7.4.1?
Posted by Dave Bauer on 02/06/04 03:25 AM
I have been trying to install HEAD on postgresql 7.4.1, and I keep getting this error: 
[05/Feb/2004:21:03:44][1684.1091419376][-driver-] Notice: driver: accepting connections
[05/Feb/2004:21:03:51][1684.1091923184][-conn:oacs-5-head::0] Debug: NO FULLQUERY FOR dbqd.acs-tcl.tcl.00-database-procs.db_table_exists.table_count --> using default SQL
[05/Feb/2004:21:04:13][1684.1091923184][-conn:oacs-5-head::0] Debug: NO FULLQUERY FOR dbqd.acs-tcl.tcl.00-database-procs.db_table_exists.table_count --> using default SQL
[05/Feb/2004:21:04:13][1684.1091923184][-conn:oacs-5-head::0] Debug: NO FULLQUERY FOR dbqd.acs-bootstrap-installer.installer.install_do_data_model_install.db_types_exists --> using default SQL
[05/Feb/2004:21:04:13][1684.1091923184][-conn:oacs-5-head::0] Error: Ns_PgExec: result status: 7 message: ERROR:  relation "apm_package_db_types" does not exist
[05/Feb/2004:21:04:13][1684.1091923184][-conn:oacs-5-head::0] Error: Error sourcing /home/dave/develop/oacs-5-head/packages/acs-bootstrap-installer/installer/install.tcl:
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  relation "apm_package_db_types" does not exist

SQL: 
        select case when count(*) = 0 then 0 else 1 end from apm_package_db_types
    while executing
"ns_pg_bind 0or1row nsdb0 {
        select case when count(*) = 0 then 0 else 1 end from apm_package_db_types}"
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
    ("postgresql" arm line 2)
    invoked from within
"switch $driverkey {
                oracle {
                    return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
                }
       ..."
    invoked from within
"db_exec 0or1row $db $full_name $sql"
    invoked from within
"set selection [db_exec 0or1row $db $full_name $sql]"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle -dbn $dbn db {
        set selection [db_exec 0or1row $db $full_name $sql]
    }"
    (procedure "db_string" line 8)
    invoked from within
"db_string db_types_exists "
        select case when count(*) = 0 then 0 else 1 end from apm_package_db_types""
    (procedure "install_do_data_model_install" line 16)
    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 "/home/dave/develop/oacs-5-head/packages/acs-bootstrap-installer/installer/install.tcl" line 37)
    invoked from within
"source $__file "
After I click the Install button. It gets are far as "Installing ACS Kernel" then it quits.
Collapse
2: Re: Has anyone installed HEAD on Postgresql 7.4.1? (response to 1)
Posted by Vinod Kurup on 02/06/04 04:11 AM
Hey Dave,

I just tried a HEAD install on 7.4.1 and got an error further into my install. I get 2 errors on my attempt: 

[05/Feb/2004:21:57:40][14775.65541][-conn:openacs-4::1] Error: Error sourcing /home/vinod/web/openacs-4/packages/acs-tcl/tcl/site-nodes-init.tcl:
Selection did not return a value, and no default was provided
    while executing
"db_string get_root_node_id {}"
    (procedure "site_node::init_cache" line 2)
    invoked from within
"site_node::init_cache"
    (file "/home/vinod/web/openacs-4/packages/acs-tcl/tcl/site-nodes-init.tcl" line 11)
    invoked from within
"source $__file "
and then: 
[05/Feb/2004:21:58:08][14775.65541][-conn:openacs-4::1] Error: apm_package_install: Error installing Reference Data - Timezone version 5.0.0: psql:ref-timezones-create.sql:80: ERROR:  function acs_reference__new("unknown", "unknown", "unknown", "unknown", timestamptz) does not exist
HINT:  No function matches the given name and argument types. You may need to add explicit type casts.
Despite those errors, the installation succeeds and I'm able to login to my server.

I'm wondering if the code that you have is really HEAD. You mention seeing the phrase "Installing ACS Kernel", but my installation only displayed the phrases " Installing the OpenACS kernel data model..." and "Installing Kernel 5.1.0d1". Unless you were just paraphrasing 😊

Collapse
3: Re: Has anyone installed HEAD on Postgresql 7.4.1? (response to 2)
Posted by Mark Aufflick on 02/11/04 03:19 PM
Vinod, the problem you saw still indicates that the dependencies are not working - ref-timezone.info lists acs-reference as a required package, and yet it is not installed prior to attempting ref-timezone install.