# example configfile for PostgreSQL NSS module # these are entries as used with the BOFHMS tool (sf.net/projects/bofhms) 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; passwd_name = name passwd_uid = uid group_name = name group_gid = gid