/usr/share/gforge/db/20041001.sql is in gforge-db-postgresql 5.1.1-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
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
;
|