What about using a radius server, would that be more resilient? Regards
-----Original Message----- From: freeswitch-users-boun...@lists.freeswitch.org [mailto:freeswitch-users-boun...@lists.freeswitch.org] On Behalf Of Adam Long Sent: 06 February 2009 17:31 To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] Call accounting - CDR's Is mod_cdr_xml asynchronous ... by that I mean .. if there is a communication failure how does this effect load on the system or the call for that matter... it wouldn't hold up the progress or delay the turn up of the call or anything would it? I understand it would write to the error directory (but my thoughts are what is the impact of this beyond the obvious IO hit) I guess a good question is what is more load intensive??? 1.) mod_cdr_csv (with batch script that loads into DB somewhere) 2.) mod_cdr_xml (posting to lighttpd on remote host inserting into DB) I'm thinking about this for a system that would be handling in excess of 200-300 call setups per second. -Adam -----Original Message----- From: freeswitch-users-boun...@lists.freeswitch.org [mailto:freeswitch-users-boun...@lists.freeswitch.org] On Behalf Of Rupa Schomaker (lists) Sent: Friday, February 06, 2009 11:27 AM To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] Call accounting - CDR's Use the script in scripts/contrib/wasim/ as a starting point. Basically, you log to csv files, and then the script periodically picks them up and loads to your DB. This is using mysql as an example, but you can do the same with postgres as well. If you need realtime inserts, then use mod_cdr_xml and have those post to a script on a webserver that parses the xml and inserts into appropriate tables. This is what I use along with a rails app. Remember that if you do real time, you also need to periodically scrape the error directory and load those (mod_cdr_xml will save to error if it can't successfully post to your script). On 2/6/2009 10:09 AM, Nik Middleton wrote: > Hi Guys > > > > I'm looking for some pointers on how to collect CDR's and store in > mysql. Is there anything built in yet? > > > > I can rate the calls as a batch process, I simply need the call data. > > > > Regards > _______________________________________________ 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 _______________________________________________ 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 _______________________________________________ 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