Use the RADIUS SQL IP Pool module to allocate addresses for DHCP

[freeradius.git] / raddb / modules / dhcp_sqlippool

diff --git a/raddb/modules/dhcp_sqlippool b/raddb/modules/dhcp_sqlippool
new file mode 100644 (file)
index 0000000..f1193de
--- /dev/null
+++ b/raddb/modules/dhcp_sqlippool
@@ -0,0 +1,30 @@
+##  Configuration for DHCP to use SQL IP Pools.
+##
+##  See sqlippool.conf for common configuration explanation
+##
+##  $Id$
+
+sqlippool sqlippool-dhcp {
+       sql-instance-name = "sql"
+
+       ippool_table = "radippool"
+
+       lease-duration = 7200
+
+       # Client's MAC address is mapped to Calling-Station-Id in policy.conf
+       pool-key = "%{Calling-Station-Id}"
+
+       # For now, it only works with MySQL.
+       $INCLUDE ${confdir}/sql/mysql/ippool-dhcp.conf
+ 
+       sqlippool_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})"
+
+}