1 ## Configuration for the SQL based IP Pool module (rlm_sqlippool)
3 ## The database schemas are available at:
5 ## raddb/sql/DB/ippool.sql
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 ##
32 # WARNING: MySQL has certain limitations that means it can
33 # hand out the same IP address to 2 different users.
35 # We suggest using an SQL DB with proper transaction
36 # support, such as PostgreSQL.
38 ################################################################
40 # $INCLUDE sql/mysql/ippool.conf
41 $INCLUDE sql/postgresql/ippool.conf
44 ## Logging configuration. (Comment out to disable logging)
45 sqlippool_log_exists = "Existing IP: %{reply:Framed-IP-Address} \
46 (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"
48 sqlippool_log_success = "Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name} \
49 (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"
51 sqlippool_log_clear = "Released IP %{Framed-IP-Address}\
52 (did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})"
54 sqlippool_log_failed = "IP Allocation FAILED from %{control:Pool-Name} \
55 (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"
57 sqlippool_log_nopool = "No Pool-Name defined \
58 (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"