Forum OpenACS Q&A: Process hangs when loading data kernel model
Error log says about some problems in the ACS Bootstrap/Installer.
The error has something related to the install-data-model.tcl file. Cant figure out the problem.
Can some on plz help
Entry in the error.log file.
26/Feb/2003:13:05:23][1291.65545][-nssock-] Notice: nssock: starting
[26/Feb/2003:13:05:23][1291.65545][-nssock-] Notice: nssock: accepting
connections
[26/Feb/2003:13:05:30][1291.24580][-conn0-] Error: Ns_PgExec: result
status: 7 message: ERROR: Relation "apm_pa$
[26/Feb/2003:13:05:30][1291.24580][-conn0-] Error: Error sourcing
/usr/local/elearn/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 $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
"/usr/local/elearn/packages/acs-bootstrap-installer/installer/install-data-model.tcl" line
40)
invoked from within
"source $__file "
-----------------------
I am assuming you are ultimately headed to install dotLRN and following this documentation - https://openacs.org/projects/dotlrn/dotlrn-doc/dotlrn-installation ( which in turn will point you to OpenACS installation doc. at https://openacs.org/doc/openacs-4/unix-install.html upto you come to 'Download OpenACS' point on Install OpenACS 4.6 page ).
Do not downlload OpenACS tarball when you come to Install OpenACS 4.6 step. Basically, replace the first two bullets under 'Downloading OpenACS' heading with the following instructions
-----------------------------------------------
Create a directory called web inside your home directory. Checkout source code from OpenACS cvs. as per commands below.
joeuser:~$ mkdir -p web
joeuser:~$ chown joeuser.web web
joeuser:~$ cd web
joeuser:~/web$ cvs -d :pserver:mailto:anonymous@openacs.org:/cvsroot login
(just hit return for the password)
joeuser:~/web$ cvs -z3 -d :pserver:mailto:anonymous@openacs.org:/cvsroot checkout -r oacs-4-6 acs-core
joeuser:~/web$ cd ./openacs-4/packages
joeuser:~/web/openacs-4/packages$ cvs -z3 -d :pserver:mailto:anonymous@openacs.org:/cvsroot co -r oacs-4-6 \
acs-datetime acs-developer-support acs-events acs-mail-lite \
attachments bulk-mail calendar faq file-storage forums general-comments \
news notifications ref-timezones user-preferences
joeuser:~/web/openacs-4/packages$ cvs -z3 -d :pserver:mailto:anonymous@dotlrn.openforce.net:/dotlrn-cvsroot co -r dotlrn-1-0 dotlrn-core
joeuser:~/web/openacs-4/packages$ cd /web
joeuser:~/web$ chown -R joeuser.web openacs-4
joeuser:~/web$ chmod -R g+w openacs-4
-----------------------------------------------
and continue following instructions from the third bullet under 'Downloading OpenACS'" ( i.e. starting from 'You should now have openacs-4 directory tree...." ) upto you get the to the ' Congratulations, OpenACS 4.6 is now up and running! ' line, just above 'Keep AOLserver alive' section. Then jump to the lines below "Install dotLRN on your system" on the ttp://openacs.org/projects/dotlrn/dotlrn-doc/dotlrn-installation link.
Hope this works well for you. Within a couple of months, we should have much easier installation process.
