Page Comparison

UCD Deployment Notes

-----------------------

1. Commands to remove old CLE files from Tomcat (executed from /home/ucdavis/cle/tomcat)

rm -rf shared/lib/*
rm -rf components
rm common/lib/sakai*
rm server/lib/sakai*
mv webapps/balancer /tmp; mv webapps/ROOT /tmp
rm -rf webapps/*
mv /tmp/ROOT webapps; mv /tmp/balancer webapps
rm -rf work/*


2. Verify the following setting in sakai.properties:

portalPath=/xsl-portal (This is used by GB2 security, and should be already set in sakai.properties)


3. Modify/Add the following settings in local.properties

a. version.service=2.6.4.0

b. version.sakai=2.6.2

c. Gradebook2 properties:
gb2.help.url=[http://smartsite.ucdavis.edu/ucd-gateway/Gradebook2Documents.html]
gb2.enabled.grade.types=points,percentages,letters
gb2.gradable.role.names=Student,Participant,Open Campus,access
gb2.enable.scaled.extra.credit=INSTRUCTOR
gb2.limit.scaled.extra.credit=CATEGORIES,WEIGHTED CATEGORIES
gb2.import.delete.missing.grades=true
gb2.security.enabled=true

d. Add to prevent lazy initialization errors:
osiv.enable=true
osiv.sessionFactoryBeanName=edu.ucdavis.sakai.external.GlobalSessionFactory

e. Add sakai.kaltura,sakai-itunesu-admin,sakai.iTunesU to the stealth tool setting

f. Verify that all the Gradebook2 final grade submission properties are still in place


4. Ensure that auto.ddl is true in the first Tomcat's instance.properties


5. Make the following changes to SystemGlobals.properties

a. set cache.engine.implementation=org.etudes.jforum.cache.MemoryServiceCacheEngine

b. set html.tags.welcome=a, abbr, acronym, address, b, big, blockquote, br, center, cite, code, dd, del, dir, div, dl, dt, em, font, hr, h1, h2, h3, h4, h5, h6, I, ins,kbd, li, marquee, menu, nobr, noembed, ol, p, pre, q, rt, ruby, rbc, rb, rtc, rp,s, samp, small, span, strike, strong, sub, sup, tt, u, ul, var, xmp, img, embed,object, table, tr, td, th, tbody, caption, thead, tfoot, colgroup, col\

/* change Preferences to split out email into different fields that can be controlled individually.*/
/* add the new columns, default to false as we update them further down. */
alter table PROFILE_PREFERENCES_T add (EMAIL_REQUEST number(1,0) default 0, EMAIL_CONFIRM number(1,0) default 0);

/* update the new columns based on the old data */
/* if all emails, then both true */
update PROFILE_PREFERENCES_T set EMAIL_REQUEST=1, EMAIL_CONFIRM=1 where EMAIL=0;

/* if just requests, set requests to true, confirms to false */
update PROFILE_PREFERENCES_T set EMAIL_REQUEST=1, EMAIL_CONFIRM=0 where EMAIL=1;

/* if just confirms, set confirms to true, requests to false */
update PROFILE_PREFERENCES_T set EMAIL_REQUEST=0, EMAIL_CONFIRM=1 where EMAIL=2;

/* if all off, set both false */
update PROFILE_PREFERENCES_T set EMAIL_REQUEST=0, EMAIL_CONFIRM=0 where EMAIL=3;

/* now drop the old column */
alter table PROFILE_PREFERENCES_T drop COLUMN EMAIL;

/* change name of profile field to be profile_image since it only controls that now (PRFL-24) */
alter table PROFILE_PRIVACY_T rename column PROFILE to PROFILE_IMAGE;

/* update values in profile_image and search, we no longer have 2 as an option (ie only me) */
update PROFILE_PRIVACY_T set PROFILE_IMAGE=1 where PROFILE_IMAGE>1;
update PROFILE_PRIVACY_T set SEARCH=1 where SEARCH>1;

