[Gforge-commits] gforge/db 20041001.sql,1.3,1.4

[lo-lan-do]

Update of /cvsroot/gforge/gforge/db
In directory db.perdue.net:/tmp/cvs-serv18265/db

Modified Files:
        20041001.sql 
Log Message:
New backend for NSS using NSS-PGSQL.
Creates views, configures NSS, adds a new gforge-shell-pgsql pachage.


Index: 20041001.sql
===================================================================
RCS file: /cvsroot/gforge/gforge/db/20041001.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- 20041001.sql        1 Oct 2004 11:58:53 -0000       1.3
+++ 20041001.sql        3 Oct 2004 17:01:38 -0000       1.4
@@ -1,23 +1,34 @@
+CREATE VIEW nss_passwd AS
+       SELECT unix_uid+20000 AS uid,
+               unix_uid+20000 AS gid,
+               user_name AS login,
+               CHAR(1) 'x' AS passwd,
+               realname AS gecos,
+               shell,
+               '/var/lib/gforge/chroot/home/users/' || user_name AS homedir
+       FROM users
+       WHERE status='A';
+
+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,
-        CHAR(1) 'x' AS passwd
-        FROM groups;
+       SELECT group_id+10000 AS gid,
+       unix_group_name AS name,
+       CHAR(1) 'x' AS passwd
+       FROM groups;
 
-CREATE VIEW nss_accounts 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';
 
 CREATE VIEW nss_usergroups AS
-        SELECT group_id+10000 AS gid,
-                user_id+20000 AS uid
-        FROM user_group
---         WHERE group_id!=800    -- drop unused and overfull Debian group
-       ;
\ No newline at end of file
+       SELECT group_id+10000 AS gid,
+               user_id+20000 AS uid
+       FROM user_group
+--     WHERE group_id!=800     -- drop unused and overfull Debian group
+;
+
+GRANT SELECT ON nss_passwd, nss_groups, nss_usergroups TO gforge_nss;