[asterisk-bugs] [Asterisk 0013290]: The field CDR(userfield) does not get written to the database

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=13290 
====================================================================== 
Reported By:                falves11
Assigned To:                seanbright
====================================================================== 
Project:                    Asterisk
Issue ID:                   13290
Category:                   CDR/cdr_tds
Reproducibility:            always
Severity:                   block
Priority:                   normal
Status:                     assigned
Asterisk Version:           SVN 
SVN Branch (only for SVN checkouts, not tarball releases):  trunk 
SVN Revision (number only!): 135068 
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             2008-08-11 18:53 CDT
Last Modified:              2008-08-11 20:08 CDT
====================================================================== 
Summary:                    The field CDR(userfield) does not get written to the
database
Description: 
INSERT INTO cdr (accountcode, src, dst, dcontext, clid, channel,
dstchannel, lastapp, lastdata, start, answer, [end], duration, billsec,
disposition, amaflags, uniqueid) VALUES ('72.187.243.97', '2127532626',
'19544447408', 'defaultproc', '2127532626', 'SIP/45936-007e4418',
'SIP/67.135.78.165-007fe3c8', 'Dial',
'SIP/9544447408 at 67.135.78.165,45,L(3600000)', '2008/08/11 19:57:31', null,
'2008/08/11 19:57:45', 14, 0, 'NO ANSWER', 'DOCUMENTATION',
'S225-1218499051.0')
====================================================================== 

---------------------------------------------------------------------- 
 (0091333) falves11 (reporter) - 2008-08-11 20:08
 http://bugs.digium.com/view.php?id=13290#c91333 
---------------------------------------------------------------------- 
Yes, it is there,thanks, but I cannot use the current Trunk for the reason
below. if you look at the invites that the current Trunk produces, it has a
malformed:
"From: "2127532626" <sip:2127532626 at 66.28.190.225:0>;tag=as500e9512", and
1/2 of my carriers reject the call. Please look at the section".225:0", the
":0" is wrong. I already filed a bug and it has not been assigned. I beg
you to fix that bug so I can upgrade my machines, or please port this fix
to 135068. The bug number is 13255. If that SIP bug is going to take a
month to fix, please port this fix to 1.4 so I can have something that
works. Also, cdr_tds needs a keep-alive mechanism. I came back after a few
hours of inactivity, placed a call and it did not get written by cdr_tds.
Maybe the connection had already been closed by SQL Server. CDR_TDS needs
not to make any assumtions about the state of the connection. The same is
applicable for cdr_odbc by the way. If the SIP bug is not going to be fixed
quickly, please send me a patch just to remove that ":0" so I can continue
doing business.


Retransmitting http://bugs.digium.com/view.php?id=3 (NAT) to 67.135.78.165:5060:
INVITE sip:9544447408 at 67.135.78.165 SIP/2.0
Via: SIP/2.0/UDP 66.28.190.225:5060;branch=z9hG4bK318a6848;rport
Max-Forwards: 70
From: "2127532626" <sip:2127532626 at 66.28.190.225:0>;tag=as500e9512
To: <sip:9544447408 at 67.135.78.165>
Contact: <sip:2127532626 at 66.28.190.225:0>
Call-ID: 2ceaef1d631f58a91760bf343166c52e at 66.28.190.225
CSeq: 102 INVITE
User-Agent: CiscoSystemsSIP-GW-UserAgent
Date: Tue, 12 Aug 2008 01:08:41 GMT
Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY
Supported: replaces, timer
Content-Type: application/sdp
Content-Length: 312

v=0
o=root 34665767 34665767 IN IP4 66.28.190.225
s=Cisco-SIPGateway/IOS-12.x
c=IN IP4 66.28.190.225
t=0 0
m=audio 7056 RTP/AVP 18 0 101
a=rtpmap:18 G729/8000
a=fmtp:18 annexb=no
a=rtpmap:0 PCMU/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-16
a=silenceSupp:off - - - -
a=ptime:20
a=sendrecv 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2008-08-11 20:08 falves11       Note Added: 0091333                          
======================================================================