[Serusers] Creating CDRs from SERs accouning records

[Eric Haskins]

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