Blame | Last modification | View Log | RSS feed
## Configuration for DHCP to use SQL IP Pools.#### See sqlippool.conf for common configuration explanation#### $Id: 39358b222d016d62e5cf6e8c77fd214cc7614feb $sqlippool dhcp_sqlippool {sql-instance-name = "sql"ippool_table = "radippool"lease-duration = 7200# Client's MAC address is mapped to Calling-Station-Id in policy.confpool-key = "%{Calling-Station-Id}"# For now, it only works with MySQL. Requires freeradius-mysql.#$INCLUDE ${confdir}/sql/mysql/ippool-dhcp.confsqlippool_log_exists = "DHCP: Existing IP: %{reply:Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"sqlippool_log_success = "DHCP: Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"sqlippool_log_clear = "DHCP: Released IP %{Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})"sqlippool_log_failed = "DHCP: IP Allocation FAILED from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"sqlippool_log_nopool = "DHCP: No Pool-Name defined (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"}