[RADIATOR] Session database sql statement query

[Alex Sharaz]

I've got a quick question about Sessiondatabase sql configurations

I've defined a <SessionDatabase SQL> statement that gets called when
radiator receives a dot1x accounting stop record.

In the definition I have a DeleteQuery statement, an AddQuery statement and
a ClearNasQuery statement.

Basically I have a database table that keeps track of the currently
authenticated users through the use of accounting start,stop and alive
packets. When I receive a stop record I want to 
a). Delete the record in my online table
b). Insert the final set of accounting details as found in the accounting
stop record into another database table.


As far as i can see, the AddQuery statement seems to be ignored. The
DeleteQuery statement is being obeyed though.

Shouldn't the sequence be deletequery and then addquery? Elsewhere I use a
ReplaceQuery statement and i know that if its present radiator doesn't use
the Add.. and Del.. combination

Alex



-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 5438 bytes
Desc: not available
URL: <http://www.open.com.au/pipermail/radiator/attachments/20080821/468f35f3/attachment.bin>