Re: doubt in Radius and openser fro accounting...

[James Wakefield <jamesw@deakin.edu.au>]

raviprakash sunkara wrote:

> radacctID  |    AcctSessionID   |   AcctuniqueID  | UserName |  
> AcctStartTime  | ActStopTime | calledID  | callingID |
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
>
> 1                       12h34yy               2334juuw45      
> Uac1                13:10:00               00:00:00       
> Uac2             uac1
>
> 2                       12h34yy               ko34ji899          
> Uac2                13:11:11                13:11:11     
> Uac1             Uac2
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
>
>
> In accountting with openser + radius in should insert  only one insert 
> for every  call made .

FreeRADIUS with SQL accounting will insert a row for each session when 
accounting starts, then update that row when accounting stops.  I'd 
guess that the session with an AcctStopTime of all zeros that you posted 
hasn't actually stopped yet.  Look at the schema, I'm pretty sure all 
zeros is the default value for that column.

--
James Wakefield,
Unix Administrator, Information Technology Services Division
Deakin University, Geelong, Victoria 3217 Australia.

Phone: 03 5227 8690 International: +61 3 5227 8690
Fax:   03 5227 8866 International: +61 3 5227 8866
E-mail:   james.wakefield@deakin.edu.au
Website:  http://www.deakin.edu.au