<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>RE: (RADIATOR) SessionDatabase replacing records on Alive packets</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>|I'm doing the same thing<BR>
<BR>
two options<BR>
1) define deletequery to be null in the config file<BR>
2). Use replace query and use your own update... sql statement<BR>
<BR>
I'm assuming here that you;'ve got a handler specifically for accounting alive packets<BR>
Alex<BR>
<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: owner-radiator@open.com.au on behalf of David Craigon<BR>
Sent: Fri 02/05/2008 10:50<BR>
To: radiator@open.com.au<BR>
Subject: (RADIATOR) SessionDatabase replacing records on Alive packets<BR>
<BR>
Hello,<BR>
<BR>
I'm running a standalone radius accounting server. What I want to<BR>
achieve is to have a row in a database in a table appear when I get a<BR>
start packet, and for it to be deleted again when I get a stop packet.<BR>
<BR>
To this end, I am using a sessiondb.<BR>
<BR>
The only problem I am having is that every time an Alive packet shows<BR>
up, the Delete query followed by the Insert query gets run. Since I<BR>
record when the session started using the SQL statement, I'd like it not<BR>
to do this.<BR>
<BR>
I don't want to ignore Alive packets altogether, since I do something<BR>
else with them using an AcctSQLStatement.<BR>
<BR>
Any advice?<BR>
<BR>
David<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>