2 ALTER TABLE users ADD COLUMN unix_gid INTEGER;
3 ALTER TABLE users ALTER COLUMN unix_gid SET DEFAULT 0;
5 UPDATE users SET unix_uid=unix_uid + 20000 WHERE unix_uid!=0;
6 UPDATE users SET unix_uid=user_id + 20000 WHERE unix_uid=0;
7 UPDATE users SET unix_gid=unix_uid;
12 CREATE VIEW nss_passwd AS
23 WHERE unix_status='A';
25 -- Shadow view (for future use)
28 CREATE VIEW nss_shadow AS
32 CHAR(1) 'n' AS expired,
33 CHAR(1) 'n' AS pwchange
35 WHERE unix_status='A';
40 CREATE TABLE nss_groups AS
41 SELECT 0 AS user_id, group_id,unix_group_name AS name, group_id + 10000 AS gid
44 -- Insert users group ids in nss_group table
46 INSERT INTO nss_groups (user_id,group_id,name, gid)
47 SELECT user_id,0,user_name, unix_gid
52 -- Insert scm group ids in nss_group table
54 INSERT INTO nss_groups (user_id,group_id,name, gid)
55 SELECT 0,group_id,'scm_' || unix_group_name, group_id + 50000
58 AND enable_anonscm = 1;
62 DROP VIEW nss_usergroups ;
63 CREATE TABLE nss_usergroups AS (
65 users.unix_uid AS uid,
66 groups.group_id + 10000 AS gid,
67 users.user_id AS user_id,
68 groups.group_id AS group_id,
69 users.user_name AS user_name,
70 groups.unix_group_name AS unix_group_name
71 FROM users,groups,user_group
73 users.user_id=user_group.user_id
75 groups.group_id=user_group.group_id
84 users.unix_uid AS uid,
85 groups.group_id + 50000 AS gid,
86 users.user_id AS user_id,
87 groups.group_id AS group_id,
88 users.user_name AS user_name,
89 'scm_' || groups.unix_group_name AS unix_group_name
90 FROM users,groups,user_group
92 users.user_id=user_group.user_id
94 groups.group_id=user_group.group_id
102 groups.enable_anonscm = 1);
106 GRANT SELECT ON nss_passwd TO gforge_nss;
107 GRANT SELECT ON nss_groups TO gforge_nss;
108 GRANT SELECT ON nss_usergroups TO gforge_nss;