06 from 2.4.2 to 2.5.0

Added by Jim Helwig, last edited by Andrew Petro on Apr 26, 2007  (view change)
Table of Contents

The following information can be used to upgrade from uPortal 2.4.2 to uPortal 2.5.0.

Note: As of 8/12/05, these have only been used at the University of Wisconsin-Madison in non-production environments and at Texas Tech University in production enviornments. Please update this comment when these procedures have been vetted by another instituition.

Special thanks to Eric Dalquist and Mike Vavrus for major contributions to this information.

Possible Issues

  • Any code IMPLEMENTING DOM2 interfaces may need to be upgraded to implement the DOM3 version of the interface.
  • The JSR-168 Portlet specification states that forms submitted using GET are not supported. Prior to uPortal 2.5 GET based form submission was supported due to the way portlet parameters were encoded in the URL. GET based form submission is no longer supported due to moving the portlet parameters out of the custom encoding and into standard URL parameters. Observed behavior of forms submitted using GET: If an action URL is used processAction will never be called; parameters programmatically added to the PortletUrl object will not be available in the processAction or render method.

General Upgrade Tasks

  • JDK1.4 is now the minimum compatible JDK version
  • Stop Tomcat
  • Delete $CATALINA_HOME/conf/Catalina/localhost/uPortal.xml
  • Run the 'clean' target for the uPortal project (e.g., sudo -u uportal ant clean)
  • Run the JAXP-Install target (if using JDK 1.4) and check the $JAVA_HOME/jre/lib/endorsed and $TOMCAT_HOME/common/endorsed directories and ensure they contain exact copies of the libraries in uPortal/lib/jaxp
  • Any code relying on Spring needs to be re-compiled and re-deployed as the spring version has been changed to 1.2
  • Any code implementing DOM2 interfaces may need to be updated to support DOM3 which is now required JVM wide.
  • For SunOS Only (and possibly Linux)
    • Remove xalan.jar from JAVA_HOME/jre/lib/endorsed
    • Copy uPortal/lib/xalan-2-6-0.jar to JAVA_HOME/jre/lib/endorsed
    • Add '-Djava.endorsed.dirs=$JAVA_HOME/jre/lib/endorsed/' to the JAVA_OPTS of the tomcat start and stop scripts

Suggested Upgrade Path (for PC development environments)

Due to the extensive nature of the changes in the merge with 2.5.0 it is recomended that the local code base be replaced instead of trying to do standard update or merge. The new version should be deployed to a clean install of tomcat.

  • Run initportal to update the database tables and deployed content.

In-Place Upgrade Procedures (for shared environments)

For a deployed environment that needs to be upgraded instead of re-initialzed use the following steps.

  • Run the 'deploy' target for the uPortal project
  • Run the 'db-stats' target for the uPortal project
  • Update the databse using the SQL below

The following SQL needs to be run to upgrade the database (from version 2.4.2 to version 2.5.0). Please make a backup of the original database before proceding with these modifications.

Database upgrade script
create table tmp_up_fragment_restrictions as
select fragment_id,
          node_id,
decode(restriction_type,1,'priority',2,'depth',6,'immutable',8,'immutable') restriction_name,
   restriction_value,
          restriction_tree_path
from up_fragment_restrictions;

alter table tmp_up_fragment_restrictions modify restriction_name varchar2(128);

create table bak_up_fragment_restrictions as select * from up_fragment_restrictions;

drop table up_fragment_restrictions cascade constraints;

alter table tmp_up_fragment_restrictions rename to up_fragment_restrictions;

alter table up_fragment_restrictions add primary key (FRAGMENT_ID, NODE_ID, RESTRICTION_NAME, RESTRICTION_TREE_PATH);


create table tmp_up_layout_restrictions as
select layout_id,
     user_id,
    node_id,
decode(restriction_type,1,'priority',2,'depth',6,'immutable',8,'immutable') restriction_name,
   restriction_value,
          restriction_tree_path
from up_layout_restrictions;

