[asterisk-users] update CDRs in mysql during a call

[mickael ropars]

Hi Scott and Danny,

thanks a lot for your quick answer.

Danny, Fork will generate too many CDRs if the call goes long. So it's not
appropriate to my billing application.

Scott, I want to write the same application and I begin to so (that's why I
wanted to know if there was the same appkication on asterisk before). my
application has the behaviour than yours exept taht the end of the call is
not set to the time crash, my application works as ticket (like prepaid
application). at the begining of the call I open a ticket (I create a CDR
with 5 second of communication for exemple). and every 5 seconds I update
the CDR for a new ticket)

then I don't need to know what time the server crash.

I hope that you understand the way I will do it. what do you think about ?

thanks

regards

Mickael


2009/10/19 Scott L. Lykens <slykens at verimedservices.com>

>  Apologies for the top post – Outlook really is braindead with HTML email.
>
>
>
> I’ve been thinking about this problem for a project I am working on and
> what I think I am going to do is create a table that I insert a record into
> just before the dial statement that includes where the call is going then
> remove that record when the call completes and the CDR posts. If asterisk
> crashes I know what time it crashed and then can rate the calls based on
> when the call started and when asterisk crashed…. And likely not charge for
> calls under a short duration (say 30-45s) assuming they either never got
> connected or were so short as to be useless.
>
>
>
> Such a method could be modified so that on restart a script is triggered
> which would automatically process the “in-progress” table into CDR so your
> standard suite of tools could use the data later on.
>
>
>
> Probably not perfect but that’s what I’ve thought of with it.
>
>
>
> sl
>
>
>
> *From:* asterisk-users-bounces at lists.digium.com [mailto:
> asterisk-users-bounces at lists.digium.com] *On Behalf Of *mickael ropars
> *Sent:* Monday, October 19, 2009 11:48 AM
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* [asterisk-users] update CDRs in mysql during a call
>
>
>
> All,
>
>
> According to my readings CDRs are stored at the end of the call. My
> concerns is when asterisk goes down (I know that it's never happen but it's
> just in case) or when the is a power shutdown of the server. then CDRs are
> not stored in mysql. is there a way to store periodially CDR during a call,
> and set the periodical timer regarding the context.
>
> if no is there a way to retreive CDR, after a reboot ?
>
> Regards
>
> Mickael
>
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> AstriCon 2009 - October 13 - 15 Phoenix, Arizona
> Register Now: http://www.astricon.net
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20091019/e2453353/attachment.htm