(RADIATOR) multiple reply of the same attribute - SIP-AVP

[Hugh Irvine]

Hello Rosario -

You will find a number of example hooks in the file "goodies/ 
hooks.txt" in the Radiator 3.16 distribution.

See also section 18 in the reference manual ("doc/ref.html").

regards

Hugh


On 27 Dec 2006, at 19:34, Rosario Pingaro wrote:

> The PostAuthSelect seems above my actual knowledge, may you give me  
> a little help on how to prodice the desired results?
>
> Regards
> Rosario
>
>
>
> ----- Original Message ----- From: "Hugh Irvine" <hugh at open.com.au>
> To: "Rosario Pingaro" <rpingar at nesec.it>
> Cc: <radiator at open.com.au>
> Sent: Tuesday, December 26, 2006 5:56 PM
> Subject: Re: (RADIATOR) multiple reply of the same attribute - SIP-AVP
>
>
>>
>> Hello Rosario -
>>
>> Probably the simplest thing to do is have a stored procedure in  
>> your database return a record like this:
>>
>> SIP-AVP = ....., SIP-AVP = ......, SIP-AVP = ......
>>
>> where "....." is each of the values for a particular user.
>>
>> Then your configuration file would look like this:
>>
>>
>> <Handler Service-Type=SIP-Callee-AVPs>
>>
>>         PreAuthHook file:"/etc/radiator/user_domain.pl"
>>
>>         AuthByPolicy ContinueWhileIgnore
>>
>>         <AuthBy SQL>
>>                 DBSource        dbi:mysql:ser:xxx.xxx.xxx.xxx
>>                 DBUsername      ser
>>                 DBAuth          ser
>>
>>                 AuthSelect exec your_sp(....)
>>
>>                 AuthColumnDef 0, GENERIC, reply
>>                 NoDefault
>>         </AuthBy>
>>
>>         <AuthBy INTERNAL>
>>                 DefaultResult REJECT
>>         </AuthBy>
>>
>> </Handler>
>>
>>
>> You will need to check your database documentation and the Perl  
>> DBD documentation for the exact calling syntax in the AuthSelect  
>> line.
>>
>> Alternatively you could use a "PostAuthSelectHook" to accomplish  
>> the  same thing.
>>
>> See section 5.29.23 in the Radiator 3.16 reference manual ("doc/  
>> ref.html").
>>
>> hope that helps
>>
>> regards
>>
>> Hugh
>>
>>
>> On 27 Dec 2006, at 09:06, Rosario Pingaro wrote:
>>
>>> We would like to use radiator to exctract from a db the AVPs for   
>>> our SIP customers.
>>>
>>> The problem is that for each username I have multiple AVPs, each   
>>> AVP is stored in a different records.
>>> So radiator should reply with a number of reply attributes SIP- 
>>> AVP  equal to the records presnt into the db.
>>>
>>> But now I get only one attribute, the first it founds.
>>>
>>> this is my handler:
>>> <Handler Service-Type=SIP-Callee-AVPs>
>>>
>>>         PreAuthHook file:"/etc/radiator/user_domain.pl"
>>>
>>>         AuthByPolicy ContinueWhileIgnore
>>>
>>>         <AuthBy SQL>
>>>                 DBSource        dbi:mysql:ser:xxx.xxx.xxx.xxx
>>>                 DBUsername      ser
>>>                 DBAuth          ser
>>>                 AuthSelect select value from usr_preferences  
>>> where username='%{CheckGroup-User}' and domain='voiptest.\
>>> test.it'
>>>
>>>                 AuthColumnDef 0, SIP-AVP, reply
>>>                 NoDefault
>>>
>>>
>>>         </AuthBy>
>>>
>>>         <AuthBy INTERNAL>
>>>                 DefaultResult REJECT
>>>         </AuthBy>
>>>
>>> </Handle>
>>>
>>>
>>> How to improve my config to get what I need??
>>>
>>> Regards
>>>
>>> Rosario
>>>
>>
>>
>>
>> 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?
>>
>> -- 
>> 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.
>>
>



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?

-- 
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.