<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.4417.0">
<TITLE>cdr_odbc logging insane integer values</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>I'm having a problem with * (tried both HEAD and STABLE). When logging with cdr_odbc through unixODBC to MySQL, I get "insane" integer values in the duration, billsec, disposition and amaflags fields. I have enabled MySQL logging, and that's the query I get:</FONT></P>
<P><FONT SIZE=2>INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield) VALUES ('2005-02-23 11:47:04','1234','1234','161','auth-out','SIP/xxx','','Hangup','',8589934594,17179869186,12884901892,3630868242827837443,'xxx','1109155624.0','161')</FONT></P>
<BR>
<P><FONT SIZE=2>I've tried MySQL 4.1.7 or 4.1.10, with unixODBC 2.2.9 or 2.2.10, with MyODBC 3.51.11 or 2.50.39. All of these give the same error.</FONT></P>
<P><FONT SIZE=2>Logging to csv file works correctly. I have also tried inserting a debug line in cdr_odbc.c, to print out the values of cdr->duration etc, and they are all correct. The problem seems to happen somewhere between * and MySQL.</FONT></P>
<P><FONT SIZE=2>The only thing I have on this system which is different than all my other systems is the platform: x86_64 (AMD Opteron) instead of 32bit i686.</FONT></P>
<P><FONT SIZE=2>Anyone?</FONT>
</P>
<P><FONT SIZE=2>Thank you</FONT>
<BR><FONT SIZE=2>-Manuel</FONT>
</P>
</BODY>
</HTML>