[Serusers] Creating CDRs from SERs accouning records

[Dave]

You can do it "almost" automatically using RADIUS. 

Install FreeRadius and have SER write records START
and STOP records to RADIUS (corresponding to INVITE
and BYE) . 

What happens is that when a BYE is received, the
RADIUS looks for record corresponding to call-id (and
a couple of other checks) and it then UPDATES the
corresponding record with the Call-Termination-Time
field. So YOU GET A CDR but you do no have a SESSION
time. 

So what you need to do is that you edit the freeradius
"sql.conf" file and modify the "account_stop_query"
variable  to calculate the SESSION time and update the
AcctSessionTime column. 

This will allow you to have the CDR with
AcctStartTime, AcctStopTime and AcctSessionTime fields
in addition to the CalledStationId and
CallingStationId (calling phone#) fields and you have
a CDR. 




--- Frank Fischer <frank.fischer at digitalnomads.ch>
wrote:

> Hi all
>  
> i'm looking for a free/opensource application that
> generates CDRs (not XDRs,
> must not be rated) from the accounting data/events
> generated by SER (i think
> this is usually called normalization). I think this
> would have to be an
> application that is able to match INVITEs and BYEs
> and form CDRs with call
> start timestamp, call duration and so on. 
>  
> I had a look at the list of accounting software on
> the iptel.org website,
> but most of there applications are highly integrated
> accounting/billing
> solutions, far more than what i need (and also most
> of them seem to be
> commercial products). In the mailinglist archive i
> only found some
> references to CDRTool which seems also to be
> commercial. Obv. there must be
> a free version of CDRTool but neither i'm sure
> whether it implements exactly
> what i need so i could "grab it" for my own purposes
> nor could i find a
> place to download the free version).
>  
> Does anyone know if there is such a kind of
> application available?  Or any
> other idea how to deal with my requirements?
>  
> Thanks a lot for your help
> Frank
> > _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
> 



		
__________________________________ 
Yahoo! Music Unlimited 
Access over 1 million songs. Try it free. 
http://music.yahoo.com/unlimited/