[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 09:09 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

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

---------------------------------------------------------------------- 
 (0091513) snuffy (manager) - 2008-08-18 09:09
 http://bugs.digium.com/view.php?id=13333#c91513 
---------------------------------------------------------------------- 
MySQL doesn't have an 'adaptive' option which means you are limited to
standard fields and you can either store that info in part of 'userfield'
or you can use cdr_adaptive_odbc which will allow you to have as many
custom fields as you want. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2008-08-18 09:09 snuffy         Note Added: 0091513                          
======================================================================