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
|
#----------------- DB connection
host = 127.0.0.1
# For socket give the directory to put the socket
#host = /tmp
port = 5432
database = gforge
login = gforge_nss
passwd = ''
#----------------- New possibility including the query directly here ------------------#
# query
# return the passwd array
querypasswd = SELECT login,passwd,uid,gid,gecos,('/var/lib/gforge/chroot/home/users/' || login),shell FROM nss_passwd
# return the group array whithout list of members
querygroup = SELECT name,'x',gid FROM nss_groups
# return an array of users that are member of a group with gid %d
querymembers = SELECT user_name FROM nss_usergroups WHERE gid = %d
# return an array of numeric gid a user %s is member of except his own gid %d
queryids = SELECT gid FROM nss_usergroups WHERE user_name = '%s' AND gid != %d
#----------------- Only the following tables map are necessary ------------------------#
# passwd
passwd_name = login
passwd_uid = uid
# group
group_name = name
group_gid = gid
#--------------------------------------------------------------------------------------#
#----------------- Old Method ------------------#
# tables
#passwdtable = nss_passwd
#grouptable = nss_groups
#groupmembertable = nss_passwd JOIN nss_usergroups ON nss_passwd.uid=nss_usergroups.uid JOIN nss_groups ON nss_usergroups.gid=nss_groups.gid
# passwd
#passwd_name = login
#passwd_passwd = passwd
#passwd_uid = uid
#passwd_gid = gid
#passwd_gecos = gecos
#passwd_dir = homedir
# New extention that allow concatenation
#passwd_dir = ('/home/users/' || login)
#passwd_shell = shell
# group
#group_name = name
#group_passwd = passwd
#group_gid = gid
#group_member = login
|
