Forum .LRN Q&A: Re: Upgrade OpenACS Debian 3.1 32 bits
Posted by
Érico Guimarães
on 04/11/13 08:34 PM
Legacy means in this context two services, separate in Servers: one with Debian 3.1 32 bit (know it is too old!!😟) with a modified dotlrn2.1 (basically on the theme) and its content-repository if possible; and another Server with Debian 6.0 32 bit running Postgresql 8.1, which I actually backed and pg_restored in a PostgreSQL 8.4.9 Debian AMD 64 bit environment test, where the application dotlrn dwells too. I saw no mistakes during data restoration.
I did two tests: one over the brand-new apt-get installed dotlrn and its dependencies environment, where I could reach admin front page, register myself and log in successfully.
The command ps -es reads as follows:
www-data 9894 1 0 15:00 ? 00:00:00 /usr/sbin/aolserver4-nsd -u www-data -g www-data -b 127.0.0.1:80 -s main -t /etc/aolserver4/aolserver4.tcl www-data 9906 1 2 15:01 ? 00:00:19 /usr/sbin/aolserver4-nsd -u www-data -g www-data -b 0.0.0.0:8000 -s dotlrn -t /etc/aolserver4/conf.d/dotlrn.tcl postgres 9918 8929 0 15:01 ? 00:00:01 postgres: www-data dotlrn [local] idle ....... www-data 10079 1 0 15:04 ? 00:00:01 /usr/sbin/aolserver4-nsd -u www-data -g www-data -b 0.0.0.0:8080 -s dotlrn -t /etc/aolserver4/conf.d/coptec.tcl postgres 10084 8929 0 15:04 ? 00:00:00 postgres: ....As you can see, I downloaded and installed dotlrn 2.5 and I can run it on X.X.X.X:8000/dotlrn successfully, with Zen theme. Ok?
Well, the second test I did was based on the link http://www.openacs.org/forums/message-view?message_id=243862 You have sent me before. In short, I copyed dotlrn.tcl to coptec.tcl, changed de database name for my old dotlrn application unico and port to 8080; everything on the new Debian AMD 64 bit server. From command line, I ran:
root@coptecvirtual:/usr/share/dotlrn# /usr/sbin/aolserver4-nsd -u www-data -g www-data -b 0.0.0.0:8080 -s dotlrn -t /etc/aolserver4/conf.d/coptec.tcl &
And ps -ef command reads as follows:
www-data 10079 1 0 15:04 ? 00:00:01 /usr/sbin/aolserver4-nsd -u www-data -g www-data -b 0.0.0.0:8080 -s dotlrn -t /etc/aolserver4/conf.d/coptec.tcl postgres 10084 8929 0 15:04 ? 00:00:00 postgres: www-data unico [local] idleI even managed to access host remotely, in order to access this new server Debian AMD64bit machine from my Ubuntu Desktop (actually this Debian 64bit resides virtually on my Desktop😊)
However,when I type on my browser http://X.X.X.X:8080/dotlrn this mistake, the following screen appears:
Request Error Server startup failed: Error during bootstrapping
Database operation "0or1row" failed
(exception ERROR, "ERRO: permissão negada para relação apm_package_versions
")
while executing
"ns_pg_bind 0or1row nsdb0 {
select 1 from apm_package_versions
where package_key = :package_key
and installed_p = 't'
}"
("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 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 -dbn $dbn db {
set selection [db_exec 0or1row $db $full_name $sql]
}"
(procedure "db_string" line 27)
invoked from within
"db_string apm_package_installed_p {} -default 0"
(procedure "apm_package_installed_p_not_cached" line 2)
invoked from within
"apm_package_installed_p_not_cached $package_key"
(procedure "apm_package_installed_p" line 5)
invoked from within
"apm_package_installed_p acs-kernel"
(procedure "ad_verify_install" line 8)
invoked from within
"ad_verify_install"
...
, which prevents me from reaching http://X.X.X.X:8080/acs-admin/apm/ (actually if i put on scratch acs-admin/apm after 8080, the same page appears) to start de upgrade process, as per instructions on that link mentioned aforesaid.
I think there is something I am still missing....
Bests Regards.
