rlm_sqlippool

Synopsis

Configuration for the SQL-based IP Pool module (rlm_sqlippool) The database schemas are available at: raddb/sql/ippool/<DB>/schema.sql.

Warning

MySQL (MyISAM) has certain limitations that mean it can hand out the same IP address to 2 different users. We suggest using an SQL DB with proper transaction support, such as PostgreSQL, or using MySQL with InnoDB.

Use the same database as configured in the sql module, database configuration directive.

Default configuration

Processing Sections

Any.

Expansions

None.

Directives

ippool_table

Syntax: ippool_table = string
Default: radippool
Description: SQL table to use for ippool range and lease info.

lease-duration

Syntax: lease-duration = integer
Default: 3600
Description: IP lease duration. (Leases expire even if Acct Stop packet is lost).

pool-key

Syntax: pool-key = string
Default: %{NAS-Port} %{Calling-Station-Id} FIXME
Description: Attribute that should be considered unique per NAS. Using NAS-Port gives behaviour similar to rlm_ippool. (And ACS) Using Calling-Station-Id works for NAS that send fixed NAS-Port. ONLY change this if you know what you are doing!

sql-instance-name

Syntax: sql-instance-name = string
Default: sql
Description: SQL instance to use (from sql.conf). If you have multiple sql instances, such as "sql sql1 {…}", use the instance name here: sql1.

messages

Synopsis

These messages are added to the control items, as Module-Success-Message. They are not logged anywhere else, unlike previous versions. If you want to have them logged to a file, see the linelog module, and create an entry that writes a Module-Success-Message message.

Directives

clear

Syntax: clear = string
Default: Released IP %{Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})
Description: FIXME

exists

Syntax: exists = string
Default: Existing IP: %\{reply:Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})
Description: FIXME

failed

Syntax: failed = string
Default: IP Allocation FAILED from %\{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})
Description: FIXME

nopool

Syntax: nopool = string
Default: No Pool-Name defined (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})
Description: FIXME

success

Syntax: success = string
Default: Allocated IP: %\{reply:Framed-IP-Address} from %\{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})
Description: FIXME