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@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@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/