[asterisk-bugs] [Asterisk 0013333]: mysql cdr not loging custom fields

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=13333 
====================================================================== 
Reported By:                lazytt
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   13333
Category:                   CDR/General
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
Asterisk Version:           1.4.18 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             2008-08-18 09:02 CDT
Last Modified:              2008-08-18 10:56 CDT
====================================================================== 
Summary:                    mysql cdr not loging custom fields
Description: 
When trying to add custom fields to the mysql crd table, asterisk will not
log the values assigned to them. I added a field called "monitor" and tried
using the following dialplan:

exten => s,1000,Set(CDR(monitor)=${CALLFILENAME}.${MIXMON_FORMAT})

However, all asterisk adds is:
cdr_addon_mysql.c: cdr_mysql: SQL command as follows: INSERT INTO cdr
(calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield)
VALUES ('2008-08-18 17:01:59','\"lazytt\"
<220>','220','123456','from-internal',
'SIP/220-09024700','Zap/1-1','Dial','ZAP/g0/123456|300|T',10,5,'ANSWERED',3,'','1219068119.2','')

Using the same dialplan with variables such as userfeild works

====================================================================== 

---------------------------------------------------------------------- 
 (0091514) seanbright (manager) - 2008-08-18 10:56
 http://bugs.digium.com/view.php?id=13333#c91514 
---------------------------------------------------------------------- 
cdr_mysql in the 1.6.0 version of asterisk-addons (which is only compatible
with Asterisk 1.6.0) has an 'adaptive' mode now.  There is no backport
available that I am aware of. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2008-08-18 10:56 seanbright     Note Added: 0091514                          
======================================================================