LoadModule "FileLogger" LoadModule "SystemBackendPosix" LoadModule "SystemBackendProc" LoadModule "UserDBBackendMysql" LoadModule "UserConfigBackendHome" LoadModule "UserConfigBackendKrb5" Logger Console Logger File "mad-server.log" Listen 127.0.0.1 X509TrustFile ../Cert/ca-cert.pem #X509CrlFile ../Cert/crl.pem X509CertFile ../Cert/cert.pem X509KeyFile ../Cert/key.pem UserManager { MinUid 1000 MaxUid 29999 MinGid 1000 MaxGid 29999 HomeDir "/tmp/home" Skeleton "/tmp/skel" UserDirMode 0700 Mysql { 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}" AddGroup "INSERT INTO groups (id, name) VALUES ({GID}, {GROUP})" UpdateGroup "UPDATE groups SET id = {GID}, name = {GROUP} WHERE id = {ORIG_GID}" DeleteGroup "DELETE FROM groups WHERE id = {GID}" AddUserToGroup "INSERT INTO usergroups (uid, gid) VALUES ({UID}, {GID})" DeleteUserFromGroup "DELETE FROM usergroups WHERE uid = {UID} AND gid = {GID}" } } Krb5 { Principal "root/admin" Password "test" } } Daemon test { IpAddress 127.0.0.1 }