alter table tmp_up_layout_restrictions modify restriction_name varchar2(128);

create table bak_up_layout_restrictions as select * from up_layout_restrictions;

drop table up_layout_restrictions cascade constraints;

alter table tmp_up_layout_restrictions rename to up_layout_restrictions;

alter table up_layout_restrictions add primary key (LAYOUT_ID, USER_ID, NODE_ID, RESTRICTION_NAME, RESTRICTION_TREE_PATH);

      DROP TABLE UP_RESTRICTIONS;
 DROP TABLE UPC_KEYWORD;


     UPDATE UP_VERSIONS SET MINOR=5, MICRO=0 WHERE FNAME='UP_FRAMEWORK';


     INSERT INTO UP_USER (USER_ID, USER_NAME, USER_DFLT_USR_ID, USER_DFLT_LAY_ID, NEXT_STRUCT_ID, LST_CHAN_UPDT_DT)
      VALUES (3, 'fragmentTemplate', 2, 1, 45, '08-APR-2005');

        INSERT INTO UP_USER (USER_ID, USER_NAME, USER_DFLT_USR_ID, USER_DFLT_LAY_ID, NEXT_STRUCT_ID, LST_CHAN_UPDT_DT)
      VALUES (4, 'ent-lo', 2, 1, 51, '08-APR-2005');

  INSERT INTO UP_USER (USER_ID, USER_NAME, USER_DFLT_USR_ID, USER_DFLT_LAY_ID, NEXT_STRUCT_ID, LST_CHAN_UPDT_DT)
      VALUES (5, 'news-lo', 2, 1, 52, '08-APR-2005');

 INSERT INTO UP_USER (USER_ID, USER_NAME, USER_DFLT_USR_ID, USER_DFLT_LAY_ID, NEXT_STRUCT_ID, LST_CHAN_UPDT_DT)
      VALUES (8, 'guest-lo', 3, 1, 54, '20-APR-2005');


    INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL)
  VALUES ('ent-lo', '(MD5)FwlZ/YNTQ/hbNPEIUl8yTGfYwwnp65/g', NULL, 'Entertainment', 'Fragment', NULL);

    INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL)
  VALUES ('fragmentTemplate', '(MD5)TcJ+RAxMebVLfq2+xF1YY4Mv5dRGo7Rg', NULL, 'Fragment', 'Template', NULL);

       INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL)
  VALUES ('news-lo', '(MD5)d3ST813VSpkgg4g7mlVsK2T2pue7b9J6', NULL, 'News', 'Fragment', NULL);

    INSERT INTO UP_PERSON_DIR (USER_NAME, ENCRPTD_PSWD, LST_PSWD_CGH_DT, FIRST_NAME, LAST_NAME, EMAIL)
  VALUES ('guest-lo', '(MD5)NZpveCmtCTXi6qaq0Rx7O5HcQDEW3MTE', NULL, NULL, NULL, NULL);



   UPDATE UP_CHANNEL
 SET CHAN_CLASS='org.jasig.portal.layout.alm.channels.CContentSubscriber'
    WHERE CHAN_CLASS='org.jasig.portal.layout.channels.CContentSubscriber';

       INSERT INTO UP_CHANNEL (
            CHAN_ID, CHAN_TITLE, CHAN_NAME, CHAN_DESC, CHAN_PUBL_ID, CHAN_PUBL_DT, CHAN_APVL_ID, CHAN_APVL_DT, CHAN_TYPE_ID, CHAN_CLASS, CHAN_TIMEOUT, CHAN_EDITABLE,
           CHAN_HAS_HELP, CHAN_FNAME, CHAN_SECURE)
     VALUES (
            91, 'User Preferences', 'User Preferences', 'DLM User Preferences channel', 0, SYSDATE, 0, SYSDATE, 1,
              'org.jasig.portal.channels.DLMUserPreferences.CUserPreferences', 10000, 'N', 'N', 'portal/userpreferences/dlm', 'N');

   INSERT INTO UP_CHANNEL (
            CHAN_ID, CHAN_TITLE, CHAN_NAME, CHAN_DESC, CHAN_PUBL_ID, CHAN_PUBL_DT, CHAN_APVL_ID, CHAN_APVL_DT, CHAN_TYPE_ID, CHAN_CLASS, CHAN_TIMEOUT, CHAN_EDITABLE,
           CHAN_HAS_HELP, CHAN_HAS_ABOUT, CHAN_FNAME, CHAN_SECURE)
     VALUES (
            82, 'Password Management', 'Password Management', 'Allows management of passwords', 0, SYSDATE, 0, SYSDATE, 1,
              'org.jasig.portal.channels.cusermanager.CUserManager', 100000, 'N', 'Y', 'N', 'passwordmgr', 'N');

      INSERT INTO UP_CHANNEL (
            CHAN_ID, CHAN_TITLE, CHAN_NAME, CHAN_DESC, CHAN_PUBL_ID, CHAN_PUBL_DT, CHAN_APVL_ID, CHAN_APVL_DT,
         CHAN_TYPE_ID, CHAN_CLASS, CHAN_TIMEOUT, CHAN_EDITABLE, CHAN_HAS_HELP, CHAN_HAS_ABOUT, CHAN_FNAME, CHAN_SECURE )
     VALUES ( 50, 'DLM Administrator''s Guide', 'DLM Administrator''s Guide',
            'A channel that presents an administrator''s guide for Distributed Layout Management.',
             2, '20-APR-2005', 2, '20-APR-2005', -1,
             'org.jasig.portal.layout.dlm.channels.guide.DlmIntroChannel',
               5000, 'N', 'N', 'N', 'dlm.admin.guide', 'N' );



    INSERT INTO UP_USER_LAYOUT (LAYOUT_ID, USER_ID, LAYOUT_TITLE, INIT_STRUCT_ID)
       VALUES (1, 3, 'Fragment Layout', 1);

    INSERT INTO UP_USER_LAYOUT (LAYOUT_ID, USER_ID, LAYOUT_TITLE, INIT_STRUCT_ID)
       VALUES (1, 4, 'Entertainment', 1);

      INSERT INTO UP_USER_LAYOUT (LAYOUT_ID, USER_ID, LAYOUT_TITLE, INIT_STRUCT_ID)
       VALUES (1, 5, 'News', 1);

       INSERT INTO UP_USER_LAYOUT (LAYOUT_ID, USER_ID, LAYOUT_TITLE, INIT_STRUCT_ID)
       VALUES (1, 8, 'Guests', 1);



     INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (3, 1, 1, 0, 9, NULL, NULL, 'Root folder', 'root', 'N', 'N', 'Y');

       INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (3, 1, 2, 3, 0, NULL, 10, NULL, '', 'N', 'N', 'N');

      INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (3, 1, 3, 333, 0, NULL, 99, NULL, '', 'N', 'N', 'N');

    INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (3, 1, 9, 27, 2, NULL, NULL, 'Header folder', 'header', 'N', 'Y', 'Y');

  INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (3, 1, 27, 0, 28, NULL, NULL, 'Footer folder', 'footer', 'N', 'N', 'N');

 INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (3, 1, 28, 0, 0, NULL, 19, NULL, '', 'N', 'N', 'N');

     INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (3, 1, 333, 0, 0, NULL, 96, NULL, '', 'N', 'N', 'N');

    INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (4, 1, 1, 0, 9, NULL, NULL, 'Root folder', 'root', 'N', 'N', 'Y');

       INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (4, 1, 2, 3, 0, NULL, 10, NULL, '', 'N', 'N', 'N');

      INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (4, 1, 3, 333, 0, NULL, 99, NULL, '', 'N', 'N', 'N');

    INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (4, 1, 9, 27, 2, NULL, NULL, 'Header folder', 'header', 'N', 'Y', 'Y');

  INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (4, 1, 27, 46, 28, NULL, NULL, 'Footer folder', 'footer', 'N', 'N', 'N');

        INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (4, 1, 28, 0, 0, NULL, 19, NULL, '', 'N', 'N', 'N');

     INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (4, 1, 46, 0, 48, NULL, NULL, 'Real Entertainment', 'regular', 'N', 'N', 'N');

   INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (4, 1, 47, 0, 50, NULL, NULL, 'Column', 'regular', 'N', 'N', 'N');

       INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (4, 1, 48, 47, 49, NULL, NULL, 'Column', 'regular', 'N', 'N', 'N');

      INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (4, 1, 49, 51, 0, NULL, 14, NULL, '', 'N', 'N', 'N');

    INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (4, 1, 50, 0, 0, NULL, 1, NULL, '', 'N', 'N', 'N');

      INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (4, 1, 51, 0, 0, NULL, 9, NULL, '', 'N', 'N', 'N');

      INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (4, 1, 333, 0, 0, NULL, 96, NULL, '', 'N', 'N', 'N');

    INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (5, 1, 1, 0, 9, NULL, NULL, 'Root folder', 'root', 'N', 'N', 'Y');

       INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (5, 1, 2, 3, 0, NULL, 10, NULL, '', 'N', 'N', 'N');

      INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (5, 1, 3, 333, 0, NULL, 99, NULL, '', 'N', 'N', 'N');

    INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (5, 1, 9, 27, 2, NULL, NULL, 'Header folder', 'header', 'N', 'Y', 'Y');

  INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (5, 1, 27, 46, 28, NULL, NULL, 'Footer folder', 'footer', 'N', 'N', 'N');

        INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (5, 1, 28, 0, 0, NULL, 19, NULL, '', 'N', 'N', 'N');

     INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (5, 1, 46, 0, 48, NULL, NULL, 'Useful News', 'regular', 'N', 'N', 'N');

  INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (5, 1, 47, 0, 51, NULL, NULL, 'Column', 'regular', 'N', 'N', 'N');

       INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (5, 1, 48, 47, 49, NULL, NULL, 'Column', 'regular', 'N', 'N', 'N');

      INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (5, 1, 49, 50, 0, NULL, 12, NULL, '', 'N', 'N', 'N');

    INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (5, 1, 50, 0, 0, NULL, 11, NULL, '', 'N', 'N', 'N');

     INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (5, 1, 51, 52, 0, NULL, 13, NULL, '', 'N', 'N', 'N');

    INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (5, 1, 52, 0, 0, NULL, 6, NULL, '', 'N', 'N', 'N');

      INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
      VALUES (5, 1, 333, 0, 0, NULL, 96, NULL, '', 'N', 'N', 'N');

    INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
     VALUES (8, 1, 1, 0, 9, NULL, NULL, 'Root folder', 'root', 'N', 'N', 'Y');

       INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
     VALUES (8, 1, 2, 3, 0, NULL, 10, NULL, '', 'N', 'N', 'N');

      INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
     VALUES (8, 1, 3, 333, 0, NULL, 99, NULL, '', 'N', 'N', 'N');

    INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
     VALUES (8, 1, 9, 27, 2, NULL, NULL, 'Header folder', 'header', 'N', 'Y', 'Y');

  INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
     VALUES (8, 1, 27, 46, 28, NULL, NULL, 'Footer folder', 'footer', 'N', 'N', 'N');

        INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
     VALUES (8, 1, 28, 0, 0, NULL, 19, NULL, '', 'N', 'N', 'N');

    INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
     VALUES (8, 1, 46, 0, 49, NULL, NULL, 'Welcome', 'regular', 'N', 'N', 'N');

      INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
     VALUES (8, 1, 49, 0, 52, NULL, NULL, 'Column', 'regular', 'N', 'N', 'N');

       INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
     VALUES (8, 1, 52, 0, 0, NULL, 50, NULL, '', 'N', 'N', 'N');

     INSERT INTO UP_LAYOUT_STRUCT (USER_ID, LAYOUT_ID, STRUCT_ID, NEXT_STRUCT_ID, CHLD_STRUCT_ID, EXTERNAL_ID, CHAN_ID, NAME, TYPE, HIDDEN, IMMUTABLE, UNREMOVABLE)
     VALUES (8, 1, 333, 0, 0, NULL, 96, NULL, '', 'N', 'N', 'N');




        INSERT INTO UP_LAYOUT_PARAM (USER_ID, LAYOUT_ID, STRUCT_ID, STRUCT_PARM_NM, STRUCT_PARM_VAL)
        VALUES (4, 1, 46, 'cp:editAllowed', 'false');

   INSERT INTO UP_LAYOUT_PARAM (USER_ID, LAYOUT_ID, STRUCT_ID, STRUCT_PARM_NM, STRUCT_PARM_VAL)
        VALUES (5, 1, 46, 'cp:moveAllowed', 'false');

   INSERT INTO UP_LAYOUT_PARAM (USER_ID, LAYOUT_ID, STRUCT_ID, STRUCT_PARM_NM, STRUCT_PARM_VAL)
        VALUES (4, 1, 49, 'cp:deleteAllowed', 'false');

 INSERT INTO UP_LAYOUT_PARAM (USER_ID, LAYOUT_ID, STRUCT_ID, STRUCT_PARM_NM, STRUCT_PARM_VAL)
        VALUES (4, 1, 49, 'cp:moveAllowed', 'false');

   INSERT INTO UP_LAYOUT_PARAM (USER_ID, LAYOUT_ID, STRUCT_ID, STRUCT_PARM_NM, STRUCT_PARM_VAL)
        VALUES (4, 1, 49, 'maxNum', '100');

     INSERT INTO UP_LAYOUT_PARAM (USER_ID, LAYOUT_ID, STRUCT_ID, STRUCT_PARM_NM, STRUCT_PARM_VAL)
        VALUES (4, 1, 49, 'minNum', '1');



       UPDATE UP_CHAN_TYPE SET TYPE_NAME='XML SSL' WHERE TYPE_ID=1;

        INSERT INTO UP_CHAN_TYPE (TYPE_ID, TYPE_NAME, TYPE, TYPE_DESCR, TYPE_DEF_URI)
       VALUES (
            8, 'XML XSLT', 'org.jasig.portal.channels.CGenericXSLT', 'Transforms an XML document into a fragment of markup language using a single XSLT.',
              '/org/jasig/portal/channels/CGenericXSLT/CGenericJustXSLT.cpd');



        INSERT INTO UP_USER_PROFILE (USER_ID, PROFILE_ID, PROFILE_NAME, DESCRIPTION, LAYOUT_ID, STRUCTURE_SS_ID, THEME_SS_ID)
       VALUES (3, 1, 'HTML browser profile', 'A sample profile for common web browsers', 1, 4, 3);

     INSERT INTO UP_USER_PROFILE (USER_ID, PROFILE_ID, PROFILE_NAME, DESCRIPTION, LAYOUT_ID, STRUCTURE_SS_ID, THEME_SS_ID)
       VALUES (4, 1, 'HTML browser profile', 'A system profile for common web browsers', 1, 4, 3);

     INSERT INTO UP_USER_PROFILE (USER_ID, PROFILE_ID, PROFILE_NAME, DESCRIPTION, LAYOUT_ID, STRUCTURE_SS_ID, THEME_SS_ID)
       VALUES (5, 1, 'HTML browser profile', 'A system profile for common web browsers', 1, 4, 3);

     INSERT INTO UP_USER_PROFILE (USER_ID, PROFILE_ID, PROFILE_NAME, DESCRIPTION, LAYOUT_ID, STRUCTURE_SS_ID, THEME_SS_ID)
       VALUES (8, 1, 'HTML browser profile', 'A sample profile for common web browsers', 1, 4, 3);



     INSERT INTO UP_SS_USER_PARM (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, PARAM_NAME, PARAM_VAL)
    VALUES (3, 1, 4, 1, 'activeTab', '1');

  INSERT INTO UP_SS_USER_PARM (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, PARAM_NAME, PARAM_VAL)
    VALUES (3, 1, 3, 2, 'skin', 'imm');

     INSERT INTO UP_SS_USER_PARM (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, PARAM_NAME, PARAM_VAL)
    VALUES (4, 1, 4, 1, 'activeTab', '1');

  INSERT INTO UP_SS_USER_PARM (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, PARAM_NAME, PARAM_VAL)
    VALUES (4, 1, 3, 2, 'skin', 'imm');

     INSERT INTO UP_SS_USER_PARM (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, PARAM_NAME, PARAM_VAL)
    VALUES (5, 1, 4, 1, 'activeTab', '1');

  INSERT INTO UP_SS_USER_PARM (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, PARAM_NAME, PARAM_VAL)
    VALUES (5, 1, 3, 2, 'skin', 'imm');

     INSERT INTO UP_SS_USER_PARM (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, PARAM_NAME, PARAM_VAL)
    VALUES (8, 1, 4, 1, 'activeTab', '1');

    INSERT INTO UP_SS_USER_PARM (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, PARAM_NAME, PARAM_VAL)
    VALUES (8, 1, 3, 2, 'skin', 'imm');



    INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL)
     VALUES (4, 1, 4, 1, 48, 'width', 2, '40%');

     INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL)
     VALUES (4, 1, 4, 1, 47, 'width', 2, '60%');

     INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL)
     VALUES (5, 1, 4, 1, 48, 'width', 2, '30%');

     INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL)
     VALUES (5, 1, 4, 1, 47, 'width', 2, '70%');

     INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL)
     VALUES (1, 1, 4, 1, 5, 'width', 2, '30%');

      INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL)
     VALUES (1, 1, 4, 1, 7, 'width', 2, '70%');

      INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL)
     VALUES (1, 1, 4, 1, 12, 'width', 2, '70%');

     INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL)
     VALUES (1, 1, 4, 1, 10, 'width', 2, '30%');

     INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL)
     VALUES (1, 1, 4, 1, 15, 'width', 2, '70%');

     INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL)
     VALUES (1, 1, 4, 1, 17, 'width', 2, '30%');

     INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL)
     VALUES (4, 1, 4, 1, 48, 'width', 2, '40%');

     INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL)
     VALUES (4, 1, 4, 1, 47, 'width', 2, '60%');

     INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL)
     VALUES (5, 1, 4, 1, 48, 'width', 2, '30%');

     INSERT INTO UP_SS_USER_ATTS (USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL)
     VALUES (5, 1, 4, 1, 47, 'width', 2, '70%');



     INSERT INTO UP_SS_STRUCT (SS_ID, SS_NAME, SS_URI, SS_DESCRIPTION_URI, SS_DESCRIPTION_TEXT)
  VALUES (
            4, 'DLM Tabs and columns', '/org/jasig/portal/layout/DLM-tab-column/tab-column.xsl', '/org/jasig/portal/layout/DLM-tab-column/tab-column.sdf',
              'Presents the DLM layout in terms of tabs and columns.');



       INSERT INTO UP_SS_THEME (
           SS_ID, SS_NAME, SS_URI, SS_DESCRIPTION_URI, SS_DESCRIPTION_TEXT, STRUCT_SS_ID, SAMPLE_ICON_URI, SAMPLE_URI, MIME_TYPE, DEVICE_TYPE,
         SERIALIZER_NAME, UP_MODULE_CLASS)
   VALUES (
            3, 'DLM Nested tables', '/org/jasig/portal/layout/DLM-tab-column/nested-tables/nested-tables.xsl',
          '/org/jasig/portal/layout/DLM-tab-column/nested-tables/nested-tables.sdf', 'Renders DLM tabs and columns as nested tables', 4,
              'media/org/jasig/portal/layout/DLM-tab-column/nested-tables/sample_icon.gif', 'media/org/jasig/portal/layout/DLM-tab-column/nested-tables/sample_full.gif',
         'text/html', 'workstation', 'HTML', 'org.jasig.portal.channels.DLMUserPreferences.TabColumnPrefsState');



        INSERT INTO UP_SS_THEME_PARM (SS_ID, PARAM_NAME, PARAM_DEFAULT_VAL, PARAM_DESCRIPT, TYPE)
   VALUES (3, 'skin', 'java', 'Design skin name', 1);

      INSERT INTO UP_SS_THEME_PARM (SS_ID, PARAM_NAME, PARAM_DEFAULT_VAL, PARAM_DESCRIPT, TYPE)
   VALUES (3, 'minimized', 'false', 'Flag determining if the channel is minimized or not', 3);



     INSERT INTO UP_SS_STRUCT_PAR (SS_ID, PARAM_NAME, PARAM_DEFAULT_VAL, PARAM_DESCRIPT, TYPE)
   VALUES (4, 'activeTab', '1', 'The number of the DLM tab that is initially active', 1);

  INSERT INTO UP_SS_STRUCT_PAR (SS_ID, PARAM_NAME, PARAM_DEFAULT_VAL, PARAM_DESCRIPT, TYPE)
   VALUES (4, 'width', '100%', 'Width of a DLM column', 2);



        INSERT INTO UP_SS_MAP (THEME_SS_ID, STRUCT_SS_ID, MIME_TYPE)
        VALUES (3, 4, 'text/html');



     INSERT INTO UP_PERMISSION (OWNER, PRINCIPAL_TYPE, PRINCIPAL_KEY, ACTIVITY, TARGET, PERMISSION_TYPE)
 VALUES ('UP_FRAMEWORK', 3, 'local.0', 'SUBSCRIBE', 'CHAN_ID.91', 'GRANT');

      INSERT INTO UP_PERMISSION (OWNER, PRINCIPAL_TYPE, PRINCIPAL_KEY, ACTIVITY, TARGET, PERMISSION_TYPE)
 VALUES ('UP_FRAMEWORK', 3, 'local.1', 'SUBSCRIBE', 'CHAN_ID.82', 'GRANT');

      INSERT INTO UP_PERMISSION (OWNER, PRINCIPAL_TYPE, PRINCIPAL_KEY, ACTIVITY, TARGET, PERMISSION_TYPE)
 VALUES ('UP_FRAMEWORK', 3, 'local.2', 'SUBSCRIBE', 'CHAN_ID.82', 'GRANT');

      INSERT INTO UP_PERMISSION (OWNER, PRINCIPAL_TYPE, PRINCIPAL_KEY, ACTIVITY, TARGET, PERMISSION_TYPE)
 VALUES ('UP_FRAMEWORK', 3, 'local.3', 'SUBSCRIBE', 'CHAN_ID.82', 'GRANT');

      INSERT INTO UP_PERMISSION (OWNER, PRINCIPAL_TYPE, PRINCIPAL_KEY, ACTIVITY, TARGET, PERMISSION_TYPE)
 VALUES ('org.jasig.portal.channels.cusermanager.CUserManager', 3, 'local.14', 'acctmgr', 'Account Manager', 'GRANT');

   INSERT INTO UP_PERMISSION (OWNER, PRINCIPAL_TYPE, PRINCIPAL_KEY, ACTIVITY, TARGET, PERMISSION_TYPE)
 VALUES ('UP_FRAMEWORK', 3, 'local.0', 'SUBSCRIBE', 'CHAN_ID.50', 'GRANT');




  INSERT INTO UP_GROUP_MEMBERSHIP (GROUP_ID, MEMBER_SERVICE, MEMBER_KEY, MEMBER_IS_GROUP)
     VALUES (0, 'local', 'fragmentTemplate', 'F');

   INSERT INTO UP_GROUP_MEMBERSHIP (GROUP_ID, MEMBER_SERVICE, MEMBER_KEY, MEMBER_IS_GROUP)
     VALUES (4, 'local', 'ent-lo', 'F');

     INSERT INTO UP_GROUP_MEMBERSHIP (GROUP_ID, MEMBER_SERVICE, MEMBER_KEY, MEMBER_IS_GROUP)
     VALUES (4, 'local', 'news-lo', 'F');

    INSERT INTO UP_GROUP_MEMBERSHIP (GROUP_ID, MEMBER_SERVICE, MEMBER_KEY, MEMBER_IS_GROUP)
     VALUES (51, 'local', '82', 'F');

        INSERT INTO UP_GROUP_MEMBERSHIP (GROUP_ID, MEMBER_SERVICE, MEMBER_KEY, MEMBER_IS_GROUP)
     VALUES (0, 'local', 'guest-lo', 'F');

  INSERT INTO UP_GROUP_MEMBERSHIP (GROUP_ID, MEMBER_SERVICE, MEMBER_KEY, MEMBER_IS_GROUP)
     VALUES (52, 'local', '50', 'F');

