<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Ivan,<br>
Many thanks for your suggestion. However, (using 2.1.3) my
sqlippool.conf file is now:<br>
sqlippool {<br>
#########################################<br>
## SQL instance to use (from sql.conf) ##<br>
#########################################<br>
sql-instance-name = "sql"<br>
Pool-Name = %{control:Huntgroup-Name}<br>
## SQL table to use for ippool range and lease info<br>
ippool_table = "radippool"<br>
## IP lease duration. (Leases expire even if Acct Stop packet
is lost)<br>
lease-duration = 3600<br>
## Attribute which should be considered unique per NAS<br>
## Using NAS-Port gives behaviour similar to rlm_ippool. (And
ACS)<br>
## Using Calling-Station-Id works for NAS that send fixed
NAS-Port<br>
## ONLY change this if you know what you are doing!<br>
# pool-key = "%{NAS-Port}"<br>
pool-key = "%{Calling-Station-Id}-%{control:Huntgroup-Name}"<br>
# "%{request:Huntgroup-Name}"<br>
$INCLUDE sql/mysql/ippool.conf<br>
## Logging configuration. (Comment out to disable logging)<br>
sqlippool_log_exists = "Existing IP: %{reply:Framed-IP-Address}
(did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port}
user %{User-Name})"<br>
sqlippool_log_success = "Allocated IP:
%{reply:Framed-IP-Address} from %{control:Pool-Name} (did
%{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user
%{User-Name})"<br>
sqlippool_log_clear = "Released IP %{Framed-IP-Address} (did
%{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})"<br>
sqlippool_log_failed = "IP Allocation FAILED from
%{control:Pool-Name} (did %{Called-Station-Id} cli
%{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"<br>
sqlippool_log_nopool = "No Pool-Name defined (did
%{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user
%{User-Name} hunt %{Huntgroup-Name} pool %{Pool-Name})"<br>
}<br>
<br>
When running with debugging on, I get:<br>
.....<br>
Wed Feb 18 14:21:03 2009 : Debug: (Loaded rlm_sqlippool, checking
if it's valid)<br>
Wed Feb 18 14:21:03 2009 : Debug: Module: Linked to module
rlm_sqlippool<br>
Wed Feb 18 14:21:03 2009 : Debug: Module: Instantiating sqlippool<br>
Wed Feb 18 14:21:03 2009 : Debug: sqlippool {<br>
Wed Feb 18 14:21:03 2009 : Debug: sql-instance-name = "sql"<br>
Wed Feb 18 14:21:03 2009 : Debug: lease-duration = 3600<br>
Wed Feb 18 14:21:03 2009 : Debug: pool-name =
"%{control:Huntgroup-Name}"<br>
Wed Feb 18 14:21:03 2009 : Debug: allocate-begin = "START
TRANSACTION"<br>
Wed Feb 18 14:21:03 2009 : Debug: allocate-clear = "UPDATE
radippool SET expiry_time = NOW() WHERE callingstationid =
'%{Calling-Station-Id}' AND pool_name = '%{control:Pool-Name}'"<br>
Wed Feb 18 14:21:03 2009 : Debug: allocate-find = "SELECT
framedipaddress FROM radippool WHERE pool_name =
'%{control:Pool-Name}' AND callingstationid = '%{Calling-Station-Id}'
LIMIT 1 FOR UPDATE"<br>
Wed Feb 18 14:21:03 2009 : Debug: allocate-update = "UPDATE
radippool SET nasipaddress = '%{NAS-IP-Address}', username =
'%{User-Name}' WHERE framedipaddress = '%I'"<br>
Wed Feb 18 14:21:03 2009 : Debug: allocate-commit = "COMMIT"<br>
Wed Feb 18 14:21:03 2009 : Debug: allocate-rollback = "ROLLBACK"<br>
Wed Feb 18 14:21:03 2009 : Debug: pool-check = ""<br>
Wed Feb 18 14:21:03 2009 : Debug: start-begin = "START
TRANSACTION"<br>
Wed Feb 18 14:21:03 2009 : Debug: start-update = "UPDATE
radippool SET expiry_time = NOW() + INTERVAL 3600 SECOND WHERE
nasipaddress = '%{NAS-IP-Address}' AND pool_key =
'%{Calling-Station-Id}-%{control:Huntgroup-Name}'"<br>
Wed Feb 18 14:21:03 2009 : Debug: start-commit = "COMMIT"<br>
Wed Feb 18 14:21:03 2009 : Debug: start-rollback = "ROLLBACK"<br>
Wed Feb 18 14:21:03 2009 : Debug: alive-begin = "START
TRANSACTION"<br>
Wed Feb 18 14:21:03 2009 : Debug: alive-update = "UPDATE
radippool SET expiry_time = NOW() + INTERVAL 3600 SECOND WHERE
nasipaddress = '%{Nas-IP-Address}' AND pool_key =
'%{Calling-Station-Id}-%{control:Huntgroup-Name}' AND username =
'%{User-Name}' AND callingstationid = '%{Calling-Station-Id}' AND
framedipaddress = '%{Framed-IP-Address}'"<br>
Wed Feb 18 14:21:03 2009 : Debug: alive-commit = "COMMIT"<br>
Wed Feb 18 14:21:03 2009 : Debug: alive-rollback = "ROLLBACK"<br>
Wed Feb 18 14:21:03 2009 : Debug: stop-begin = "START TRANSACTION"<br>
Wed Feb 18 14:21:03 2009 : Debug: stop-clear = "UPDATE radippool
SET nasipaddress = '', pool_key = 0, callingstationid = '', username =
'', expiry_time IS NULL WHERE nasipaddress = '%{Nas-IP-Address}' AND
pool_key = '%{Calling-Station-Id}-%{control:Huntgroup-Name}' AND
username = '%{User-Name}' AND callingstationid =
'%{Calling-Station-Id}' AND framedipaddress = '%{Framed-IP-Address}'"<br>
Wed Feb 18 14:21:03 2009 : Debug: stop-commit = "COMMIT"<br>
Wed Feb 18 14:21:03 2009 : Debug: stop-rollback = "ROLLBACK"<br>
Wed Feb 18 14:21:03 2009 : Debug: on-begin = "START TRANSACTION"<br>
Wed Feb 18 14:21:03 2009 : Debug: on-clear = "UPDATE radippool
SET nasipaddress = '', pool_key = 0, callingstationid = '', username =
'', expiry_time IS NULL WHERE nasipaddress = '%{Nas-IP-Address}'"<br>
Wed Feb 18 14:21:03 2009 : Debug: on-commit = "COMMIT"<br>
Wed Feb 18 14:21:03 2009 : Debug: on-rollback = "ROLLBACK"<br>
Wed Feb 18 14:21:03 2009 : Debug: off-begin = "START TRANSACTION"<br>
Wed Feb 18 14:21:03 2009 : Debug: off-clear = "UPDATE radippool
SET nasipaddress = '', pool_key = 0, callingstationid = '', username =
'', expiry_time IS NULL WHERE nasipaddress = '%{Nas-IP-Address}'"<br>
Wed Feb 18 14:21:03 2009 : Debug: off-commit = "COMMIT"<br>
Wed Feb 18 14:21:03 2009 : Debug: off-rollback = "ROLLBACK"<br>
Wed Feb 18 14:21:03 2009 : Debug: sqlippool_log_exists =
"Existing IP: %{reply:Framed-IP-Address} (did %{Called-Station-Id} cli
%{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"<br>
Wed Feb 18 14:21:03 2009 : Debug: sqlippool_log_success =
"Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name}
(did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port}
user %{User-Name})"<br>
Wed Feb 18 14:21:03 2009 : Debug: sqlippool_log_clear = "Released
IP %{Framed-IP-Address} (did %{Called-Station-Id} cli
%{Calling-Station-Id} user %{User-Name})"<br>
Wed Feb 18 14:21:03 2009 : Debug: sqlippool_log_failed = "IP
Allocation FAILED from %{control:Pool-Name} (did %{Called-Station-Id}
cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"<br>
Wed Feb 18 14:21:03 2009 : Debug: sqlippool_log_nopool = "No
Pool-Name defined (did %{Called-Station-Id} cli %{Calling-Station-Id}
port %{NAS-Port} user %{User-Name} hunt %{Huntgroup-Name} pool
%{Pool-Name})"<br>
Wed Feb 18 14:21:03 2009 : Debug: defaultpool = "main_pool"<br>
Wed Feb 18 14:21:03 2009 : Debug: }<br>
.....<br>
Wed Feb 18 14:21:17 2009 : Auth: Login OK:
[searthrowl/Anything-you-like] (from client localhost port 12345 cli
447XXXXXXXX)<br>
Wed Feb 18 14:21:17 2009 : Info: +- entering group post-auth {...}<br>
Wed Feb 18 14:21:17 2009 : <b>Info: [sqlippool] No Pool-Name defined.</b><br>
Wed Feb 18 14:21:17 2009 : Info: [sqlippool] expand: No Pool-Name
defined (did %{Called-Station-Id} cli %{Calling-Station-Id} port
%{NAS-Port} user %{User-Name} hunt %{Huntgroup-Name} pool %{Pool-Name})
-> No Pool-Name defined (did domain.co.uk cli 447XXXXXXX port 12345
user searthrowl hunt domain.co.ukA pool )<br>
Wed Feb 18 14:21:17 2009 : Info: No Pool-Name defined (did domain.co.uk
cli 447XXXXXX port 12345 user searthrowl hunt domain.co.ukA pool )<br>
Wed Feb 18 14:21:17 2009 : Info: ++[sqlippool] returns noop<br>
<br>
Any thoughts?<br>
<br>
Kind regards<br>
<br>
Simon<br>
<br>
<a class="moz-txt-link-abbreviated" href="mailto:tnt@kalik.net">tnt@kalik.net</a> wrote:
<blockquote id="mid_H1R8MIEI_1234824957_2008290_tnt_kalik_net"
cite="mid:H1R8MIEI.1234824957.2008290.tnt@kalik.net" type="cite">
<blockquote id="StationeryCiteGenerated_1" type="cite">
<pre wrap="">What I would love to do is set up Huntgroups (OK so that bit works too!)
and then in the sqlippool.conf just assign pool-name = %{Huntgroup-Name}
This doesn't work, and all I get is pool-name is undefined.
Does anyone have any ideas?
</pre>
</blockquote>
<pre wrap=""><!---->
%{control:Huntgroup-Name}
Ivan Kalik
Kalik Informatika ISP
-
List info/subscribe/unsubscribe? See <a class="moz-txt-link-freetext" href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a>
</pre>
</blockquote>
<br>
</body>
</html>