[asterisk-ss7] MySQL HiRes timer.

[Jorge Antillon]

Hi,

It crashed miserably, I feel this is only for 1.6 branch though..
thanks a lot.

regards,





Jorge Antillon
CEO - CTO
ticom - Costa Rica Telecom




On Fri, 2010-04-23 at 19:23 +0300, Kaloyan Kovachev wrote:

> 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 https://reviewboard.asterisk.org/r/461/ 
> > 
> > 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 http://www.api-digital.com 
> --
> 
> asterisk-ss7 mailing 
> list
> To UNSUBSCRIBE or update options 
> visit:
> http://lists.digium.com/mailman/listinfo/asterisk-ss7
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-ss7/attachments/20100426/88da7eb5/attachment-0001.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ticom-t.jpg
Type: image/jpeg
Size: 6120 bytes
Desc: not available
Url : http://lists.digium.com/pipermail/asterisk-ss7/attachments/20100426/88da7eb5/attachment-0001.jpg