[Freeswitch-users] Pushing CDR Information into Zeromq

[Steven Ayre]

> What I really want is to provide near-real time updates of CDRs on a
> webpage, the webserver not necessarily being on the same machine as
> Freeswitch. I would hate to continuously scan DB on freeswitch machine
> for latest CDR info.

There's no need for this. mod_xml_cdr can submit CDRs to any URL accessible from the FS host, that means it can submit CDRs directly to a script on your webserver.

The only need to do any scanning on your FS server is to watch the err log dir so you can resubmit failed CDRs. That doesn't need to be a constant polling - it can be a cronjob, manual (after seeing and correcting the problem) or... a daemon that uses inotify to only wake up when a failed cdr has been written to disk. Of course as well as retries you want it to notify you in case it's a problem on the webserver that needs you to correct it.

Steve on iPhone

On 6 Jul 2012, at 09:10, Neo Cheema <neo.cheema at gmail.com> wrote:

> Avi,
> 
> What I really want is to provide near-real time updates of CDRs on a
> webpage, the webserver not necessarily being on the same machine as
> Freeswitch. I would hate to continuously scan DB on freeswitch machine
> for latest CDR info.
> 
> In a related issue, I read that the only reliable info on "call
> length", billsec etc should be read from CDRs.
> 
> I mean, I can't do a getvariable on session in say a Lua script, to
> read call length, billsec session variables. Infact I tried it and got
> null responses, even after session hangup. Is there a way to get
> "correct" values of these variables in the Lua script itself? It would
> make my life simpler, because I can then just push the cdr info +
> custom values into any queue or webserver, without waiting for the
> Freeswitch to do it for me.
> 
> Any Ideas?
> 
> 
> On Fri, Jul 6, 2012 at 1:18 PM, Avi Marcus <avi at avimarcus.net> wrote:
>> xml_cdr by default writes to disk, no web server required. You want to skip
>> the disk, I presume..?
>> 
>> -Avi
>> 
>> 
>> On Fri, Jul 6, 2012 at 10:14 AM, Neo Cheema <neo.cheema at gmail.com> wrote:
>>> 
>>> João,
>>> 
>>> "Since the socket implemented on mod_zmq is a simple PUB/SUB, yes,
>>> messages would be discarded if they are not received by the other
>>> end."
>>> 
>>> I thought it didn't matter if the 'worker' was up before the
>>> 'producer'/freeswitch started pushing in the messages. 0mq handles
>>> that part, if atleast one worker is connected.
>>> 
>>> My main reason for looking towards 0mq was to bypass a webserver,
>>> which would be required for xml_cdr.
>>> 
>>> On Fri, Jul 6, 2012 at 8:33 AM, jay binks <jaybinks at gmail.com> wrote:
>>>> while we are talking about funky CDR stuff.
>>>> 
>>>> Ive been planning to look at riak ( http://wiki.basho.com/ ) for bulk
>>>> CDR
>>>> storage
>>>> ( storing data other than billing data ) but just not finding the time.
>>>> 
>>>> anyone done something similar ?
>>>> The idea is to store as much data in a distributed manner, so as to aid
>>>> debugging.
>>>> ( not so much for billing )
>>>> 
>>>> Jay
>>>> 
>>>> 
>>>> 
>>>> _________________________________________________________________________
>>>> Professional FreeSWITCH Consulting Services:
>>>> consulting at freeswitch.org
>>>> http://www.freeswitchsolutions.com
>>>> 
>>>> 
>>>> 
>>>> 
>>>> Official FreeSWITCH Sites
>>>> http://www.freeswitch.org
>>>> http://wiki.freeswitch.org
>>>> http://www.cluecon.com
>>>> 
>>>> Join Us At ClueCon - Aug 7-9, 2012
>>>> 
>>>> FreeSWITCH-users mailing list
>>>> FreeSWITCH-users at lists.freeswitch.org
>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>> http://www.freeswitch.org
>>>> 
>>> 
>>> _________________________________________________________________________
>>> Professional FreeSWITCH Consulting Services:
>>> consulting at freeswitch.org
>>> http://www.freeswitchsolutions.com
>>> 
>>> 
>>> 
>>> 
>>> Official FreeSWITCH Sites
>>> http://www.freeswitch.org
>>> http://wiki.freeswitch.org
>>> http://www.cluecon.com
>>> 
>>> Join Us At ClueCon - Aug 7-9, 2012
>>> 
>>> FreeSWITCH-users mailing list
>>> FreeSWITCH-users at lists.freeswitch.org
>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>> http://www.freeswitch.org
>> 
>> 
>> 
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org
>> http://www.freeswitchsolutions.com
>> 
>> 
>> 
>> 
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://wiki.freeswitch.org
>> http://www.cluecon.com
>> 
>> Join Us At ClueCon - Aug 7-9, 2012
>> 
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>> 
> 
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
> 
> 
> 
> 
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
> 
> Join Us At ClueCon - Aug 7-9, 2012
> 
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org