[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:                     feedback
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-01-23 10:28 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.
====================================================================== 

---------------------------------------------------------------------- 
 (0098573) unservices (reporter) - 2009-01-23 10:28
 http://bugs.digium.com/view.php?id=14085#c98573 
---------------------------------------------------------------------- 
Murf, sorry for the delay on my end also (was traveling)...

Anyhow, I have a very simple php script that runs after the call is
completed to calculate the call cost and set into the userfield.

On the extensions.conf therefore is quite simple:

exten => h,1,DeadAGI(myscript.php)

On there I read the call values with phpagi (I've checked the values and
they are all present) and then at the end I have something like:

  $agi->exec("Set CDR(userfield)=1234")

Which in turn does not set the value at all. I've tried exactly as
described above adding a fake value 1234 and it does not get set at all.

It makes me wonder what's the difference from the script running between
answering and not answering the call. If the call is answered then it does
not update. If not answered, it updates. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-01-23 10:28 unservices     Note Added: 0098573                          
======================================================================