1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
CREATE VIEW nss_passwd AS
SELECT unix_uid+20000 AS uid,
unix_uid+20000 AS gid,
user_name AS login,
unix_pw AS passwd,
realname AS gecos,
shell,
'/var/lib/gforge/chroot/home/users/' || user_name AS homedir
FROM users
WHERE status='A'
UNION
SELECT group_id+50000 AS uid,
group_id+20000 AS gid,
'anoncvs_' || unix_group_name AS login,
CHAR(1) 'x' AS passwd,
group_name AS gecos,
'/bin/false' AS shell,
'/var/lib/gforge/chroot/home/groups' || group_name AS homedir
FROM groups
UNION
SELECT 9999 AS uid,
9999 AS gid,
'gforge_scm' AS login,
CHAR(1) 'x' AS passwd,
'Gforge SCM user' AS gecos,
'/bin/false' AS shell,
'/var/lib/gforge/chroot/home' AS homedir;
CREATE VIEW nss_shadow AS
SELECT user_name AS login,
unix_pw AS passwd,
CHAR(1) 'n' AS expired,
CHAR(1) 'n' AS pwchange
FROM users
WHERE status='A';
CREATE VIEW nss_groups AS
SELECT group_id+10000 AS gid,
unix_group_name AS name,
group_name AS descr,
CHAR(1) 'x' AS passwd
FROM groups
UNION
SELECT unix_uid+20000 AS gid,
user_name AS name,
lastname AS descr,
CHAR(1) 'x' AS passwd
FROM users;
CREATE VIEW nss_usergroups AS
SELECT group_id+10000 AS gid,
users.unix_uid+20000 AS uid
FROM user_group,users
WHERE user_group.user_id=users.user_id
UNION
SELECT unix_uid+20000 AS gid,
unix_uid+20000 AS uid
FROM users
-- WHERE group_id!=800 -- drop unused and overfull Debian group
;
|
