Forum OpenACS Q&A: ERROR: Relation "apm_package_db_types" does not exist

I am trying to install OpenAcs 4.6.3 on redhat 8.0

I followed the exact steps in the installation and also go the Welcome Page. When I hit next there it says - "Installing the OpenACS kernel data model..." and page is done.

The log page starts with error -
ERROR:  Relation "apm_package_db_types" does not exist

What am I doing wrong?

Thanks,
Kiran Halwai

-----------------------------------------

09/Jan/2004:18:00:02][18215.8192][-main-] Notice: sched: idle
[09/Jan/2004:18:00:02][18215.8192][-main-] Notice: nssock: listening on 10.14.25.109:8000
[09/Jan/2004:18:00:02][18215.65545][-nssock-] Notice: nssock: starting
[09/Jan/2004:18:00:02][18215.65545][-nssock-] Notice: nssock: accepting connections
[09/Jan/2004:18:00:09][18215.24580][-conn0-] Error: Ns_PgExec: result status: 7 message: ERROR:  Relation "apm_package_db_types" does not exist

[09/Jan/2004:18:00:09][18215.24580][-conn0-] Error: Error sourcing /web/ranwara/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/ranwara/packages/acs-bootstrap-installer/installer/install-data-model.tcl" line 40)
    invoked from within
"source $__file "
[09/Jan/2004:18:06:47][18215.32773][-conn1-] Error: Ns_PgExec: result status: 7 message: ERROR:  Relation "apm_package_db_types" does not exist

Vinh - are you trying to install 4.6.3 like the original poster, or something more recent?  Please tell us:

-openACS version (and how you got it - tarball or cvs?)
-database (and which version of it?)

changing to Postgres-7.4.1 has fixed this problem!

I traced it to installer.tcl in the bootstrap installer.
It seems that db_source_sql_file is not working.

Are there reasons why db_source_sql_file would not work ?

The database server seems to have been installed properly although I had to put --no-readline during ./configure because my test system doesn't have it.

Another hiccup was with TDOM where I compiled using GCC otherwise the install would complain about failed sanity checks as it used cpp.

Any help will be greatly appreciated.

Thanks in advance.

I kept getting this error and finally found that postgres was dying because is was statically linked with the wrong version of libreadline. Try running a psql (yourdatabasename) as the user that the web site is running as and see if you get any errors. If that goes well try loadin the kernel data model fount in the packages/acs-kernel/sql/postgresql/acs-kernel-create.sql file directly from the database.