Forgot to change the version number - sorry

[invirt/packages/invirt-console.git] / files / etc / nss-pgsql.conf

diff --git a/files/etc/nss-pgsql.conf b/files/etc/nss-pgsql.conf
index d4ddcfe..e0ae1f2 100644 (file)
--- a/files/etc/nss-pgsql.conf
+++ b/files/etc/nss-pgsql.conf
@@ -5,19 +5,14 @@ host          = sipb-xen-dev
 port           = 5432
 database       = sipb_xen
 login          = sipb-xen
-#passwd                = foo
-#passwdtable   = machines
-#grouptable    = machines
-# you can use anything postgres accepts as table expression
-#groupmembertable = accounts JOIN usergroups ON accounts.uid=usergroups.uid JOIN groups ON usergroups.gid=groups.gid
 
-querypasswd = SELECT name, 'moo', 1000 as uid, 1000, '', '/vmhome/'|| name, '/usr/local/bin/sipb-xen-consolesh' FROM machines
-querygroup = SELECT name, NULL, 1000 as gid FROM machines
-querymembers = SELECT name FROM machines WHERE 1000 = %d
-queryids = SELECT 1000 AS gid FROM machines LIMIT 0;
+querypasswd = SELECT name, NULL, machine_id + 1000 as uid, machine_id + 1000 as gid, '', '/consolefs/'|| name, '/usr/bin/sipb-xen-consolesh' FROM machines
+querygroup = SELECT name, NULL, machine_id + 1000 as gid FROM machines
+querymembers = SELECT name FROM machines WHERE 1000 + machine_id = %d
+queryids = SELECT 1000 + machine_id AS gid FROM machines LIMIT 0
 
 passwd_name = name
-passwd_uid = uid
+passwd_uid = 1000 + machine_id
 
 group_name = name
-group_gid = gid
+group_gid = 1000 + machine_id