/* add my_status column */
alter table PROFILE_PRIVACY_T add MY_STATUS number(1,0) default 0;

/* add the new academic column, default to 0, (PRFL-38) */
alter table PROFILE_PRIVACY_T add ACADEMIC_INFO number(1,0) default 0;

/* increase size of UUID columns (PRFL-44) */
alter table PROFILE_FRIENDS_T modify USER_UUID varchar2(99);
alter table PROFILE_FRIENDS_T modify FRIEND_UUID varchar2(99);
alter table PROFILE_IMAGES_EXTERNAL_T modify USER_UUID varchar2(99);
alter table PROFILE_IMAGES_T modify USER_UUID varchar2(99);
alter table PROFILE_PREFERENCES_T modify USER_UUID varchar2(99);
alter table PROFILE_PRIVACY_T modify USER_UUID varchar2(99);
alter table PROFILE_STATUS_T modify USER_UUID varchar2(99);

/* resize column (PRFL-44) but also change its type (PRFL-45) */
alter table SAKAI_PERSON_META_T modify USER_UUID varchar2(99);

/* add indexes (PRFL-76) */
create index PROFILE_FRIENDS_USER_UUID_I on PROFILE_FRIENDS_T (USER_UUID);
create index PROFILE_FRIENDS_FRIEND_UUID_I on PROFILE_FRIENDS_T (FRIEND_UUID);
create index PROFILE_IMAGES_USER_UUID_I on PROFILE_IMAGES_T (USER_UUID);
create index PROFILE_IMAGES_IS_CURRENT_I on PROFILE_IMAGES_T (IS_CURRENT);
create index SAKAI_PERSON_META_USER_UUID_I on SAKAI_PERSON_META_T (USER_UUID);
create index SAKAI_PERSON_META_PROPERTY_I on SAKAI_PERSON_META_T (PROPERTY);

/* CLE-4417 jforum reset icon missing */
update rsn_tool_final_config set prop_value = true where prop_key = “reset.button� and tool_id = (select id from rsn_tool where tool_id = “sakai.jforum.tool�) ;

/* CLE-4329 logical delete of sakai site data */
alter table SAKAI_SITE add IS_DELETED CHAR(1) DEFAULT ‘N’;

/* CLE-4321 trim space after term name */
update SAKAI_SITE_PROPERTY set VALUE = trim(VALUE) where name=�term�;

--Cannot Change Config options on some tools (8306969)
INSERT INTO RSN_TOOL_MUTABLE_CONFIG ( TOOL_ID, PROP_VALUE, PROP_KEY) SELECT id, 'false', 'show-subject' FROM rsn_tool WHERE tool_id = 'sakai.motd';
INSERT INTO RSN_TOOL_MUTABLE_CONFIG ( TOOL_ID, PROP_VALUE, PROP_KEY) SELECT id, '3', 'items' FROM rsn_tool WHERE tool_id = 'sakai.motd';
INSERT INTO RSN_TOOL_MUTABLE_CONFIG ( TOOL_ID, PROP_VALUE, PROP_KEY) SELECT id, '/announcement/channel/!site/motd', 'channel' FROM rsn_tool WHERE tool_id = 'sakai.motd';
INSERT INTO RSN_TOOL_MUTABLE_CONFIG ( TOOL_ID, PROP_VALUE, PROP_KEY) SELECT id, 'true', 'show-newlines' FROM rsn_tool WHERE tool_id = 'sakai.motd';
INSERT INTO RSN_TOOL_MUTABLE_CONFIG ( TOOL_ID, PROP_VALUE, PROP_KEY) SELECT id, '50000', 'length' FROM rsn_tool WHERE tool_id = 'sakai.motd';
INSERT INTO RSN_TOOL_MUTABLE_CONFIG ( TOOL_ID, PROP_VALUE, PROP_KEY) SELECT id, '1000', 'days' FROM rsn_tool WHERE tool_id = 'sakai.motd';


