Forum OpenACS Development: Upgrading openacs 4-6-3 to 5-0-0 with Oracle 8.1.6 problems?

Hi I have run all the scripts to upgrade oacs4.6.3 that are in acs-kernel, service-contrat, acs-authentication and acs-lang. I also put the zzz-postload.tcl file in the tcl directory, but  when I try to login I get this errors:

[13/Sep/2004:10:54:36][8323.8201][-driver-] Notice: starting
[13/Sep/2004:10:54:36][8323.8201][-driver-] Notice: driver: accepting connections
[13/Sep/2004:10:55:28][8323.3076][-conn:upgrade::0] Notice: random: generating 1 seed
[13/Sep/2004:10:55:29][8323.3076][-conn:upgrade::0] Notice: wapUA_p: 0
[13/Sep/2004:10:55:29][8323.3076][-conn:upgrade::0] Warning: encoding: could not load:
[13/Sep/2004:10:55:29][8323.3076][-conn:upgrade::0] Error: lang::message::lookup: Key 'acs-subsite.Not_logged_in' does not ex
ist in en_US
[13/Sep/2004:10:55:29][8323.3076][-conn:upgrade::0] Error: lang::message::lookup: Key 'acs-subsite.Log_in_to_system' does not
exist in en_US
[13/Sep/2004:10:55:29][8323.3076][-conn:upgrade::0] Error: lang::message::lookup: Key 'acs-subsite.Log_In' does not exist in
[13/Sep/2004:10:55:29][8323.3076][-conn:upgrade::0] Error: GET http://mysite/?
referred by ""
site_node::get "must pass in either url or node_id"
    while executing
"error "site_node::get \"must pass in either url or node_id\"""
    (procedure "site_node::get" line 4)
    invoked from within
"site_node::get -node_id $node_id -url $url"
    (procedure "site_node::get_element" line 3)
    invoked from within
"site_node::get_element -url $acs_lang_url -element object_id"
    invoked from within
