...
Pre Implementation tasks:
On Friday, August 13, 2010:
â—� Sandra and Fernando will set database markers.
â—� Anand Mehta will:
â—‹ Copy the existing Tomcat to tomcat-264 on all seven app servers
â—‹ Delete all CLE files from tomcat-264
â—‹ Build and deploy the 2.6.4 code to tomcat-264
â—‹ Make a copy of all properties file in the sakai directory and update the copies to 2.6.4 level
â—� Anand Mehta to set the Sakai properties:
Panel |
---|
UCD Deployment Notes 1. Commands to remove old CLE files from Tomcat (executed from /home/ucdavis/cle/tomcat) rm -rf shared/lib/* 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: d. Add to prevent lazy initialization errors: 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 |
...
\ |
Saturday, August 14, 2010 during maintenance window: 5:00 am to 10:30am
1. (5:00 am to 5:10 am) Anand Mehta will place smartsite in maintenance mode and stop all Tomcats.
2. (5:11 am to 5:25 am) Anand Mehta will rename tomcat to tomcat-263 and tomcat-264 to tomcat on all app servers
3. (5:26 am to 5:40 am) Anand Mehta will backup the 2.6.3 properties files and put the 2.6.4 properties files in the sakai directory
4. (5:40am to 6:10 am) Mark Pankow will backup the existing DB.
1. No cron jobs will be disabled or altered. ** Mark will link to actual text document.
2. I will let the normally scheduled hot backup run at 4AM. It will not include a datapump (export) which is part of my "normal" daily backup.
3. At 5:40 I will manually export the SAKAI schema. It should not alter the timeline, but I will be running a test at some point this weekend to verify.
4. After the export, I will manually switch the logfile in production and make note of that.
5. I will then defer log transfer to the standby.
5. (6:10 am to 6:20) Mark Pankow will execute the upgrade scripts 2.6.2 to 2.6.3 and 2.6.3 to 2.6.4 CLE upgrade scripts as follows:
ADD: Talk to Anand: No commits; add commits or have DBA issue commits.
Panel |
---|
/* change Preferences to split out email into different fields that can be controlled individually.*/ /* update the new columns based on the old data */ /* if just requests, set requests to true, confirms to false */ /* if just confirms, set confirms to true, requests to false */ /* if all off, set both false */ /* now drop the old column */ /* change name of profile field to be profile_image since it only controls that now (PRFL-24) */ /* update values in profile_image and search, we no longer have 2 as an option (ie only me) */ /* add my_status column */ /* add the new academic column, default to 0, (PRFL-38) */ /* increase size of UUID columns (PRFL-44) */ /* resize column (PRFL-44) but also change its type (PRFL-45) */ /* add indexes (PRFL-76) */ /* CLE-4417 jforum reset icon missing */ /* CLE-4329 logical delete of sakai site data */ /* CLE-4321 trim space after term name */ |
6. (6:20 am to 6:40 am) Mark Pankow to run rsnfixes.sql [Mark will move to script files] ADD: Talk to Anand: No commits; add commits or have DBA issue commit.
Panel |
---|
-- Cannot Change Config options on some tools (8306969) -- Cannot assign TA in Section Info (8306675) -- Site Editor tool does not show for Participants in Project site (8306970) -- Stack trace when selecting the Content over Text layout during Freeform Portfolio creation (8306957) UCD Thinks this should be removed. 8/6/2010 -- Site Editor on new Course sites is being named Site Setup (8306811) UCD Thinks this should be removed because we don’t have QA results that say it fixed anything.. 8/6/2010 -- Bad data in sakai.GB_CATEGORY_T table causing grade submission failure (8308193) UPDATE GB_CATEGORY_T SET WEIGHT=ROUND(WEIGHT,14) WHERE ROUND(WEIGHT,14) != WEIGHT; |
7. (6:40am to 6:50 am) Mark Pankow to run SQL conversion for GB2. Talk to Thomas: Commit to script (Thomas)
Conversion script is below but source can be taken from:https://source.sakaiproject.org/contrib/gradebook2/tags/1.3.0-rc1/sakai/2-6-x/sql/oracle/conversion_1.2.0_to_1.3.0.sql.
At the time of deployment this link will be active for the source script:https://source.sakaiproject.org/contrib/gradebook2/tags/1.3.0/sakai/2-6-x/sql/oracle/conversion_1.2.0_to_1.3.0.sql
Panel |
---|
update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T update GB_ACTION_RECORD_PROPERTY_T |
8. (6:50 am to 6:55 am) Anand Mehta will check each prod node to make sure that the file /etc/krb5.conf does not exist. Rename existing to /etc/krb5.config.orig.
...