1 #----------------- DB connection
3 # For socket give the directory to put the socket
10 #----------------- New possibility including the query directly here ------------------#
12 # return the passwd array
13 querypasswd = SELECT login,passwd,uid,gid,gecos,('/var/lib/gforge/chroot/home/users/' || login),shell FROM nss_passwd
14 # return the group array whithout list of members
15 querygroup = SELECT name,'x',gid FROM nss_groups
16 # return an array of users that are member of a group with gid %d
17 querymembers = SELECT user_name FROM nss_usergroups WHERE gid = %d
18 # return an array of numeric gid a user %s is member of except his own gid %d
19 queryids = SELECT gid FROM nss_usergroups WHERE user_name = '%s' AND gid != %d
20 #----------------- Only the following tables map are necessary ------------------------#
27 #--------------------------------------------------------------------------------------#
29 #----------------- Old Method ------------------#
31 #passwdtable = nss_passwd
32 #grouptable = nss_groups
33 #groupmembertable = nss_passwd JOIN nss_usergroups ON nss_passwd.uid=nss_usergroups.uid JOIN nss_groups ON nss_usergroups.gid=nss_groups.gid
37 #passwd_passwd = passwd
43 # New extention that allow concatenation
44 #passwd_dir = ('/home/users/' || login)
49 #group_passwd = passwd