...
- (5:35am to 5:55***am, UCDavis) QA will verify that the system has been successfully upgraded by doing the following:
- Verify that we can search on a student name in Gradebook (on the spreadsheet side)
- Verify that TA’s do not have permission to change category and item set up in Gradebook. TA should not be able to change IOR's categories and item. Should have only permissions IOR specifically grants.
- Verify that a new site with gradebook will open immediately and not require refreshing for it to open.
- Verify that duplicate sections is fixed
- Verify that there are no lazy loading system errors. rSmart can do this.
- (5:55am--6:00am, rSmart and UCDavis) Team will decide go or roll back.
...
- Apache into scheduled maintenance mode when there is scheduled downtime as follows:
- as user ucdavis on mach execute /var/www/html/ucdavis/apache/maint_mode.sh
- as user 'root' on mach, edit /etc/httpd/conf/httpd_ucdavis.conf and uncomment the Proxy * stuff on lines 36-40
- restart apache: /etc/init.d/httpd_ucdavis restart
- to restore regular functioning (normal "outage" mode is when there is no downtime planned, so any downtime is an "outage")
- as user ucdavis on mach execute /var/www/html/ucdavis/apache/outage_mode.sh
- as user root on mach, comment out Proxy * stuff & restart apache
| Code Block |
|---|
-- sql from 8306969
spool apr13.motd.output;
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';
spool off;
GB2 SQL:
spool apr06
select count(*) cnt from sakaitest.sakai_realm_rl_fn where function_key =
(select function_key
from sakaitest.sakai_realm_function
where
function_name = 'gradebook.editAssignments'
)
and
role_key in (select role_key from sakaitest.sakai_realm_role where
role_name='Teaching Assistant')
/
delete from sakaitest.sakai_realm_rl_fn where function_key =
(select function_key
from sakaitest.sakai_realm_function
where
function_name = 'gradebook.editAssignments'
)
and
role_key in (select role_key from sakaitest.sakai_realm_role where
role_name='Teaching Assistant')
/
commit
/
select count(*) cnt from sakaitest.sakai_realm_rl_fn where function_key =
(select function_key
from sakaitest.sakai_realm_function
where
function_name = 'gradebook.editAssignments'
)
and
role_key in (select role_key from sakaitest.sakai_realm_role where
role_name='Teaching Assistant')
/
spool off
/
#1
|