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

[Asterisk Bug Tracker]

The following issue has been UPDATED. 
====================================================================== 
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:                     new
Asterisk Version:           1.6.2.5 
JIRA:                        
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-10 10:50 CST
====================================================================== 
Summary:                    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
====================================================================== 

---------------------------------------------------------------------- 
 (0119226) tilghman (administrator) - 2010-03-10 10:50
 https://issues.asterisk.org/view.php?id=17003#c119226 
---------------------------------------------------------------------- 
After debugging this on the -dev channel, it appears that the value is not
present on the CDR when posted to the backend, so what likely occurred is
that when the bridge CDR was created, it failed to properly inherit custom
variables on the original CDR. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-03-10 10:50 tilghman       Note Added: 0119226                          
2010-03-10 10:50 tilghman       Category                 Addons/cdr_addon_mysql
=> CDR/General
2010-03-10 10:50 tilghman       Summary                  cdr_addon_mysql does
not populate custom database fields using Set(CDR(mycol)=xxx) =>
Set(CDR(mycol)=xxx) does not get populated in the backend when the CDR is posted
2010-03-10 10:50 tilghman       Additional Information Updated                  
 
======================================================================