Group Service

[narendasan]

[calvin-shirley]

It'd be sweet if this tied in bi-directionally with AD, since that's how we [Admin] authoritatively store that information. We talked about doing this with Liquid but it never happened.

[colegleason]

Could possibly use Crowd as the backend.

On Sat, Apr 25, 2015 at 7:02 PM CJS7070 notifications@github.com wrote:

It'd be sweet if this tied in bi-directionally with AD, since that's how
we [Admin] authoritatively store that information. We talked about doing
this with Liquid but it never happened.

—
Reply to this email directly or view it on GitHub
acm-uiuc/groot#7 (comment).

[calvin-shirley]

Yeah, that would be my preference since Crowd is the only thing we allow delegated access to (for auth, groups, etc.).

[sskhandek]

@ace-n can you post the current group manager schema for @J0Nreynolds and @nocaps ?

[ace-n]

mysql> describe auth_user_groups;
+----------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| user_id | int(11) | NO | MUL | NULL | |
| group_id | int(11) | NO | MUL | NULL | |
+----------+---------+------+-----+---------+----------------+
3 rows in set (0.02 sec)

mysql> describe auth_group;
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(80) | NO | UNI | NULL | |
+-------+-------------+------+-----+---------+----------------+
2 rows in set (0.01 sec)

mysql> describe auth_group_permissions;
+---------------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| group_id | int(11) | NO | MUL | NULL | |
| permission_id | int(11) | NO | MUL | NULL | |
+---------------+---------+------+-----+---------+----------------+
3 rows in set (0.02 sec)

mysql> describe auth_permission;
+-----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(50) | NO | | NULL | |
| content_type_id | int(11) | NO | MUL | NULL | |
| codename | varchar(100) | NO | | NULL | |
+-----------------+--------------+------+-----+---------+----------------+

[Salil999]

Updated groups to pull data from the groot-groups-service. Going to ask @pranaygp to update the ejs accordingly (pretty sure that's why the data is not parsing).

[narendasan]

resolved with acm-uiuc/groot-groups-service#3