[asterisk-bugs] [Asterisk 0014662]: [patch] SetVar from Cli or AMI not showing value on CDR Record

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=14662 
====================================================================== 
Reported By:                sum
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   14662
Category:                   Addons/cdr_addon_mysql
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.6.0.6 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2009-03-13 09:52 CDT
Last Modified:              2009-05-06 16:45 CDT
====================================================================== 
Summary:                    [patch] SetVar from Cli or AMI not showing value on
CDR Record
Description: 
Setting a value of CDR like:

CDR(userfield) or a custom variable CDR(test) are not shown on cdr record
(MySQL Backend), when you check channel variables these looks ok, but at
the moment of hangup and check CDR record there is nothing there.

If I set te variable from the Dialplan works fine.
====================================================================== 

---------------------------------------------------------------------- 
 (0104326) sum (reporter) - 2009-05-06 16:45
 http://bugs.digium.com/view.php?id=14662#c104326 
---------------------------------------------------------------------- 
a) it's the default
;
; Mappings for custom config file
;
[master] ; currently, only file "master.db" is supported, with only one
table at a time.
table   => cdr
columns => calldate, clid, dcontext, channel, dstchannel, lastapp,
lastdata, duration, billsec, disposition, amaflags, accountcode, uniqueid,
userfield, test
values  =>
'${CDR(start)}','${CDR(clid)}','${CDR(dcontext)}','${CDR(channel)}','${CDR(dstchannel)}','${CDR(lastapp)}','${CDR(lastdata)}','${CDR(duration)}','${CDR(billsec)}','${CDR(disposition)}','${CDR(amaflags)}','${CDR(accountcode)}','${CDR(uniqueid)}','${CDR(userfield)}','${CDR(test)}'


b) 
Field		type	null	keyy	default		extra
'calldate', 'datetime', 'NO', 'MUL', '0000-00-00 00:00:00', ''
'clid', 'varchar(80)', 'YES', '', '', ''
'src', 'varchar(80)', 'YES', '', '', ''
'dst', 'varchar(80)', 'YES', 'MUL', '', ''
'dcontext', 'varchar(80)', 'YES', '', '', ''
'channel', 'varchar(80)', 'YES', '', '', ''
'dstchannel', 'varchar(80)', 'YES', '', '', ''
'lastapp', 'varchar(80)', 'YES', '', '', ''
'lastdata', 'varchar(80)', 'YES', '', '', ''
'duration', 'int(11)', 'YES', '', '0', ''
'billsec', 'int(11)', 'YES', '', '0', ''
'disposition', 'varchar(45)', 'YES', '', '', ''
'amaflags', 'int(11)', 'YES', '', '0', ''
'accountcode', 'varchar(20)', 'YES', 'MUL', '', ''
'userfield', 'varchar(255)', 'YES', '', '', ''
'uniqueid', 'varchar(32)', 'YES', '', '', ''
'type', 'varchar(3)', 'YES', '', '', ''
'guid', 'varchar(45)', 'YES', '', '', ''
'causecode', 'varchar(45)', 'YES', '', '16', ''
'campaign', 'varchar(45)', 'YES', '', '', '' 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-05-06 16:45 sum            Note Added: 0104326                          
======================================================================