[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-04-06 07:00 CDT
====================================================================== 
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
====================================================================== 

---------------------------------------------------------------------- 
 (0120154) riksta (reporter) - 2010-04-06 07:00
 https://issues.asterisk.org/view.php?id=17003#c120154 
---------------------------------------------------------------------- 
Sadly, I could not find anything glaringly obvious in the diffs, I tested a
patch which reverted a number of lines of code I suspected might be the
cause and it made no difference.. so I will have to leave it with you guys.
Thanks 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-04-06 07:00 riksta         Note Added: 0120154                          
======================================================================