[RADIATOR] Change in Execution sequence

[Hugh Irvine]

Hello Krishan -

You can do this sort of thing by using specific AuthBy SQL clauses rather than the standard session database like this:


.....

# define SessionDatabases

<SessionDatabase SQL>
	Identifier SQLSDB
	.....
</SessionDatabase>

<SessionDatabase NULL>
	Identifier NULLSDB
	.....
</SessionDatabase>

....

# define Handlers

# process accounting stops

<Handler Acct-Status-Type = Stop>
	SessionDatabase NULLSDB
	AuthByPolicy ContinueAlways
	<AuthBy SQL>
		# insert stops
		.....
	</AuthBy>
	<AuthBy SQL>
		# delete session from RADONLINE
		.....
	</AuthBy>
</Handler>

# process other accounting

<Handler Request-Type = Accounting-Request>
	SessionDatabase SQLSDB
	<AuthBy SQL>
		.....
	</AuthBy>
</Handler>

# process authentication

<Handler>
	SessionDatabase SQLSDB
	<AuthBy SQL>
		.....
	</AuthBy>
</Handler>


hope that helps

regards

Hugh


On 24 Feb 2010, at 08:17, Krishan Kant (Kappa, Kota) wrote:

> Hi,
>  
> We are using Radiator Radius with default realm Authby SQL & Sessiondatabase SQL. We have noticed that SQL deletequery of sessiondatabase for deleting entry from RADONLINE executes first than insert stop entry in ACCOUNTING table. Is there any way to change this sequence, so insert stop entry in ACCOUNTING happens before execution of deleting entry from RADONLINE i.e. deletequery of sessiondatabase.
>  
> Thanks in the anticipation of world wide help.
>  
> Regards,
>  
> Krishan Kant Agrawal
>  
> Kappa Internet Services Private Limited
> "Kappa House", 1-RA-8 Vigyan Nagar
> KOTA - 324 005, INDIA
>  
> Phone : +91-744-2436000 / 3236000
> Fax     : +91-744-2426000
> Mobile : +91-9672970111
> URL    : www.kappa.net.in , www.cable4net.in
>  
>  
>  
>  
> _______________________________________________
> 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.