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 }