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" } } Daemon test { IpAddress 127.0.0.1 }