rlm_sqlippool Question

[Richard J Palmer]

HI

One more question (sorry)

With each accounts call I am calling the sqlippool module. This is 
wasteful as most sessions on the server *currently* are not from an IP 
pool.

The connections that are in the pool all have Framed-IPs which are 
'172.x'

I have added ...


    if (Framed-IP-Address =~ /172\.\d{1,3}\.\d{1,3}\.\d{1,3}\b/) {     
   sqlippool
    }
Which seems to work and I am now only seeing the sqlippool calls when 
the IP is that match...

Now my knowledge of regex is not the greatest - so I would really 
appreciate someone here taking a quick look and saying if that looks 
correct


Thanks in advance

Richard


On Saturday 06/04/2019 at 11:39 pm, Richard J Palmer  wrote:
>
> Hi Alan
>
> That fixes it - thank you as ever for your help
>
> It is appreciated
>
>
> Richard
>>
>> --- Original message ---
>> Subject: Re: rlm_sqlippool Question
>> From: Alan DeKok <aland at deployingradius.com>
>> To: FreeRadius users mailing list
>> <freeradius-users at lists.freeradius.org>
>> Date: Saturday, 06/04/2019 10:53 PM
>>
>> On Apr 6, 2019, at 5:40 PM, Richard J Palmer <richard at merula.net>
>> wrote:
>>>
>>>
>>>
>>> Going back more (sorry I am talking to myself .....
>>>
>>> The config works file with 3.0.15
>>> BUT breaks with that error with 3.0.16 onwards
>>
>>        Use the v3.0.x branch from GitHub.  It has a fix.  We're 
>> releasing
>> 3.0.19 next week.
>>
>>        Alan DeKok.
>>
>>
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>
> -
> List info/subscribe/unsubscribe? See 
> http://www.freeradius.org/list/users.html