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) ##
14 ## If you have multiple sql instances, such as "sql sql1 {...}",
15 ## use the *instance* name here: sql1.
16 #########################################
17 sql-instance-name = "sql"
19 ## SQL table to use for ippool range and lease info
20 ippool_table = "radippool"
22 ## IP lease duration. (Leases expire even if Acct Stop packet is lost)
25 ## Attribute which should be considered unique per NAS
26 ## Using NAS-Port gives behaviour similar to rlm_ippool. (And ACS)
27 ## Using Calling-Station-Id works for NAS that send fixed NAS-Port
28 ## ONLY change this if you know what you are doing!
29 pool-key = "%{NAS-Port}"
30 # pool-key = "%{Calling-Station-Id}"
32 ################################################################
34 # WARNING: MySQL has certain limitations that means it can
35 # hand out the same IP address to 2 different users.
37 # We suggest using an SQL DB with proper transaction
38 # support, such as PostgreSQL, or using MySQL
41 ################################################################
44 # Use the same database as configured in the "sql" module, "database"
45 # configuration item. Change the "postgresql" name below to be the
46 # same as the "database" field of the SQL module referred to in the
47 # "sql-instance-name", above.
49 $INCLUDE sql/postgresql/ippool.conf
51 ## Logging configuration. (Comment out to disable logging)
52 sqlippool_log_exists = "Existing IP: %{reply:Framed-IP-Address} \
53 (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"
55 sqlippool_log_success = "Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name} \
56 (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"
58 sqlippool_log_clear = "Released IP %{Framed-IP-Address}\
59 (did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})"
61 sqlippool_log_failed = "IP Allocation FAILED from %{control:Pool-Name} \
62 (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"
64 sqlippool_log_nopool = "No Pool-Name defined \
65 (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"