-- Cannot assign TA in Section Info (8306675)
insert into sakai_realm_rl_fn (realm_key, role_key, function_key) (select realm_key, 9, 74 from sakai_realm where realm_id like '/site/%/group/%' and  realm_key not in (select realm_key from sakai_realm_rl_fn where  function_key = (select function_key from sakai_realm_function where function_name = 'section.role.ta') and  role_key = (select role_key from sakai_realm_role where role_name = 'Teaching Assistant')));
DELETE from sakai_realm_rl_fn where role_key = (select role_key from sakai_realm_role where ROLE_NAME = 'Lead TA') and realm_key in (select realm_key from sakai_realm where REALM_ID LIKE '/site/%/group/%') and function_key = (select function_key from sakai_realm_function where function_name = 'section.role.ta');


--Site Editor tool does not show for Participants in Project site (8306970)
--THIS TICKET IS STILL OPEN SO THIS MAY CHANGE
update rsn_tool_mutable_config set prop_value='site.visit' where tool_id in(select id from sakai.rsn_tool where tool_id='sakai.siteinfo'and prop_key='functions.require');


--Stack trace when selecting the Content over Text layout during Freeform Portfolio creation (8306957)
update OSP_PRESENTATION_LAYOUT SET xhtml_file_id = (select RESOURCE_UUID from CONTENT_RESOURCE where RESOURCE_ID = '/group/PortfolioAdmin/system/simpleRichText.xml'), preview_image_id = (select RESOURCE_UUID from CONTENT_RESOURCE where RESOURCE_ID = '/group/PortfolioAdmin/system/Simplehtml.jpg') WHERE id = 'simpleRichText';
update OSP_PRESENTATION_LAYOUT SET xhtml_file_id = (select RESOURCE_UUID from CONTENT_RESOURCE where RESOURCE_ID = '/group/PortfolioAdmin/system/twoColumn.xml'), preview_image_id = (select RESOURCE_UUID from CONTENT_RESOURCE where RESOURCE_ID = '/group/PortfolioAdmin/system/2column.jpg') WHERE id = 'twoColumn';
update OSP_PRESENTATION_LAYOUT SET xhtml_file_id = (select RESOURCE_UUID from CONTENT_RESOURCE where RESOURCE_ID = '/group/PortfolioAdmin/system/contentOverText.xml'), preview_image_id = (select RESOURCE_UUID from CONTENT_RESOURCE where RESOURCE_ID = '/group/PortfolioAdmin/system/contentOverText.jpg') WHERE id = 'contentOverText';


