<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=417055013-04082003><FONT face=Arial color=#0000ff size=2>Chee
Foong,</FONT></SPAN></DIV>
<DIV><SPAN class=417055013-04082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=417055013-04082003><FONT face=Arial color=#0000ff size=2>Here
is a cdr_mysql2.c I rewrote. </FONT></SPAN><SPAN
class=417055013-04082003><FONT face=Arial color=#0000ff size=2>It captures all
the billing information you will need.</FONT></SPAN></DIV>
<DIV><SPAN class=417055013-04082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=417055013-04082003><FONT face=Arial color=#0000ff size=2>You
will need to change the Makefile to compile it.</FONT></SPAN></DIV>
<DIV><SPAN class=417055013-04082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=417055013-04082003><FONT face=Arial color=#0000ff size=2>Also
attached is a script to create the database.</FONT></SPAN></DIV>
<DIV><SPAN class=417055013-04082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=417055013-04082003><FONT face=Arial color=#0000ff
size=2>Erik</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
asterisk-users-admin@lists.digium.com
[mailto:asterisk-users-admin@lists.digium.com]<B>On Behalf Of </B>Chee
Foong<BR><B>Sent:</B> Monday, August 04, 2003 2:24 AM<BR><B>To:</B>
asterisk-users@lists.digium.com<BR><B>Subject:</B> [Asterisk-Users] Mysql
CDR<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>hello all,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I am using the msql cdr module to store cdr in
db, I realised that it does't capture the start and end time af a
particular call record. </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Therefore I dive into the source code to add
the start and end time into the query (add something like cdr->start,
cdr->end), but end up getting segfault.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>the original version of cdr_mysql.so works fine
but I need the start time and end time of calling as well.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I wonder what would I get with
cdr->start? the start time field in my db is of type date
or should i use varchar?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>thanks</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial
size=2>Foong</FONT> </DIV></BLOCKQUOTE></BODY></HTML>