1 ## Configuration for the SQL based IP Pool module (rlm_sqlippool)
3 ## The database schemas are available at:
11 #########################################
12 ## SQL instance to use (from sql.conf) ##
13 #########################################
14 sql-instance-name = "sql"
16 ## SQL table to use for ippool range and lease info
17 ippool_table = "radippool"
19 ## IP lease duration. (Leases expire even if Acct Stop packet is lost)
22 ## Attribute which should be considered unique per NAS
23 ## Using NAS-Port gives behaviour similar to rlm_ippool. (And ACS)
24 ## Using Calling-Station-Id works for NAS that send fixed NAS-Port
25 ## ONLY change this if you know what you are doing!
26 pool-key = "%{NAS-Port}"
27 # pool-key = "%{Calling-Station-Id}"
29 ################################################################
30 ## Uncomment the appropriate config file for your SQL dialect ##
31 ################################################################
33 # $INCLUDE sql/mysql/ippool.conf
34 $INCLUDE sql/postgresql/ippool.conf
37 ## Logging configuration. (Comment out to disable logging)
38 sqlippool_log_exists = "Existing IP: %{reply:Framed-IP-Address} \
39 (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"
41 sqlippool_log_success = "Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name} \
42 (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"
44 sqlippool_log_clear = "Released IP %{Framed-IP-Address}\
45 (did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})"
47 sqlippool_log_failed = "IP Allocation FAILED from %{control:Pool-Name} \
48 (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"
50 sqlippool_log_nopool = "No Pool-Name defined \
51 (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"