[RADIATOR] SQL Insert

[Hugh Irvine]

Hello Ricardo -

You can add an AuthSQLStatement to your AuthBy SQL clause:


	.....
	<AuthBy SQL>
		.....
		AuthSQLStatement .......
		.....
	</AuthBy>
	.....


BTW - the current release is Radiator 4.5.1.

regards

Hugh


On 21 Nov 2009, at 07:56, Ricardo Martinez wrote:

> Hello List.
> I’m using Radiator 3.13.  I’m trying to insert a value in my Oracle DB, through radiator.
> For example if I have the next Access-Request :
>  
> Code:       Access-Request
> Identifier: 243
> Authentic:  <240><221><183><244><187><202><143><171><15><229><220>d<226><211>E<198>
> Attributes:
>         User-Name = "173"
>         Service-Type = Login-User
>         Called-Station-Id = "003490878"
>         Calling-Station-Id = "01234890"
>         NAS-IP-Address = 127.0.0.1
>         NAS-Port = 0
>  
> I would like to insert the value in the “Called-Station-Id” field in some table in my Oracle DB. 
>  
> Is possible to do this using Radiator?.  How ?
>  
> Thanks in advance,
> Ricardo Martinez
>  
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator



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.