[Asterisk-Users] cdr_odbc logging insane integer values

[Manuel Wenger]

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:

INSERT INTO cdr
(calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,dura
tion,billsec,disposition,amaflags,accountcode,uniqueid,userfield) VALUES
('2005-02-23
11:47:04','1234','1234','161','auth-out','SIP/xxx','','Hangup','',858993
4594,17179869186,12884901892,3630868242827837443,'xxx','1109155624.0','1
61')


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.

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.

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.

Anyone?

Thank you
-Manuel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20050223/78fed134/attachment.htm