Page Comparison

...

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.

...

Code Block

	SQL
	SQL
title	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  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,     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   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,      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,      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    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 (    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     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       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   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
              '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

Code Block
alter table tmp_up_layout_restrictions rename to up_layout_restrictions;

with

Code Block

	SQL
	SQL
title	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;

Versions Compared

Old Version 3

New Version Current

Key

Possible Issues

General Upgrade Tasks

Suggested Upgrade Path (for PC development environments)

In-Place Upgrade Procedures (for shared environments)

Modifications for Postgres