<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.28.1">
</HEAD>
<BODY>
Hi,<BR>
<BR>
It crashed miserably, I feel this is only for 1.6 branch though..<BR>
thanks a lot.<BR>
<BR>
regards,<BR>
<BR>
<BR>
<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<BR>
<TABLE CELLSPACING="0" WIDTH="195">
<TR>
<TD>
<IMG SRC="cid:1272311318.5781.0.camel@Doughnut" WIDTH="44" HEIGHT="48" ALIGN="middle" BORDER="0">
</TD>
<TD>
Jorge Antillon<BR>
CEO - CTO<BR>
ticom - Costa Rica Telecom
</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
<BR>
</TD>
</TR>
</TABLE>
On Fri, 2010-04-23 at 19:23 +0300, Kaloyan Kovachev wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
I am not sure how different is the trunk version of cdr_mysql from 1.4.10, but
it may be enough to apply the relevant part of the whole patch:
Index: addons/cdr_mysql.c
===================================================================
--- addons/cdr_mysql.c (revision 253708)
+++ addons/cdr_mysql.c (working copy)
@@ -288,6 +288,39 @@
ast_str_append(&sql2, 0, ",");
}
+ if (!strcasecmp(cdrname, "billsec") &&
+ (strstr(entry->type, "float") ||
+ strstr(entry->type, "double") ||
+ strstr(entry->type, "decimal") ||
+ strstr(entry->type, "numeric") ||
+ strstr(entry->type, "real"))) {
+
+ if (!ast_tvzero(cdr->answer)) {
+ snprintf(workspace, sizeof(workspace), "%lf",
+ (double) (ast_tvdiff_us(cdr->end, cdr->answer) / 1000000.0));
+ } else {
+ ast_copy_string(workspace, "0",sizeof(workspace));
+ }
+
+ if (!ast_strlen_zero(workspace)) {
+ value = workspace;
+ }
+ }
+
+ if (!strcasecmp(cdrname, "duration") &&
+ (strstr(entry->type, "float") ||
+ strstr(entry->type, "double") ||
+ strstr(entry->type, "decimal") ||
+ strstr(entry->type, "numeric") ||
+ strstr(entry->type, "real"))) {
+ snprintf(workspace, sizeof(workspace), "%lf",
+ (double) (ast_tvdiff_us(cdr->end, cdr->start) / 1000000.0));
+
+ if (!ast_strlen_zero(workspace)) {
+ value = workspace;
+ }
+ }
+
On Fri, 23 Apr 2010 10:08:28 -0600, Jorge Antillon wrote
> Hi, thanks for your time, this is where I went to, and how I got to
subscribing to asterisk-addons forum, I made no sense as to how to integrate
that into my asterisk-addons-1.4.10.
>
> regards,
>
> - jorge.
>
> On Fri, 2010-04-23 at 17:43 +0300, Kaloyan Kovachev wrote:
> take a look at <A HREF="https://reviewboard.asterisk.org/r/461/">https://reviewboard.asterisk.org/r/461/</A>
>
> On Fri, 23 Apr 2010 08:32:43 -0600, Jorge Antillon wrote
> > Hi,
> >
> > First off, I know this is not cdr_mysql forum, BUT, the asterisk-addons
message board bounced my posting.
> > I've bumped onto a different pothole this time, what seems to be is a CDR
recording issue:
> >
> > I need to set CDR recording to tenths of a second or better, instead of
integer values,
> >
> > I have asterisk 1.4.29.1 and addons 1.4.10.
> > cdr.billsec and cdr.duration is already set as float, so no problem there.
> >
> > I figure you must have bumped into issues like this connecting SS7 trunks
to other operators.
> >
> > Or if you know where to look for, please let me know.
> >
> > Regards,
> >
> >
>
> >
>
> Jorge Antillon
> > CEO - CTO
> > ticom - Costa Rica Telecom
> >
> >
>
>--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by <A HREF="http://www.api-digital.com">http://www.api-digital.com</A>
--
asterisk-ss7 mailing
list
To UNSUBSCRIBE or update options
visit:
<A HREF="http://lists.digium.com/mailman/listinfo/asterisk-ss7">http://lists.digium.com/mailman/listinfo/asterisk-ss7</A>
</PRE>
</BLOCKQUOTE>
</BODY>
</HTML>