(RADIATOR) SessionDatabase replacing records on Alive packets

[Hugh Irvine]

Hello David -

I generally do something like this:


# define session databases

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

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

# define Handlers

<Handler Acct-Status-Type = Alive>
	SessionDatabase NULLSDB
	.....
</Handler>

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

<Handler>
	SessionDatabase SQLSDB
	.....
</Handler>


hope that helps

regards

Hugh


On 2 May 2008, at 19:50, David Craigon wrote:

> Hello,
>
> I'm running a standalone radius accounting server. What I want to  
> achieve is to have a row in a database in a table appear when I get  
> a start packet, and for it to be deleted again when I get a stop  
> packet.
>
> To this end, I am using a sessiondb.
>
> The only problem I am having is that every time an Alive packet  
> shows up, the Delete query followed by the Insert query gets run.  
> Since I record when the session started using the SQL statement,  
> I'd like it not to do this.
>
> I don't want to ignore Alive packets altogether, since I do  
> something else with them using an AcctSQLStatement.
>
> Any advice?
>
> David



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.