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
|
Logger Console
Logger File "mad-server.log"
#Listen *
X509TrustFile ../Cert/ca-cert.pem
#X509CrlFile ../Cert/crl.pem
X509CertFile ../Cert/cert.pem
X509KeyFile ../Cert/key.pem
UserBackendMysql {
Username test
Password test
Database test
Queries {
ListUsers "SELECT id, gid, username, fullname FROM users"
ListGroups "SELECT id, name FROM groups"
ListUserGroups "SELECT gid FROM usergroups WHERE uid = {UID}"
ListGroupUsers "SELECT uid FROM usergroups WHERE gid = {GID}"
UserById "SELECT id, gid, username, fullname FROM users WHERE id = {UID}"
UserByName "SELECT id, gid, username, fullname FROM users WHERE username = {USER}"
GroupById "SELECT id, name FROM groups WHERE id = {GID}"
GroupByName "SELECT id, name FROM groups WHERE name = {GROUP}"
UserGroupTable "SELECT uid, gid FROM usergroups"
AddUser "INSERT INTO users (id, gid, username, fullname) VALUES ({UID}, {GID}, {USER}, {FULL_NAME})"
UpdateUser "UPDATE users SET id = {UID}, gid = {GID}, username = {USER}, fullname = {FULL_NAME} WHERE id = {ORIG_UID}"
DeleteUser "DELETE FROM users WHERE id = {UID}"
AddUserToGroup "INSERT INTO usergroups (uid, gid) VALUES ({UID}, {GID})"
DeleteUserFromGroup "DELETE FROM usergroups WHERE uid = {UID} AND gid = {GID}"
}
}
Daemon test {
IpAddress 127.0.0.1
}
|
