Forum .LRN Q&A: dotLRN 2.1.0 installation error.
I´m trying to install a test server for dotTeach and have run into a snag with the installer. I have traced it to a portion when it reports an error,
¨[09/Oct/2005:11:24:43][2494.3070303152][-conn:dotlrn::3] Error: Ns_PgExec: result status: 7 message: ERROR: relation "acs_function_args" does not exist¨.
I am using Fedora Core 4, PostreSQL 7.4.9 and Aolserver 4.0.10 with TCL 8.4.11. Here´s a portion of the error extracted:
[09/Oct/2005:11:24:43][2494.3070303152][-conn:dotlrn::3] Notice: apm_mount_core_packages: Starting mounting of core packages
[09/Oct/2005:11:24:43][2494.3070303152][-conn:dotlrn::3] Notice: apm_mount_core_packages: Mounting acs-lang
[09/Oct/2005:11:24:43][2494.3070303152][-conn:dotlrn::3] Error: Ns_PgExec: result status: 7 message: ERROR: relation "acs_function_args" does not exist
[09/Oct/2005:11:24:43][2494.3070303152][-conn:dotlrn::3] Error: Error sourcing /home/sjy/aolserver/servers/dotlrn/packages/acs-bootstrap-installer/installer/install.tcl:
Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")
ERROR: relation "acs_function_args" does not exist
SQL:
select arg_name, arg_default
from acs_function_args
where function = upper('site_node__new')
order by arg_seq
while executing
"ns_pg_bind select nsdb1 {
select arg_name, arg_default
from acs_function_args
where function = upper(:function_name)
order by ..."
("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 select $db $full_statement_name $sql"
invoked from within
"set selection [db_exec select $db $full_statement_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 select $db $full_statement_name $sql]
set result [list]
while { [db_get..."
(procedure "db_list_of_lists" line 9)
invoked from within
"db_list_of_lists get_function_args {}"
(procedure "plpgsql_utility::get_function_args" line 2)
invoked from within
"plpgsql_utility::get_function_args site_node__new"
("eval" body line 1)
invoked from within
"eval $script"
(procedure "util_memoize" line 1)
invoked from within
"util_memoize [list plpgsql_utility::get_function_args $function_name]"
(procedure "plpgsql_utility::generate_attribute_parameter_call" line 4)
invoked from within
"plpgsql_utility::generate_attribute_parameter_call \
-prepend ":" \
${package_name}__new \
$pieces"
invoked from within
"subst -nobackslashes \n\n\tselect\ \$\{package_name\}__new(\[plpgsql_utility::generate_attribute_parameter_call\ \\\n\t\t-prepend\ \":\"\ \\\n\t\t\$\{..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list subst -nobackslashes $sql]"
(procedure "db_exec" line 16)
invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
invoked from within
"if {[regexp -nocase -- {^\s*select} $test_sql match]} {
ns_log Debug "PLPGSQL: bypassed anon function"
set selection [..."
("uplevel" body line 6)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
# plsql calls that are simple selects bypass the plpgsql
# mechanism for creating anonymous fun..."
(procedure "db_exec_plsql" line 57)
invoked from within
"db_exec_plsql create_object {}"
(procedure "package_instantiate_object" line 111)
invoked from within
"package_instantiate_object -var_list $var_list site_node"
(procedure "site_node::new" line 5)
invoked from within
"site_node::new -name $node_name -parent_id $parent_node_id"
(procedure "site_node::instantiate_and_mount" line 20)
invoked from within
"site_node::instantiate_and_mount -package_key acs-lang"
(procedure "apm_mount_core_packages" line 6)
invoked from within
"apm_mount_core_packages"
(procedure "install_do_packages_install" line 48)
invoked from within
"install_do_packages_install"
(file "/home/sjy/aolserver/servers/dotlrn/packages/acs-bootstrap-installer/installer/install.tcl" line 52)
invoked from within
"source $__file "
[09/Oct/2005:11:24:43][2494.3069774768][-conn:dotlrn::4] Warning: tclfilter: install_handler return invalid result:
The installation always hang at this portion. I´m at wits end to find out what caused it. I even reformatted and use Fedora Core 3, but to no avail.
Sincerely,
Joe Shim
Are you sure you trying to install dotTeach (a tool for managing course information), not dotlrn (the learning management system)?
The package we called dotteach (the code was called weg-course-info until this week) was not ready to be released since it has too many Univ. of Sydney dependencies.
This package has nothing to do with dotLRN, the learning management system
I can't tell from your post what is you are trying to do
Rafael
Sorry about that. What i am doing is building another test server running dotLRN. The dotTeach part was to be later installed once i got dotLRN running. Unfortunately, the dotLRN installation would stop dead reporting a "Ns_PgExec, acs_function_args" error as reported in my log, and as such the installation was not completed. I can't seem to figure out what causes this errors and have re-installed and re-compiled numerous times in the previous week.
Right now, i'm using Fedora Core 3 (yum updated to the latest available kernel and others), AolServer 4.0.10, PostgreSQL 7.4.9 and TCL 8.4.11. I'm also using the nspostgres 4.0 plugin module.
Sincerely,
Joe
