----- Original Message ----- From: Shane Burrell To: freeswitch-users@lists.freeswitch.org Sent: Monday, July 10, 2006 6:15 PM Subject: Re: [Freeswitch-users] CDR status Large switches have a local CDR and CDR streams. We compare the two before billing and do any reconciliation at that point. ------------------------------------------------------------------------------ From: Anthony Minessale [mailto:anthmct@yahoo.com] Sent: Monday, July 10, 2006 12:11 PM To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] CDR status The CDR module has modules staticly written into them so you can implement the delivery any way you choose. My personal favorite is 1 file per record in a parsable format for a script to come and aggragate them into sql stmts once in a while. As far as multicast events there is almost enough information in the events to do the cdr completly in an event consumer I just need to add a little more code to insert the times on the hangup events but you could keep track of it externally even without them if you wanted to keep state privately based on the event data. There is an example of this in the core where an internal event consumer keeps the call count and states of every session into an intenal sqlite db so you can query channel data without disturbing the actuall live channels. Anthony Minessale http://www.cluecon.com Brett Nemeroff <brett@nemeroff.com> wrote: Hey, Comment on CDR and redundant servers. I've seen a lot of nightmareish scenarios with Asterisk and broken MySQL databases (or broken network connectivity). Ugly things like the SQL server becomes unavailable and then the SIP channel blocks... Why not just make the CDR module output to a pipe or socket and have a seperate program read the socket and do whatever.. that way the app is completely isolated from the Database BTW, can the multicast eventing do something like that already? How does the multicast eventing and cdr gel up? -Brett On Mon, July 10, 2006 9:58 am, Yossi Neiman wrote: > Hey folks, > > For all of you who were wondering when Freeswitch will be supporting the > logging of Call Detail Records, here is the current status: > > mod_cdr currently logs to three types of outputs: CSV format (CsvCDR), > Perl Data Dumper Format to individual files (AnthmCDR), and to MySQL > 4.1.x or greater using prepared statements (MysqlCDR). I have not yet > implemented any failover routines, but at the moment that would mostly > only pertain to the Mysql output anyway. I will not be able to > implement those routines until after the initial inclusion of mod_cdr > into the trunk. That inclusion I hope will be coming very soon as all > we really need to do is do some additional testing to make sure I've not > missed anything. I expect that we will be ready for testing very soon. > > Will keep the list posted when it is merged into the trunk. > > Yossi Neiman > Cartis Solutions, Inc. - http://www.cartissolutions.com > > _______________________________________________ > Freeswitch-users mailing list > Freeswitch-users@lists.freeswitch.org > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users > > _______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users ------------------------------------------------------------------------------ Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. ------------------------------------------------------------------------------ _______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users