If you check the links I sent earlier this is what we do. 

-- 
Gavin Henry
Sent with Sparrow

On Saturday, 7 July 2012 at 13:26, Neo Cheema wrote:

I looked around, and mod_event_zmq does infact send "all" the events.
So I just need to filter the incoming messages like, hangup_complete
etc to generate CDR-like info at the other end. Ofcourse, the listener
should be up all the time at the other end. So enabling mod_cdr_csv
can handle disk persistence in case worker goes down.

But I also liked the idea of generating 'billsec' like variables
inside the script independently. Thanks for the inputs.

On Sat, Jul 7, 2012 at 4:26 PM, Michael Giagnocavo <mgg@giagnocavo.net> wrote:
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.

-Michael



From: freeswitch-users-bounces@lists.freeswitch.org
[mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Avi
Marcus
Sent: Friday, July 06, 2012 4:02 AM


To: FreeSWITCH Users Help
Subject: Re: [Freeswitch-users] Pushing CDR Information into Zeromq



I'm pretty sure there's a variable to have the CDR in the ESL events, but I
can't find it.



-Avi



On Fri, Jul 6, 2012 at 12:42 PM, Neo Cheema <neo.cheema@gmail.com> wrote:

Avi,
Yea. That would work as well. I just thought it would be a
'nice-to-have' feature. Guess I'll go ahead with your model.

Regards


On Fri, Jul 6, 2012 at 2:07 PM, Avi Marcus <avi@avimarcus.net> wrote:
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



_________________________________________________________________________
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