UCD Thinks this should be removed. 8/6/2010
--Tests and Quizzes: Students receiving credit for unanswered questions (8308099)
create table SAM_ITEMGRADING_TT (ITEMGRADINGID number(19,0) not null, ASSESSMENTGRADINGID number(19,0) not null, PUBLISHEDITEMID number(19,0) not null, PUBLISHEDITEMTEXTID number(19,0) not null, AGENTID varchar2(255 char) not null, SUBMITTEDDATE timestamp, PUBLISHEDANSWERID number(19,0), RATIONALE varchar2(4000 char), ANSWERTEXT varchar2(4000 char), AUTOSCORE float, OVERRIDESCORE float, COMMENTS varchar2(4000 char), GRADEDBY varchar2(255 char), GRADEDDATE timestamp, REVIEW number(1,0), ATTEMPTSREMAINING number(10,0), LASTDURATION varchar2(36 char), primary key (ITEMGRADINGID));
create table SAM_ITEMGRADING_TTT (ITEMGRADINGID number(19,0) not null, ASSESSMENTGRADINGID number(19,0) not null, PUBLISHEDITEMID number(19,0) not null, PUBLISHEDITEMTEXTID number(19,0) not null, AGENTID varchar2(255 char) not null, SUBMITTEDDATE timestamp, PUBLISHEDANSWERID number(19,0), RATIONALE varchar2(4000 char), ANSWERTEXT varchar2(4000 char), AUTOSCORE float, OVERRIDESCORE float, COMMENTS varchar2(4000 char), GRADEDBY varchar2(255 char), GRADEDDATE timestamp, REVIEW number(1,0), ATTEMPTSREMAINING number(10,0), LASTDURATION varchar2(36 char), primary key (ITEMGRADINGID));
insert into sakai.sam_itemgrading_tt (select * from sakai.sam_itemgrading_t where submitteddate is null);
insert into sakai.sam_itemgrading_ttt (select * from sakai.sam_itemgrading_t where itemgradingid in (select a.itemgradingid from sakai.sam_itemgrading_tt a join sakai.sam_itemgrading_t b on a.assessmentgradingid = b.assessmentgradingid and a.publisheditemid = b.publisheditemid and b.submitteddate is not null and a.autoscore = b.autoscore and a.overridescore=b.overridescore);
delete from from sam_itemgrading_t where itemgradingid in (select itemgradingid from sam_itemgrading_ttt);
DROP TABLE sam_itemgrading_tt;
DROP TABLE sam_itemgrading_ttt;


--Site Editor on new Course sites is being named Site Setup (8306811)
update sakai_site_page set title = 'Site Editor' where page_id in (select page_id from sakai_site_page ssp join sakai_site ss on ss.site_id = ssp.site_id and ss.type = 'course' and ssp.title = 'Site Setup');

UCD Thinks this should be removed because we don’t have QA results that say it fixed anything.. 8/6/2010
--Duplicate student entries in Dropbox (8307538)
DELETE FROM CONTENT_DROPBOX_CHANGES WHERE DROPBOX_ID = '/group-user/631ba4ad-8eeb-4b7a-8f73-a7bbcf297451/d5cf9904-0895-4409-b201-d967d9ebd030/';
DELETE FROM CONTENT_DROPBOX_CHANGES WHERE DROPBOX_ID = '/group-user/631ba4ad-8eeb-4b7a-8f73-a7bbcf297451/ed575560-6ef5-40fc-846b-558350daac45/';
DELETE FROM CONTENT_COLLECTION WHERE COLLECTION_ID = '/group-user/631ba4ad-8eeb-4b7a-8f73-a7bbcf297451/d5cf9904-0895-4409-b201-d967d9ebd030/';
DELETE FROM CONTENT_COLLECTION WHERE COLLECTION_ID = '/group-user/631ba4ad-8eeb-4b7a-8f73-a7bbcf297451/ed575560-6ef5-40fc-846b-558350daac45/';


-- Bad data in sakai.GB_CATEGORY_T table causing grade submission failure (8308193)
insert into  ucdrw.savegb2weights
(ID, VERSION, GRADEBOOK_ID, NAME, WEIGHT, DROP_LOWEST,
  REMOVED, IS_EXTRA_CREDIT, IS_EQUAL_WEIGHT_ASSNS,
      IS_UNWEIGHTED, CATEGORY_ORDER, ENFORCE_POINT_WEIGHTING)
(SELECT * FROM SAKAI.GB_CATEGORY_T Where ROUND(WEIGHT,14) \!= WEIGHT)

UPDATE GB_CATEGORY_T SET WEIGHT=ROUND(WEIGHT,14) WHERE ROUND(WEIGHT,14) \!= WEIGHT;

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_ID'
where PROPERTY_NAME='ID';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_NM'
where PROPERTY_NAME='NAME';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='D_WGHT'
where PROPERTY_NAME='WEIGHT';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_EQL_WGHT'
where PROPERTY_NAME='EQUAL_WEIGHT';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_X_CRDT'
where PROPERTY_NAME='EXTRA_CREDIT';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_INCLD'
where PROPERTY_NAME='INCLUDED';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_RMVD'
where PROPERTY_NAME='REMOVED';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_GB_NAME'
where PROPERTY_NAME='GRADEBOOK';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='I_DRP_LWST'
where PROPERTY_NAME='DROP_LOWEST';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_CTGRY_NAME'
where PROPERTY_NAME='CATEGORY_NAME';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='L_CTGRY_ID'
where PROPERTY_NAME='CATEGORY_ID';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='W_DUE'
where PROPERTY_NAME='DUE_DATE';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='D_PNTS'
where PROPERTY_NAME='POINTS';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_PNTS'
where PROPERTY_NAME='POINTS_STRING';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_RLSD'
where PROPERTY_NAME='RELEASED';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_NLLS_ZEROS'
where PROPERTY_NAME='NULLSASZEROS';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_SOURCE'
where PROPERTY_NAME='SOURCE';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_ITM_TYPE'
where PROPERTY_NAME='ITEM_TYPE';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='D_PCT_GRD'
where PROPERTY_NAME='PERCENT_COURSE_GRADE';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_PCT_GRD'
where PROPERTY_NAME='PERCENT_COURSE_GRADE_STRING';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='D_PCT_CTGRY'
where PROPERTY_NAME='PERCENT_CATEGORY';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_PCT_CTGRY'
where PROPERTY_NAME='PERCENT_CATEGORY_STRING';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_IS_PCT'
where PROPERTY_NAME='IS_PERCENTAGE';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='O_LRNR_KEY'
where PROPERTY_NAME='STUDENT_MODEL_KEY';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='L_ITM_ID'
where PROPERTY_NAME='ASSIGNMENT_ID';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_NM'
where PROPERTY_NAME='NAME';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_DATA_TYPE'
where PROPERTY_NAME='DATA_TYPE';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='C_CTGRY_TYPE'
where PROPERTY_NAME='CATEGORYTYPE';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='G_GRD_TYPE'
where PROPERTY_NAME='GRADETYPE';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_REL_GRDS'
where PROPERTY_NAME='RELEASEGRADES';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_REL_ITMS'
where PROPERTY_NAME='RELEASEITEMS';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='I_SRT_ORDR'
where PROPERTY_NAME='ITEM_ORDER';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='L_GRD_SCL_ID'
where PROPERTY_NAME='GRADESCALEID';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_RECALC_PTS'
where PROPERTY_NAME='DO_RECALCULATE_POINTS';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_WT_BY_PTS'
where PROPERTY_NAME='ENFORCE_POINT_WEIGHTING';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_SHW_MEAN'
where PROPERTY_NAME='SHOWMEAN';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_SHW_MEDIAN'
where PROPERTY_NAME='SHOWMEDIAN';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_SHW_MODE'
where PROPERTY_NAME='SHOWMODE';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_SHW_RANK'
where PROPERTY_NAME='SHOWRANK';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_SHW_ITM_STATS'
where PROPERTY_NAME='SHOWITEMSTATS';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='A_CHILDREN'
where PROPERTY_NAME='CHILDREN';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_ACTIVE'
where PROPERTY_NAME='IS_ACTIVE';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_EDITABLE'
where PROPERTY_NAME='IS_EDITABLE';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_CHKD'
where PROPERTY_NAME='IS_CHECKED';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_PARENT'
where PROPERTY_NAME='PARENT_NAME';

update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_ALW_SCL_X_CRDT'
where PROPERTY_NAME='ALLOW_SCALED_EXTRA_CREDIT';

mvn \-Dmaven.test.skip=true \-Dmaven.tomcat.home=/home/ucdavis/cle/tomcat/ \-Dsakai-login-tool.cas \-Ducd.cas.mothra.filter \-Dsakai2.6 clean install sakai:deploy

select realm_id, count(*) as NUM_DUPS from GB_USER_DEREF_RM_UPDATE_T group by REALM_ID having count(*) > 1;