<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="country-region"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Large switches have a local CDR and CDR
streams. We compare the two before billing and do any reconciliation at that
point.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Anthony
Minessale [mailto:anthmct@yahoo.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, July 10, 2006 12:11
PM<br>
<b><span style='font-weight:bold'>To:</span></b>
freeswitch-users@lists.freeswitch.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [Freeswitch-users]
CDR status</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>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.<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>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.<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Anthony Minessale<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><a href="http://www.cluecon.com">http://www.cluecon.com</a><o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
<br>
<b><i><span style='font-weight:bold;font-style:italic'>Brett Nemeroff
<brett@nemeroff.com></span></i></b> wrote:<o:p></o:p></span></font></p>
</div>
<blockquote style='border:none;border-left:solid #1010FF 1.5pt;padding:0in 0in 0in 4.0pt;
margin-left:3.75pt;margin-top:5.0pt;margin-bottom:5.0pt'>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Hey,<br>
Comment on CDR and redundant servers. I've seen a lot of nightmareish<br>
scenarios with Asterisk and broken MySQL databases (or broken network<br>
connectivity). Ugly things like the SQL server becomes unavailable and<br>
then the SIP channel blocks...<br>
<br>
Why not just make the CDR module output to a pipe or socket and have a<br>
seperate program read the socket and do whatever.. that way the app is<br>
completely isolated from the Database<br>
<br>
BTW, can the multicast eventing do something like that already? How does<br>
the multicast eventing and cdr gel up?<br>
-Brett<br>
<br>
<br>
On Mon, July 10, 2006 9:58 am, Yossi Neiman wrote:<br>
> Hey folks,<br>
><br>
> For all of you who were wondering when Freeswitch will be supporting the<br>
> logging of Call Detail Records, here is the current status:<br>
><br>
> mod_cdr currently logs to three types of outputs: CSV format (CsvCDR),<br>
> Perl Data Dumper Format to individual files (AnthmCDR), and to MySQL<br>
> 4.1.x or greater using prepared statements (MysqlCDR). I have not yet<br>
> implemented any failover routines, but at the moment that would mostly<br>
> only pertain to the Mysql output anyway. I will not be able to<br>
> implement those routines until after the initial inclusion of mod_cdr<br>
> into the trunk. That inclusion I hope will be coming very soon as all<br>
> we really need to do is do some additional testing to make sure I've not<br>
> missed anything. I expect that we will be ready for testing very soon.<br>
><br>
> Will keep the list posted when it is merged into the trunk.<br>
><br>
> Yossi Neiman<br>
> Cartis Solutions, Inc. - http://www.cartissolutions.com<br>
><br>
> _______________________________________________<br>
> Freeswitch-users mailing list<br>
> Freeswitch-users@lists.freeswitch.org<br>
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<br>
><br>
><br>
<br>
<br>
<br>
_______________________________________________<br>
Freeswitch-users mailing list<br>
Freeswitch-users@lists.freeswitch.org<br>
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<o:p></o:p></span></font></p>
</blockquote>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=1 width="100%" align=center>
</span></font></div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Yahoo! Messenger with Voice. <a
href="http://us.rd.yahoo.com/mail_us/taglines/postman1/*http:/us.rd.yahoo.com/evt=39663/*http:/voice.yahoo.com">Make
PC-to-Phone Calls</a> to the <st1:country-region w:st="on"><st1:place w:st="on">US</st1:place></st1:country-region>
(and 30+ countries) for 2¢/min or less.<o:p></o:p></span></font></p>
</div>
</body>
</html>