<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Regarding “safe” variables like billsec: The issue is that most of those things are not calculated and set until later on in the lifecycle of a request, well
after your Lua script has run. You can access them in C by adding a state handler, but I don’t believe that’s easily exposed to “API” apps/scripts. Anthony humoured me a quite a bit trying to get that kind of stuff working, but (at least a while ago), it was
just not feasible. I would suggest that your Lua script add in its own data variables that it would use in billing calculations, then let the full CDR get written, then pick up processing again, restore the vars from the CDR, and continue calculations. I know,
it’s not the most elegant seeming approach, but it’s the only reliable way AFAIK.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">-Michael<o:p></o:p></span></p>
<p class="MsoNormal"><a name="_MailEndCompose"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></a></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org]
<b>On Behalf Of </b>Avi Marcus<br>
<b>Sent:</b> Friday, July 06, 2012 4:02 AM<br>
<b>To:</b> FreeSWITCH Users Help<br>
<b>Subject:</b> Re: [Freeswitch-users] Pushing CDR Information into Zeromq<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">I'm pretty sure there's a variable to have the CDR in the ESL events, but I can't find it.<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">-Avi</span><o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
<br>
<o:p></o:p></p>
<div>
<p class="MsoNormal">On Fri, Jul 6, 2012 at 12:42 PM, Neo Cheema <<a href="mailto:neo.cheema@gmail.com" target="_blank">neo.cheema@gmail.com</a>> wrote:<o:p></o:p></p>
<p class="MsoNormal">Avi,<br>
Yea. That would work as well. I just thought it would be a<br>
'nice-to-have' feature. Guess I'll go ahead with your model.<br>
<br>
Regards<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal"><br>
On Fri, Jul 6, 2012 at 2:07 PM, Avi Marcus <<a href="mailto:avi@avimarcus.net">avi@avimarcus.net</a>> wrote:<br>
> I process CDRs on the same machine and then replicate the DB elsewhere.<br>
> Or you could have a daemon processing the CDRs on the main machine and doing<br>
> whatever with them.<br>
> The benefit is that then you'll have file persistence of the CDRs until they<br>
> actually get processed...<br>
><br>
> -Avi<br>
><br>
><br>
> On Fri, Jul 6, 2012 at 11:10 AM, Neo Cheema <<a href="mailto:neo.cheema@gmail.com">neo.cheema@gmail.com</a>> wrote:<br>
>><br>
>> Avi,<br>
>><br>
>> What I really want is to provide near-real time updates of CDRs on a<br>
>> webpage, the webserver not necessarily being on the same machine as<br>
>> Freeswitch. I would hate to continuously scan DB on freeswitch machine<br>
>> for latest CDR info.<br>
>><br>
>> In a related issue, I read that the only reliable info on "call<br>
>> length", billsec etc should be read from CDRs.<br>
>><br>
>> I mean, I can't do a getvariable on session in say a Lua script, to<br>
>> read call length, billsec session variables. Infact I tried it and got<br>
>> null responses, even after session hangup. Is there a way to get<br>
>> "correct" values of these variables in the Lua script itself? It would<br>
>> make my life simpler, because I can then just push the cdr info +<br>
>> custom values into any queue or webserver, without waiting for the<br>
>> Freeswitch to do it for me.<br>
>><br>
>> Any Ideas?<br>
>><br>
>><br>
>> On Fri, Jul 6, 2012 at 1:18 PM, Avi Marcus <<a href="mailto:avi@avimarcus.net">avi@avimarcus.net</a>> wrote:<br>
>> > xml_cdr by default writes to disk, no web server required. You want to<br>
>> > skip<br>
>> > the disk, I presume..?<br>
>> ><br>
>> > -Avi<br>
>> ><br>
>> ><br>
>> > On Fri, Jul 6, 2012 at 10:14 AM, Neo Cheema <<a href="mailto:neo.cheema@gmail.com">neo.cheema@gmail.com</a>><br>
>> > wrote:<br>
>> >><br>
>> >> Joćo,<br>
>> >><br>
>> >> "Since the socket implemented on mod_zmq is a simple PUB/SUB, yes,<br>
>> >> messages would be discarded if they are not received by the other<br>
>> >> end."<br>
>> >><br>
>> >> I thought it didn't matter if the 'worker' was up before the<br>
>> >> 'producer'/freeswitch started pushing in the messages. 0mq handles<br>
>> >> that part, if atleast one worker is connected.<br>
>> >><br>
>> >> My main reason for looking towards 0mq was to bypass a webserver,<br>
>> >> which would be required for xml_cdr.<br>
>> >><br>
>> >> On Fri, Jul 6, 2012 at 8:33 AM, jay binks <<a href="mailto:jaybinks@gmail.com">jaybinks@gmail.com</a>> wrote:<br>
>> >> > while we are talking about funky CDR stuff.<br>
>> >> ><br>
>> >> > Ive been planning to look at riak ( <a href="http://wiki.basho.com/" target="_blank">
http://wiki.basho.com/</a> ) for bulk<br>
>> >> > CDR<br>
>> >> > storage<br>
>> >> > ( storing data other than billing data ) but just not finding the<br>
>> >> > time.<br>
>> >> ><br>
>> >> > anyone done something similar ?<br>
>> >> > The idea is to store as much data in a distributed manner, so as to<br>
>> >> > aid<br>
>> >> > debugging.<br>
>> >> > ( not so much for billing )<br>
>> >> ><br>
>> >> > Jay<br>
>> >> ><br>
>> >> ><br>
>> >> ><br>
>> >> ><br>
>> >> > _________________________________________________________________________<br>
>> >> > Professional FreeSWITCH Consulting Services:<br>
>> >> > <a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
>> >> > <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
>> >> ><br>
>> >> > FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
>> >> > <a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
>> >> ><br>
>> >> > Official FreeSWITCH Sites<br>
>> >> > <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>> >> > <a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
>> >> > <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
>> >> ><br>
>> >> > Join Us At ClueCon - Aug 7-9, 2012<br>
>> >> ><br>
>> >> > FreeSWITCH-users mailing list<br>
>> >> > <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> >> > <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> >> ><br>
>> >> > UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> >> > <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>> >> ><br>
>> >><br>
>> >><br>
>> >> _________________________________________________________________________<br>
>> >> Professional FreeSWITCH Consulting Services:<br>
>> >> <a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
>> >> <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
>> >><br>
>> >> FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
>> >> <a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
>> >><br>
>> >> Official FreeSWITCH Sites<br>
>> >> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>> >> <a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
>> >> <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
>> >><br>
>> >> Join Us At ClueCon - Aug 7-9, 2012<br>
>> >><br>
>> >> FreeSWITCH-users mailing list<br>
>> >> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> >> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> >><br>
>> >> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> >> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>> ><br>
>> ><br>
>> ><br>
>> ><br>
>> > _________________________________________________________________________<br>
>> > Professional FreeSWITCH Consulting Services:<br>
>> > <a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
>> > <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
>> ><br>
>> > FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
>> > <a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
>> ><br>
>> > Official FreeSWITCH Sites<br>
>> > <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>> > <a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
>> > <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
>> ><br>
>> > Join Us At ClueCon - Aug 7-9, 2012<br>
>> ><br>
>> > FreeSWITCH-users mailing list<br>
>> > <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> > <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> > UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> > <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>> ><br>
>><br>
>> _________________________________________________________________________<br>
>> Professional FreeSWITCH Consulting Services:<br>
>> <a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
>> <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
>><br>
>> FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
>> <a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
>><br>
>> Official FreeSWITCH Sites<br>
>> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>> <a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
>> <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
>><br>
>> Join Us At ClueCon - Aug 7-9, 2012<br>
>><br>
>> FreeSWITCH-users mailing list<br>
>> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
><br>
><br>
><br>
> _________________________________________________________________________<br>
> Professional FreeSWITCH Consulting Services:<br>
> <a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
> <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
><br>
> FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
> <a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
><br>
> Official FreeSWITCH Sites<br>
> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
> <a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
> <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
><br>
> Join Us At ClueCon - Aug 7-9, 2012<br>
><br>
> FreeSWITCH-users mailing list<br>
> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
><br>
<br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
Join Us At ClueCon - Aug 7-9, 2012<br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><o:p></o:p></p>
</div>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</body>
</html>