"permission::permission_p  -object_id [site_node::get_element -url $acs_lang_url -element object_id]  -privilege admin  -part
y_id [ad_conn untrusted_us..."
    invoked from within
"set lang_admin_p [permission::permission_p  -object_id [site_node::get_element -url $acs_lang_url -element object_id]  -priv
ilege admin  -party_id [ad..."
    ("uplevel" body line 85)
    invoked from within
"uplevel {
          # /www/master-default.tcl
# Set basic attributes and provide the logical defaults for variables that
# aren't provided by the slave..."
    (procedure "code::tcl::/openacs/www/blank-master" line 2)
    invoked from within
    invoked from within
"if { [file exists $__adp_stub.tcl] } {

      # ensure that data source preparation procedure exists and is up-to-date
      adp_init tcl $__adp_stub
    ("uplevel" body line 3)
    invoked from within
"uplevel {

    if { [file exists $__adp_stub.tcl] } {

      # ensure that data source preparation procedure exists and is up-to-date
      adp_init t..."
    (procedure "adp_prepare" line 2)
    invoked from within
"adp_prepare "
    (procedure "template::adp_parse" line 30)
    invoked from within
"template::adp_parse $__adp_master  [concat [list __adp_slave $__adp_output] [array get __adp_properties]]"
    (procedure "template::adp_parse" line 74)
    invoked from within
"template::adp_parse $__adp_master  [concat [list __adp_slave $__adp_output] [array get __adp_properties]]"
    (procedure "template::adp_parse" line 74)
    invoked from within
"template::adp_parse $__adp_master  [concat [list __adp_slave $__adp_output] [array get __adp_properties]]"
    (procedure "template::adp_parse" line 74)
    invoked from within
"template::adp_parse [file root [ad_conn file]] {}"
    (procedure "adp_parse_ad_conn_file" line 7)
    invoked from within
    ("uplevel" body line 2)
    invoked from within
"uplevel $code"
    invoked from within
"ad_try {
            } ad_script_abort val {
                # do nothing

Does anyone know what is the problem?

The message key lookup errors are the easy part: that's in the FAQ.

As for the other section, I'm not really sure what is going on. Does this happen when you hit the login page, or any page?

Hi Jade:

Thanks for answering. The second error happens when I try to watch the first page (just when I go to http://mysite:8000/, If I try to go for example to http://mysite:8000/doc in the url appears the register login part but I cant see the page, and when I see the error.log it has the same error.


O.K. after several attemps I could login and made the upgrade with Oracle 8i,
thanks to Matthew Counte and Andrew Grumet for the support and help.
Here are the steps that I took.

1. Untar the openacs-5.0.0 into a tmp directory

2. Create the directories etc and log in openacs-4.6.3/

3. Move the nsd.tcl file to etc/config.tcl

4. Copy the openacs-5.0.0 on top of your openacs-4.6.3 directory.
cp -r openacs-5.0.0/* openacs-4.6.3/

5. Rename the openacs-4.6.3 to openacs-5.0.0
mv openacs-4.6.3/ openacs-5.0.0

6. Modify the config.tcl to the new Installation parameters.

7. Copy this files in the directories
cp acs-lang-create.sql /openacs5/packages/acs-lang/sql/oracle/
cp zzz-postload.tcl /openacs5/tcl/

8. Run the following scripts in this order from sqlplus

@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6.3-4.6.4.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6.4-4.6.5.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6.5-4.6.6.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.7.2d-5.0d.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.7d-4.7.2d.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d-5.0d2.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d2-5.0d3.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d6-5.0d7.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d7-5.0d9.sql (ignore errors)
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d9-5.0d13.sql (ignore errors)
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0.0b1-5.0.0b2.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0.0b2-5.0.0b3.sql
@@ openacs-5.0.0/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0.0b3-5.0.0b4.sql

-- Upgrading Service Contracts
@@ openacs-5.0.0/packages/acs-service-contract/sql/oracle/upgrade/upgrade-4.5-4.5.1.sql
@@ openacs-5.0.0/packages/acs-service-contract/sql/oracle/upgrade/upgrade-4.5.1-4.6.sql
@@ openacs-5.0.0/packages/acs-service-contract/sql/oracle/upgrade/upgrade-4.7d2-4.7d3.sql
@@ openacs-5.0.0/packages/acs-service-contract/sql/oracle/upgrade/upgrade-4.7d3-5.0d1.sql

-- Load acs-authentication data model.
@@ openacs-5.0.0/packages/acs-authentication/sql/oracle/acs-authentication-create.sql

-- Load acs-lang data model.
@@ openacs-5.0.0/packages/acs-lang/sql/oracle/acs-lang-create.sql

9. run the acs package and body definition. acs.sql

10.Remove the following files:

rm openacs-5.0.0/packages/acs-lang/tcl/lang-procs*
rm openacs-5.0.0/packages/acs-lang/tcl/lang-init*
rm openacs-5.0.0/packages/acs-templating/tcl/0-procs.tcl
rm -fr openacs-5.0.0/packages/acs-templating/resources/lists
rm openacs-5.0.0/packages/acs-templating/tcl/list-procs.tcl
rm openacs-5.0.0/packages/acs-automated-testing/tcl/example-test-procs.tcl

11. Modify openacs-5.0.0/www/index.apd page:
- where the form name="login" definition is add the ;noquote to @form_vars@ to look like this @form_vars;noquote@

12. At the end of openacs-5.0.0/www/blank_master.tcl modify the set lang_admin_p to look like this

set lang_admin_p 1
#[permission::permission_p \
-object_id [site_node::get_element -url $acs_lang_url -element object_id] \
-privilege admin \
-party_id [ad_conn untrusted_user_id]] set toggle_translator_mode_url [export_vars -base "${acs_lang_url}admin/translator-mode-toggle" \
{ { return_url [ad_return_url] } }]

13. Restart the server

14. Login in.

15. Go to acs-admin/apm/package-install via URL

16. Check all the packages and services to upgrade, click next and then install all (ignore the errors messages)

17. Restart server

18. When its done go to site-map and add (at root level) the folder acs-lang

19. In that folder mount the service OpenACS Localization Utils

20. Kill the server

21. Change back the set lang_admin_p in blank_master.tcl to look like it was:

set lang_admin_p [permission::permission_p \
-object_id [site_node::get_element -url $acs_lang_url -element object_id] \
-privilege admin \
-party_id [ad_conn untrusted_user_id]] set toggle_translator_mode_url [export_vars -base "${acs_lang_url}admin/translator-mode-toggle" \
{ { return_url [ad_return_url] } }]

22. Remove the zzz-postload.tcl file from openacs-5.0.0/tcl

23. Restart the server, and you are done.

Download the steps text file here.
I hope this will be useful for someone else.
Thank you Miguel. I've added a link to this thread to the official documentation.
I forgot to remove one file, because if is not remove you cant login.

rm openacs5/packages/acs-templating/resources/forms/standard-lars.adp