...
- 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
|