[asterisk-bugs] [Asterisk 0014085]: Userfield not updating when the call is answered, if not answered it updates properly

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=14085 
====================================================================== 
Reported By:                unservices
Assigned To:                murf
====================================================================== 
Project:                    Asterisk
Issue ID:                   14085
Category:                   Applications/app_cdr
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     ready for testing
Asterisk Version:           1.4.22 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2008-12-15 19:58 CST
Last Modified:              2009-02-25 17:54 CST
====================================================================== 
Summary:                    Userfield not updating when the call is answered, if
not answered it updates properly
Description: 
Have a call coming through a SIP trunk. Extensions.conf is on realtime
mode, which goes to mysql extensions table and rings the SIP extension. At
the same context of extensions.conf I also have the 'h' extension, so that
a small script could run at the end to calculate the call cost after it's
completed, storing in the userfield. The script is running on the 'h'
extension with deadagi, so that it would allow to run after the call is
hangup.

Since it was not working, I made it quite simple just storing the numbers
1234 in the userfield once the script runs, nothing else. If the call comes
and the extension does not answer (no answer cdr result), the userfield
gets updated. But if the extension answers the call, upon hangup the
userfield simply does not get updated. Interesting to see is that with
debug in the console I see the agi script setting up the userfield for 1234
as expected, but it never gets saved into the database. It seems that the
script runs, but it's loosing the reference on where to update.

More interesting is that the same script / config runs with no problems
with the asterisk version 1.2 - which I'm trying to update to 1.4.22 so
that would have patches, better call quality, etc.

Obviously I have clonned the hard disk and am testing on a side server, so
that the main one is not affected... But really want to solve this asap
because the old box is giving me problems.
====================================================================== 

---------------------------------------------------------------------- 
 (0100767) sverre (reporter) - 2009-02-25 17:54
 http://bugs.digium.com/view.php?id=14085#c100767 
---------------------------------------------------------------------- 
Sorry agx, but this results in 2 CDR records, the first one with all of the
correct timing information, the second one with the userfield set but 0's
for duration and billsec.

As much as I'm not testing on svn, i'm using 1.4.22, the problem exists in
both CSV and MySQL. Doing a exten => s,1,Set(CDR(userfield)=1234)
immediately before the dial command works fine, meanwhile a exten =>
h,1,Set(CDR(userfield)=1234) does not work. The CLI correctly reports the
setting of the field, it just never makes it into the actual CDR.

I also tried endbeforehexten=yes and endbeforehexten=no in cdr.conf but it
didn't help. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-02-25 17:54 sverre         Note Added: 0100767                          
======================================================================