[RADIATOR] Interim Accounting with Alive packets - SQL Query

[Jose Borges Ferreira]

I usually do something like this :

select max(bytesin)-min(bytesin) as bytesin ,max(bytesout)-min(bytesout) as
bytesout, username, sessionid from accounting group by username, sessionid
where record_date = '20090430';


<j/>

Clarence Darrow<http://www.brainyquote.com/quotes/authors/c/clarence_darrow.html>
- "When I was a boy I was told that anybody could become President;
I'm
beginning to believe it."

On Mon, May 4, 2009 at 2:44 AM, Paul Lattimer <paul.lattimer at fred.com.au>wrote:

>  Hi All,
>
>
>
> Currently running radiator and logging accounting to radius.ACCOUNTING via
> a mySQL database. We have had interim accounting turned on, on our LNS. Each
> hour we receive an Alive packet with interim data usage.
>
>
>
> Has anyone got or can anyone suggest a query that will extract user traffic
> between dates? I’m planning on running a query each night that will write
> traffic for the previous day into a radius.radacct database.
>
>
>
> I could probably work out the logic for the query, but as I am not a mySQL
> wiz, I’m struggling to re-invent this particular wheel.
>
>
>
> We terminate DSL customers, so their sessions can last from a few seconds
> to a few months. So I’d be looking at using a combination of alive and stop
> packets for summing traffic.
>
>
>
> Can someone point me in the right direction please?
>
>
>
> Thanks a lot.
>
>
>
> Paul
>
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20090505/5844273f/attachment.html>