(RADIATOR) More parameters from AddressAllocator SQL to AuthBy Dynaddress?

[Hugh Irvine]

Hello Toomas -

What I have done in the past for this sort of more complex scenario  
is make use of stored procedures in the database that are called from  
a single AuthBy SQL clause.

It is then the stored procedure that does everything required to  
return all reply attributes including IP address, netmask, gateway,  
filters,etc.

This makes the Radiator configuration much simpler (and faster), at  
the expense of some additional complexity in the database.

regards

Hugh


On 22 Apr 2008, at 22:36, Toomas Kärner wrote:

> Hello Hugh,
>
> I don't use PoolHint for anything jet. I'm just looking over the
> possibilities for getting the results I need and it seemed like a nice
> development to add some extra "slots" between AddressAllocator SQL and
> AuthBy Dynaddress for carrying some extra parameters.
> But as you said already, I can always use AuthBy Groups togethet with
> AuthBy SQL to fetch these parameters later. It's just more queries  
> where
> I could do with less.
>
> Rgds.
> Toomas
>
> Tuesday, April 22, 2008, 2:33:53 AM, you wrote:
>
>> Hello Toomas -
>
>> Thanks for the additional information.
>
>> As mentioned in my previous mail, I would just use a supplementary
>> AuthBy SQL clause to use the PoolHint to get the additional
>> attributes from the additional table.
>
>> What are you using for the PoolHint currently?
>
>> regards
>
>> Hugh
>
>
>
>> On 21 Apr 2008, at 18:54, Toomas Kärner wrote:
>
>>> Hello Hugh,
>>>
>>> It's a case of DHCP setup where the NAS has several IP pools and
>>> together with the Framed-IP-Address I need to give default gateway
>>> (dependent on the pool from which I got the address) and some other
>>> VSA's that are depending on the Pool only (not the subscriber). I'd
>>> use the pool-hint as the pool_id to join them from another table  
>>> where
>>> I would keep a set of parameters that are the same for all IP's in
>>> that pool but differ from pool to pool. But that's already technical
>>> after I have found a way how to pass them on.
>>>
>>> Rgds.
>>> Toomas
>>>
>>> Friday, April 18, 2008, 8:50:02 AM, you wrote:
>>>
>>>> Hello Toomas -
>>>
>>>> You can't do this directly with the current code, but you can use a
>>>> supplementary AuthBy SQL to do whatever you need to.
>>>
>>>> Typically, VSA's are part of a user record or a group definition,
>>>> rather than an IP address definition.
>>>
>>>> Could you give me a bit more detail on your requirments?
>>>
>>>> regards
>>>
>>>> Hugh
>>>
>>>
>>>> On 17 Apr 2008, at 19:26, Toomas Kärner wrote:
>>>>> Hi,
>>>>>
>>>>> Simple question: Currently I can see that from AddressAllocator
>>>>> SQL to
>>>>> AuthBy Dynaddress are returned 2 attributes (that get then  
>>>>> mapped).
>>>>> I'd like to return more attributes than 2 (default gw + some  
>>>>> VSA's),
>>>>> how?
>>>>>
>>>>>
>>>>> Best regards,
>>>>> Toomas
>>>>>
>>>>>
>>>>> --
>>>>> Archive at http://www.open.com.au/archives/radiator/
>>>>> Announcements on radiator-announce at open.com.au
>>>>> To unsubscribe, email 'majordomo at open.com.au' with
>>>>> 'unsubscribe radiator' in the body of the message.
>>>
>>>
>>>
>>>> NB:
>>>
>>>> Have you read the reference manual ("doc/ref.html")?
>>>> Have you searched the mailing list archive (www.open.com.au/ 
>>>> archives/
>>>> radiator)?
>>>> Have you had a quick look on Google (www.google.com)?
>>>> Have you included a copy of your configuration file (no secrets),
>>>> together with a trace 4 debug showing what is happening?
>>>> Have you checked the RadiusExpert wiki:
>>>> http://www.open.com.au/wiki/index.php/Main_Page
>>>
>>>
>>>
>>> --
>>> Archive at http://www.open.com.au/archives/radiator/
>>> Announcements on radiator-announce at open.com.au
>>> To unsubscribe, email 'majordomo at open.com.au' with
>>> 'unsubscribe radiator' in the body of the message.
>
>
>
>> NB:
>
>> Have you read the reference manual ("doc/ref.html")?
>> Have you searched the mailing list archive (www.open.com.au/archives/
>> radiator)?
>> Have you had a quick look on Google (www.google.com)?
>> Have you included a copy of your configuration file (no secrets),
>> together with a trace 4 debug showing what is happening?
>> Have you checked the RadiusExpert wiki:
>> http://www.open.com.au/wiki/index.php/Main_Page
>
>
>



NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/ 
radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?
Have you checked the RadiusExpert wiki:
http://www.open.com.au/wiki/index.php/Main_Page

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.



--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.