1 # Configuration for the SQL based IPPool module (rlm_sqlippool)
3 # The database schemas are available at:
11 ## SQL instance to use (from sql.conf)
12 sql-instance-name = "sql"
14 ## Table to keep ippool info
15 ippool_table = "radippool"
17 ## lease_duration. fix for lost acc-stop packets
20 ## Attribute which should be considered unique per NAS
21 ## Using NAS-Port gives behaviour similar to rlm_ippool.
22 ## Using Calling-Station-Id works for NAS that send fixed NAS-Port
23 pool-key = "%{NAS-Port}"
24 # pool-key = "%{Calling-Station-Id}"
26 ## Logging configuration.
27 sqlippool_log_exists = "Existing IP: %{reply:Framed-IP-Address} \
28 (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"
30 sqlippool_log_success = "Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name} \
31 (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"
33 sqlippool_log_clear = "Released IP %{Framed-IP-Address}\
34 (did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})"
36 sqlippool_log_failed = "IP Allocation FAILED from %{control:Pool-Name} \
37 (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"
39 sqlippool_log_nopool = "No Pool-Name defined \
40 (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"
43 ################################################################
44 ## Uncomment the appropriate config file for your SQL dialect ##
45 ################################################################
47 # $INCLUDE ${confdir}/sql/mysql-ippool-dialup.conf
48 $INCLUDE ${confdir}/sql/postgresql-ippool-dialup.conf