Forum OpenACS Q&A: Problem installing data model

Collapse
1: Problem installing data model
Posted by Jamie Hill on 09/20/02 06:12 AM
I get to the "OpenACS Installation: Welcome" page, click NEXT and then it says "Installing OpenACS kernel data model..." but then stops. When I check the aolserver log it contains the following errors: 
[20/Sep/2002:09:17:51][1817.1024][-main-] Notice: nssock: listening 
on 
127.0.0.1:8000
[20/Sep/2002:09:17:51][1817.8201][-nssock-] Notice: nssock: starting
[20/Sep/2002:09:17:51][1817.8201][-nssock-] Notice: nssock: accepting 
connections
[20/Sep/2002:09:25:43][1817.3076][-conn0-] Debug: db_qd_get_fullname: 
following query in file: packages.acs-tcl.tcl.00-database-procs-
postgresql 
proc: db_table_exists
[20/Sep/2002:09:25:44][1817.3076][-conn0-] Debug: NO FULLQUERY FOR 
dbqd.acs-tcl.tcl.00-database-procs-
postgresql.db_table_exists.table_count 
--> using default SQL
[20/Sep/2002:09:25:44][1817.3076][-conn0-] Debug: PgBindCmd: sql =
        select count(*) from pg_class
        where relname = lower(:table_name) and
            relname !~ '^pg_' and relkind = 'r'

[20/Sep/2002:09:25:44][1817.3076][-conn0-] Debug: PgBindCmd: bind 
var: 
table_name = apm_packages
[20/Sep/2002:09:25:44][1817.3076][-conn0-] Debug: PgBindCmd: query 
with 
bind variables substituted = 
        select count(*) from pg_class
        where relname = lower('apm_packages') and
            relname !~ '^pg_' and relkind = 'r'
    
[20/Sep/2002:09:25:44][1817.3076][-conn0-] Notice: Querying '
        select count(*) from pg_class
        where relname = lower('apm_packages') and
            relname !~ '^pg_' and relkind = 'r';'
[20/Sep/2002:09:25:47][1817.3076][-conn0-] Notice: dbinit: 
sql(localhost::emotive): '
        select count(*) from pg_class
        where relname = lower('apm_packages') and
            relname !~ '^pg_' and relkind = 'r'
    '
[20/Sep/2002:09:25:55][1817.6151][-conn3-] Debug: db_qd_get_fullname: 
following query in file: packages.acs-tcl.tcl.00-database-procs-
postgresql 
proc: db_table_exists
[20/Sep/2002:09:25:57][1817.6151][-conn3-] Debug: NO FULLQUERY FOR 
dbqd.acs-tcl.tcl.00-database-procs-
postgresql.db_table_exists.table_count 
--> using default SQL
[20/Sep/2002:09:25:57][1817.6151][-conn3-] Debug: PgBindCmd: sql = 
        select count(*) from pg_class
        where relname = lower(:table_name) and
            relname !~ '^pg_' and relkind = 'r'
    
[20/Sep/2002:09:25:57][1817.6151][-conn3-] Debug: PgBindCmd: bind 
var: 
table_name = acs_objects
[20/Sep/2002:09:25:57][1817.6151][-conn3-] Debug: PgBindCmd: query 
with 
bind variables substituted = 
        select count(*) from pg_class
        where relname = lower('acs_objects') and
            relname !~ '^pg_' and relkind = 'r'
    
[20/Sep/2002:09:25:57][1817.6151][-conn3-] Notice: Querying '
        select count(*) from pg_class
        where relname = lower('acs_objects') and
            relname !~ '^pg_' and relkind = 'r';'
[20/Sep/2002:09:25:57][1817.6151][-conn3-] Notice: dbinit: 
sql(localhost::emotive): '
        select count(*) from pg_class
        where relname = lower('acs_objects') and
            relname !~ '^pg_' and relkind = 'r'
    '
[20/Sep/2002:09:26:00][1817.6151][-conn3-] Debug: db_qd_get_fullname: 
following query in file: 
acs-bootstrap-installer.installer.install-data-model proc: apm_source 
parameter1: 
/web/emotive/packages/acs-bootstrap-installer/installer/install-data-
model.tcl
[20/Sep/2002:09:26:00][1817.6151][-conn3-] Debug: NO FULLQUERY FOR 
dbqd.acs-bootstrap-installer.installer.install-data-
model.db_types_exists 
--> using default SQL
[20/Sep/2002:09:26:00][1817.6151][-conn3-] Debug: PgBindCmd: sql =
    select case when count(*) = 0 then 0 else 1 end from 
apm_package_db_types
[20/Sep/2002:09:26:00][1817.6151][-conn3-] Notice: Querying '
    select case when count(*) = 0 then 0 else 1 end from 
apm_package_db_types;'
[20/Sep/2002:09:26:00][1817.6151][-conn3-] Error: Ns_PgExec: result 
status: 7 message: ERROR:  Relation "apm_package_db_types" does not 
exist

[20/Sep/2002:09:26:00][1817.6151][-conn3-] Error: dbinit: 
error(localhost::emotive,ERROR:  Relation "apm_package_db_types" does 
not 
exist
): '
    select case when count(*) = 0 then 0 else 1 end from 
apm_package_db_types'
[20/Sep/2002:09:26:00][1817.6151][-conn3-] Error: Error sourcing 
/web/emotive/packages/acs-bootstrap-installer/installer/install-data-
model.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"
    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 db {
        set selection [db_exec 0or1row $db $full_name $sql]
    }"
    (procedure "db_string" line 7)
    invoked from within
"db_string db_types_exists "
    select case when count(*) = 0 then 0 else 1 end from 
apm_package_db_types""
    invoked from within
"set apm_db_types_exists [db_string db_types_exists "
    select case when count(*) = 0 then 0 else 1 end from 
apm_package_db_types"]"
    (file 
"/web/emotive/packages/acs-bootstrap-installer/installer/install-data-
model.tcl" 
line 40)
    invoked from within
"source $__file "

How can I fix this problem so it correctly installs the data model?

I am using Red Hat 7.3, AOLserver 3.3.1+ad13, PostgreSQL 7.2, OpenACS 4.6+dotLRN (from CVS).

Thanks,
Jamie Hill