[asterisk-bugs] [Asterisk 0017003]: [regression] Set(CDR(mycol)=xxx) does not get populated in the backend when the CDR is posted

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=17003 
====================================================================== 
Reported By:                riksta
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   17003
Category:                   CDR/General
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     acknowledged
Asterisk Version:           1.6.2.5 
JIRA:                       SWP-1064 
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-03-10 10:43 CST
Last Modified:              2010-03-11 10:00 CST
====================================================================== 
Summary:                    [regression] Set(CDR(mycol)=xxx) does not get
populated in the backend when the CDR is posted
Description: 
I have a simple dialplan

exten => _X.,1,Set(CDR(outbound)=1234)
exten => _X.,2,Dial(SIP/1000)

I have a mysql database table CDR which is identical to the example in the
addons documentation except I have a number of custom fields, one of which
is "outbound" a varchar(255)

The insert from the debug log shows that cdr_addon_mysql has no idea of
the existence of the custom set field "outbound" and doesnt try to insert
it.

Also if I edit the cdr_mysql.conf and add to the [columns] config:

static "123" => outbound       

I see the value 123 always populated into the DB correctly.

***MOST IMPORTANTLY*** I have this simple scenario completely working in
asterisk-addons-1.6.1.0-rc3 with asterisk-1.6.1.3-rc1

Thanks for your time
====================================================================== 

---------------------------------------------------------------------- 
 (0119258) riksta (reporter) - 2010-03-11 10:00
 https://issues.asterisk.org/view.php?id=17003#c119258 
---------------------------------------------------------------------- 
using the "h" extension after the bridge indeed allows the custom variable
to be set into the database "cdr" table.

This seems to align with tilghman's comment above about the original CDR
vars not being copied after the bridge occurs. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-03-11 10:00 riksta         Note Added: 0119258                          
======================================================================