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

[Rosario Pingaro]

the first option doesn't seem to be a way for me.

I will investigate the PostAuthSelectHook.

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

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