[Freeswitch-users] Call accounting - CDR's

Nik Middleton nik.middleton at noblesolutions.co.uk
Fri Feb 6 12:40:51 PST 2009


What about using a radius server, would that be more resilient?

Regards


-----Original Message-----
From: freeswitch-users-bounces at lists.freeswitch.org
[mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of Adam
Long
Sent: 06 February 2009 17:31
To: freeswitch-users at 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-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


_______________________________________________
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




More information about the FreeSWITCH-users mailing list