COMMIT;

 

Restart Tomcat

Modifications for Postgres

The above SQL needs to be changed for Postgres. Replace the code above before the line

alter table tmp_up_layout_restrictions rename to up_layout_restrictions;

 

with

Database upgrade script for Postgres
create table tmp_up_fragment_restrictions as
select fragment_id,
          node_id,
          case
              when restriction_type=1 then 'priority'
              when restriction_type=2 then 'depth'
              when restriction_type=6 then 'immutable'
              else 'immutable'
          end as restriction_name,
       restriction_value,
          restriction_tree_path
from up_fragment_restrictions;

alter table tmp_up_fragment_restrictions alter column restriction_name type varchar(128);

create table bak_up_fragment_restrictions as select * from up_fragment_restrictions;

drop table up_fragment_restrictions cascade;

alter table tmp_up_fragment_restrictions rename to up_fragment_restrictions;

alter table up_fragment_restrictions add primary key (FRAGMENT_ID, NODE_ID, RESTRICTION_NAME, RESTRICTION_TREE_PATH);


create table tmp_up_layout_restrictions as
select layout_id,
      user_id,
    node_id,
          case
              when restriction_type=1 then 'priority'
              when restriction_type=2 then 'depth'
              when restriction_type=6 then 'immutable'
              else 'immutable'
          end as restriction_name,
       restriction_value,
          restriction_tree_path
