<div dir="ltr">I process CDRs on the same machine and then replicate the DB elsewhere.<div>Or you could have a daemon processing the CDRs on the main machine and doing whatever with them.</div><div>The benefit is that then you'll have file persistence of the CDRs until they actually get processed... </div>
<div><br clear="all"><div dir="ltr"><span style="font-family:Verdana,Arial,Helvetica,sans-serif"><span style="font-size:small">-Avi</span></span></div>
<br><br><div class="gmail_quote">On Fri, Jul 6, 2012 at 11:10 AM, Neo Cheema <span dir="ltr"><<a href="mailto:neo.cheema@gmail.com" target="_blank">neo.cheema@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
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>
<div class="HOEnZb"><div class="h5"><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 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>> 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 time.<br>
>> ><br>
>> > anyone done something similar ?<br>
>> > The idea is to store as much data in a distributed manner, so as to aid<br>
>> > debugging.<br>
>> > ( not so much for billing )<br>
>> ><br>
>> > Jay<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><br>
</div></div></blockquote></div><br></div></div>