I process CDRs on the same machine and then replicate the DB elsewhere.
Or you could have a daemon processing the CDRs on the main machine and doing whatever with them.
The benefit is that then you'll have file persistence of the CDRs until they actually get processed... 

-Avi


On Fri, Jul 6, 2012 at 11:10 AM, Neo Cheema <neo.cheema@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@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@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@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@freeswitch.org
>> > http://www.freeswitchsolutions.com
>> >
>> > FreeSWITCH-powered IP PBX: The CudaTel Communication Server
>> > http://www.cudatel.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@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@freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
>> http://www.cudatel.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@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@freeswitch.org
> http://www.freeswitchsolutions.com
>
> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
> http://www.cudatel.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@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@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.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@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org