[RADIATOR] Interim Accounting with Alive packets - SQL Query

[Paul Lattimer]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20090504/8e6b632c/attachment.html>