Hi,
Yesterday I downloaded the latest openacs-4 from the CVS. I had a
quite old version (pre-beta, about a month ago) already installed with
postgres running on another server. I copied the newly downloaded
version 'in stead of' the old to my /web/xxxx directory and started
nsd. I got connected, but had a 'dead' 'Next ->' key. I then adopted
Vinod's openacl-4.tcl.txt file (from old_server, it didn't make it to
the new file-storage as well as his nice install description!). After
restarting nsd I still could get connected, but again with a dead next
key. I noticed here a problem with sysdate being unknown. So I search
for sysdate in both *.sql's and *.tcl's. Couldn't find any creations.
Then I tried a 'select sysdate;' in psql - not found. Then I tried a
'select sysdate from dual;' - great, I got the date. But this really
didn't help me.
Then I took the big step and started from scratch. Doing dropdb ..,
createdb .., createlang .. .., and then restarted nsd. Now I got a
page telling me I got PostgreSQL driver installed correctly (I think I
already had that in my previous attempts) and needed to install the
datamodel, great. Pushing 'Next ->' gave me the new page: Now
installing the ACS kernel data model... Good, but that's all nothing
happend. Looking in the log, I got:
[16/May/2001:13:51:22][2056.5125][-conn1-] Error: dbinit:
error(ljserv.local.leifjensen.com::leifjensen,ERROR: Relation
'apm_package_db_types' does not exist
): '
select case when count(*) = 0 then 0 else 1 end from
apm_package_db_types'
[16/May/2001:13:51:22][2056.5125][-conn1-] Error: Error sourcing
/web/leifjensen/packages/acs-bootstrap-installer/installer/install-data-model.tcl:
Database operation "0or1row" failed (exception NSDB, "Query was not a
statement returning rows.")
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 2 [list ns_pg_bind $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 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/leifjensen/packages/acs-bootstrap-installer/installer/install-data-model.tcl"
line 40)
invoked from within
"source $__file "
A d in psql gives me 'no relations found'.
Any ideas ?
