| 4 |
- |
1 |
## Configuration for the SQL based IP Pool module (rlm_sqlippool)
|
|
|
2 |
##
|
|
|
3 |
## The database schemas are available at:
|
|
|
4 |
##
|
|
|
5 |
## raddb/sql/DB/ippool.sql
|
|
|
6 |
##
|
| 34 |
- |
7 |
## $Id: 94fabc032f681407e9e6141d85ac1841c0b6d28b $
|
| 4 |
- |
8 |
|
|
|
9 |
sqlippool {
|
|
|
10 |
|
|
|
11 |
#########################################
|
|
|
12 |
## SQL instance to use (from sql.conf) ##
|
|
|
13 |
##
|
|
|
14 |
## If you have multiple sql instances, such as "sql sql1 {...}",
|
|
|
15 |
## use the *instance* name here: sql1.
|
|
|
16 |
#########################################
|
|
|
17 |
sql-instance-name = "sql"
|
|
|
18 |
|
|
|
19 |
## SQL table to use for ippool range and lease info
|
|
|
20 |
ippool_table = "radippool"
|
|
|
21 |
|
|
|
22 |
## IP lease duration. (Leases expire even if Acct Stop packet is lost)
|
|
|
23 |
lease-duration = 3600
|
|
|
24 |
|
|
|
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}"
|
|
|
31 |
|
|
|
32 |
################################################################
|
|
|
33 |
#
|
|
|
34 |
# WARNING: MySQL has certain limitations that means it can
|
|
|
35 |
# hand out the same IP address to 2 different users.
|
|
|
36 |
#
|
|
|
37 |
# We suggest using an SQL DB with proper transaction
|
|
|
38 |
# support, such as PostgreSQL, or using MySQL
|
|
|
39 |
# with InnoDB.
|
|
|
40 |
#
|
|
|
41 |
################################################################
|
|
|
42 |
|
|
|
43 |
#
|
|
|
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.
|
|
|
48 |
#
|
|
|
49 |
$INCLUDE sql/postgresql/ippool.conf
|
|
|
50 |
|
|
|
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})"
|
|
|
54 |
|
|
|
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})"
|
|
|
57 |
|
|
|
58 |
sqlippool_log_clear = "Released IP %{Framed-IP-Address}\
|
|
|
59 |
(did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})"
|
|
|
60 |
|
|
|
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})"
|
|
|
63 |
|
|
|
64 |
sqlippool_log_nopool = "No Pool-Name defined \
|
|
|
65 |
(did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"
|
|
|
66 |
|
|
|
67 |
}
|