[Freeswitch-users] Call accounting - CDR's

[Adam Long]

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-bounces at lists.freeswitch.org [mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of Rupa Schomaker (lists)
Sent: Friday, February 06, 2009 11:27 AM
To: freeswitch-users at 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 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