from up_layout_restrictions;

alter table tmp_up_layout_restrictions alter column restriction_name type varchar(128);

create table bak_up_layout_restrictions as select * from up_layout_restrictions;

drop table up_layout_restrictions cascade;

 
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.

Comments (4)

 

  1. Jun 24, 2005

    Elliot Metsger says:

    Jim, what version of Tomcat are you running? Also, I presume you are on JDK 1.4?

    Jim, what version of Tomcat are you running? Also, I presume you are on JDK 1.4?

  2. Jun 27, 2005

    Brad Johnson says:

    In uPortal 2.5.0 the Missing Properties channel changed from a Simple XSLT chann...

    In uPortal 2.5.0 the Missing Properties channel changed from a Simple XSLT channel to a native IChannel CMissingProperties. The channel will fail to render until you change its settings in the Channel Publisher to match the contents of /properties/chanpub/missing-properties.xml.

    BTW, I tried the above script out on one of our test servers. Worked great so far! Thanks alot!

  3. Jul 29, 2005

    Frank Wierzbicki says:

    Is the dbstat target an ant task? I don't see such a target in the build.xml tha...

    Is the db-stat target an ant task? I don't see such a target in the build.xml that came with uPortal 2.5.

  4. Dec 15, 2005

    Pete Boysen says:

    If you have added another theme like nested divs or DnDPreferences, you will nee...

    If you have added another theme like nested divs or DnDPreferences, you will need to change the SQL for the tables UP_SS_THEME and UP_SS_THEME_PARAM to reflect a different SS_ID.