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
}