Chetan Gaonker | 7f4bf74 | 2016-05-04 15:56:08 -0700 | [diff] [blame] | 1 | ## Configuration for DHCP to use SQL IP Pools. |
| 2 | ## |
| 3 | ## See sqlippool.conf for common configuration explanation |
| 4 | ## |
| 5 | ## $Id: 8d459c06a16b77eff7b976e32838dbc1195d901f $ |
| 6 | |
| 7 | sqlippool dhcp_sqlippool { |
| 8 | sql_instance_name = "sql" |
| 9 | |
| 10 | ippool_table = "radippool" |
| 11 | |
| 12 | lease_duration = 7200 |
| 13 | |
| 14 | # Client's MAC address is mapped to Calling-Station-Id in policy.conf |
| 15 | pool_key = "%{Calling-Station-Id}" |
| 16 | |
| 17 | # For now, it works with MySQL. |
| 18 | $INCLUDE ${modconfdir}/sql/ippool-dhcp/mysql/queries.conf |
| 19 | |
| 20 | # It may also work with sqlite - this is very experimental. |
| 21 | # Comment out the above line and add the following include. |
| 22 | # To use sqlite you need to add '%' to safe_characters in |
| 23 | # raddb/mods-config/sql/main/sqlite/queries.conf. |
| 24 | # $INCLUDE ${modconfdir}/sql/ippool-dhcp/sqlite/queries.conf |
| 25 | |
| 26 | sqlippool_log_exists = "DHCP: Existing IP: %{reply:Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" |
| 27 | |
| 28 | 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})" |
| 29 | |
| 30 | sqlippool_log_clear = "DHCP: Released IP %{Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})" |
| 31 | |
| 32 | 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})" |
| 33 | |
| 34 | sqlippool_log_nopool = "DHCP: No Pool-Name defined (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" |
| 35 | |
| 36 | } |