[Serusers] Creating CDRs from SERs accouning records

Lenir lenirsantiago at yahoo.com
Thu Dec 1 17:26:41 CET 2005


Exactly, for those unsuccessful calls, the CANCEL will generate the stop
record, just like it would with a BYE. the sip_status is irrelevant, except
for informational purposes. You should account for any STOP record regadless
of the termination cause of the call.

-----Original Message-----
From: Klaus Darilion [mailto:klaus.mailinglists at pernau.at] 
Sent: Thursday, December 01, 2005 11:16 AM
To: Lenir
Cc: 'Eric Haskins'; 'Frank Fischer'; 'Dave'; serusers at lists.iptel.org
Subject: Re: [Serusers] Creating CDRs from SERs accouning records

What about accounting failed transactions? Then you will see INVITEs 
with sip_status=200 for successful calls and sip_status=408 or 
sip_status=487 (cancel) for non sucessful calls.

klaus

Lenir wrote:
> If there's not a BYE message (called party doesn't answer or timeout) then
> the calling party WILL send a CANCEL. The CANCEL can be used to generate
the
> STOP record
> 
> -----Original Message-----
> From: serusers-bounces at iptel.org [mailto:serusers-bounces at lists.iptel.org] On
> Behalf Of Eric Haskins
> Sent: Thursday, December 01, 2005 3:26 AM
> To: Frank Fischer; 'Dave'
> Cc: serusers at lists.iptel.org
> Subject: Re: [Serusers] Creating CDRs from SERs accouning records
> 
> If I am correct I believe CDRTool uses mediaproxy to prevent the phantom
BYE
> 
> record.
> Adrian can correct me if I read wrong.  Invites without BYE's are common
No 
> one answered
> the phone. We just Log and drop records that dont have matching
INVITE,ACK, 
> and BYE.
> The reason as I have seen for the missing BYE (discussed alot on here) is 
> the UA or the Gateway
> dont send a BYE for whatever reason.  We havent seen that many , infact
not 
> one yet knock on wood.
> We thought about just estimating and calling them one minute calls.
> 
> The problem we are having is we route some wholesale traffic thru us via 
> trusted IP and account for
> it (Easy Part) but we also get DID's from that Company so all traffic
comes 
> from same IP.  DID's work
> fine but it broke our parser.  LOL was charging them for our incoming
calls 
> OOPS!!! I guess for now
> I am going to move the wholesale Trusted IP stuff to its own box.
> 
> Eric
> eric at rackspeed.net
> 
> ----- Original Message ----- 
> From: "Frank Fischer" <frank.fischer at digitalnomads.ch>
> To: "'Dave'" <ddx66 at yahoo.com>
> Cc: <serusers at lists.iptel.org>
> Sent: Wednesday, November 30, 2005 5:14 PM
> Subject: RE: [Serusers] Creating CDRs from SERs accouning records
> 
> 
> 
>>Do i get this right - the matching is just done by searching a matching
>>INVITE for each BYE where matching means that the callid must be the same?
>>Anf of course by calculating the callduration, normalize certain fields 
>>and
>>"grap" phonenumbers out of the sip uri?
>>Is it really that "simple"? Since, on one hand side, i read about cases
>>where there is no BYE at the end of a call (i think it had to do with
>>mediaproxy), on the other hand side, when i look at "my" acc table, i can
>>find some records, where there are multiple BYEs with the same callid or
>>INVITEs without a BYEs.
>>
>>I understand, that missing BYEs primarly are a problem of the accounting,
>>not of the normalization, but, how ever, i'm quite sure that i won't be
>>possible to have a 100% accurate accounting so i thought that there might 
>>be
>>the need/possibility to do some "fixing" during normalization. I.e. i 
>>think
>>i understood that the commercial version of CDRTool does so for missing
>>BYEs?
>>
>>Am i completely wrong?
>>
>>Regards
>>Frank
>>
>>
>>>-----Original Message-----
>>>From: Dave [mailto:ddx66 at yahoo.com]
>>>Sent: Wednesday, November 30, 2005 10:57 PM
>>>To: Frank Fischer; serusers at lists.iptel.org
>>>Subject: Re: [Serusers] Creating CDRs from SERs accouning records
>>>
>>>The downloadabe CDRTool gives you nothing practical.
>>>You can not do anything useful with it. So I would not
>>>waste my time on that.
>>>
>>>
>>>
>>>--- 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
>>>>
>>>
>>>
>>>
>>>
>>>__________________________________
>>>Start your day with Yahoo! - Make it your home page!
>>>http://www.yahoo.com/r/hs
>>>
>>
>>
>>_______________________________________________
>>Serusers mailing list
>>serusers at lists.iptel.org
>>http://lists.iptel.org/mailman/listinfo/serusers
>>
>>
> 
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
> 
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
> 
> 






More information about the sr-users mailing list