[freeside-users] View RADIUS sessions

[ivan]

On Sun, Nov 06, 2005 at 06:12:30PM -0800, Dave wrote:
> Hello - I am running SER (Sip router) that is writing
> START/STOP accounting records to FREERADIUS. 
> 
> I have installed freeside to bill VOIP subs. I have
> added the "sqlradius" export and pointed to the RADIUS
> database. 
> 
> Now when I Click on "RADIUS Sessions" I am able to see
> the RADIUS accounting records but the DURATION is
> alway "0". Can someone please explain why? I assumed
> the the sqlradius will compute the DURATION based on
> START/STOP records. Is this not the case ?

Freeside's SQL RADIUS support does not attempt to calculate missing 
information.  Duration is reported by the RADIUS client as the 
Acct-Session-Time attribute and then recorded by the RADIUS server.  

This is defined as a distinct value from "stop minus start" in RADIUS 
because it does not include connection setup and teardown time.  If your 
RADIUS clients aren't reporting this information correctly, you may wish 
to hack your RADIUS server to calculate a missing Acct-Session-Time 
based on the time between start and stop records.

HTH.

-- 
_ivan