(RADIATOR) qwest and stop packets

[Chris M]

I've started seeing this too, extremely intermittently (though not from 
Qwest).  I'd be interested in knowing how people "clean" RADIUS accounting 
logs to remove stuff like this to avoid coloring results.  Sure, we'd want 
to find and fix the problem if possible as to why those are getting in 
there, but it seems like preemptively trying to be defensive and detecting 
or cleaning those out of the ACCOUNTING table would be a good idea and a 
best practice.

As in, what do you do, some kind of DISTINCT statement in your  accounting 
queries to select a bunch of records and INSERT them into a new "scratch" 
table, then DELETE all the original records and move the records from the 
"scratch" table back into the regular table?  In other words, how would you 
go about doing this maintenance of cleaning the table to remove the 
spurious entries?

Chris

At 09:57 AM 5/20/2002 -0700, you wrote:
>Hello,
>
>I've got a radiator (2.19) running on a linux box with about 20 proxy
>realms.  When one of our proxy users disconnects, Qwests seems to send
>about 6 Stop packets all at once.  It's almost round-robin, except that
>radiator notes that all the packets arrive within a second or two.
>Radiator logs each of these packets in sequence and as a result our
>proxy users appear to have been online anywhere from 2 to 6 more than
>they really have.
>
>What I'm trying to figure out is, is radiator doing what it's supposed
>to do (ie. forwarding every stop packet it gets even if 6 in a row are
>for the same session id)?  Or more specifically, is the problem with
>qwest's borked nas's sending 6 stop packets at once?
>
>I can send trace4 log exerpts as well as sql logs if you want.
>
>Thanks for your help.
>
>-Peter
>
>--
>Peter Moody             Systems Administrator
>peter at enabledsites.com
>:wq
>
>===
>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.



===
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.