Glenn Golden
Here are two late breaking news items for Sakai 2.1:
- Authorization Group Template Role Names
- New conversion needed for the 2.1 production branch (and trunk)
Authorization Group Template Role Names
----------------------------------------------------------
The new Site Group feature in Sakai 2.1 introduces new azg (Authorization Group, formally known as 'realm') templates:
- !group.template
- !group.template.course
In order for Site Groups to work properly, these templates must have the same roles defines as the cooresponding site azg templates:
- !site.template
- !site.template.course
or, they must have the superset of all the possible role names for course and project sites in your system.
Otherwise you will see the following: add a user to a site group, and the user disappears from the group (with various errors in your server logs). Users are given the same role in a site group as they have in the site, so the site group must have the same set of roles. The templates are used to create new site groups, so should have all the possible roles defined that you use in your system.
OOTB (out of the box), Sakai defines these roles for course sites:
- Student
- Instructor
- Teaching Assistant
(Note the case and the space - all is significant)
And for non-course (project) sites:
- access
- maintain
These are defined in the OOTB group templates as well.
New conversion needed for the production branch (and trunk)
------------------------------------------------------------------------ -----------
If you are using the Sakai 2.1 production branch ( https:// source.sakaiproject.org/svn/branches/sakai_2-1/ ), as of svn r4692, there is a new database conversion needed for Tests & Quizzes (Samigo).
These are in the source:
sam/tool/src/sql/oracle/patches/SAK-2862.sql
sam/tool/src/sql/mysql/patches/SAK-2862.sql
sam/tool/src/sql/hsqldb/patches/SAK-2862.sql
For Oracle:
alter table SAM_ASSESSFEEDBACK_T add (FEEDBACKAUTHORING integer); alter table SAM_PUBLISHEDFEEDBACK_T add (FEEDBACKAUTHORING integer); INSERT INTO SAM_ASSESSMETADATA_T ("ASSESSMENTMETADATAID", "ASSESSMENTID","LABEL", "ENTRY") VALUES(sam_assessMetaData_id_s.nextVal, 1, 'feedbackAuthoring_isInstructorEditable', 'true');
For MySQL:
alter table SAM_ASSESSFEEDBACK_T
add column FEEDBACKAUTHORING integer;
alter table SAM_PUBLISHEDFEEDBACK_T
add column FEEDBACKAUTHORING integer;
INSERT INTO SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID, ASSESSMENTID, LABEL,
ENTRY)
VALUES(NULL, 1, 'feedbackAuthoring_isInstructorEditable', 'true');