Pool-Name woes with sqlippool

[Simon Earthrowl]

Hi Ivan,

tnt at kalik.net wrote:
>> Many thanks for your suggestion. However, (using 2.1.3) my
>> sqlippool.conf file is now:
>> sqlippool {
>>        #########################################
>>        ## SQL instance to use (from sql.conf) ##
>>        #########################################
>>        sql-instance-name = "sql"
>>     
>
>   
>>        Pool-Name = %{control:Huntgroup-Name}
>>     
>
> Where did that come from? That should be in the users entry (radcheck or
> radgroupcheck).
>   
I've tried adding to the radcheck table ( INSERT into `radcheck` SET 
`id` = 0, `username` = '447XXXXXXXX', `op` = ':=', `value` = 
'%{control:Huntgroup-Name}`;  )
and then I get
...
Wed Feb 18 16:14:34 2009 : Info: [sqlippool]    expand: SELECT 
framedipaddress FROM radippool   WHERE pool_name = 
'%{control:Pool-Name}' AND callingstationid = '%{Calling-Station-Id}' 
LIMIT 1 FOR UPDATE -> SELECT framedipaddress FROM radippool     WHERE 
pool_name = '=25=7Bcontrol:Huntgroup-Name=7D' AND callingstationid = 
'447775777672' LIMIT 1 FOR UPDATE
Wed Feb 18 16:14:34 2009 : Debug: rlm_sql_mysql: query:  SELECT 
framedipaddress FROM radippool  WHERE pool_name = 
'=25=7Bcontrol:Huntgroup-Name=7D' AND callingstationid = '447XXXXXXX' 
LIMIT 1 FOR UPDATE
Wed Feb 18 16:14:34 2009 : Info: [sqlippool] SQL query did not return 
any results
....

The same result was obtained when radgroupcheck is used

> Wed Feb 18 14:21:17 2009 : Info: +- entering group post-auth {...}
> Wed Feb 18 14:21:17 2009 : *Info: [sqlippool] No Pool-Name defined.*
>   
>
> You haven't entered that Pool-Name (name of your huntgroup) in the
> radippool table.
>
> Ivan Kalik
> Kalik Informatika ISP
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20090218/c4b6a729/attachment.html>