Skip to content

Realmd (Logon) Database

The realmd (login/auth) database stores accounts, bans, GM access levels and the realm list. The realmd process authenticates clients here before handing them to a world server.

Tables

  • account - Account credentials and per-account settings (username, password hash/verifier, expansion, locale).
  • account_access - GM level and realm assignment per account (console/GM permissions).
  • account_banned - Account ban records with reason and expiration.
  • allowed_clients - Whitelist of exact client builds/platforms permitted to log on through realmd.
  • geoip - IP range to country mapping cache used by the login server.
  • ip_banned - Banned IP addresses/networks.
  • migrations - Applied migration IDs for the realmd database.
  • rbac_account_permissions - Grants or revokes RBAC permissions per account.
  • rbac_command_permissions - Binds chat/console commands to the RBAC permission required to execute them.
  • rbac_permissions - Definitions of RBAC permissions referenced by account grants and command bindings.
  • realmcharacters - How many characters each account has per realm (enforces character-per-realm limit).
  • realmlist - Registered realms served by this auth server (name, address, type, security level).
  • uptime - Uptime history of the realm(s): start time, player peak, revision.