[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-05 10:07 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.
====================================================================== 

---------------------------------------------------------------------- 
 (0104208) sum (reporter) - 2009-05-05 10:07
 http://bugs.digium.com/view.php?id=14662#c104208 
---------------------------------------------------------------------- 
Asterisk*CLI> dialplan set chanvar SIP/1001-09789420 CDR(type) prueba
Asterisk*CLI> 
    -- Channel variable 'CDR(type)' set to 'prueba' for
'SIP/1001-09789420'
Asterisk*CLI> 
[May  5 09:24:04] DEBUG[18677]: rtp.c:1181 ast_rtcp_read: Got RTCP report
of 176 bytes
[May  5 09:24:06] DEBUG[18677]: rtp.c:1181 ast_rtcp_read: Got RTCP report
of 160 bytes
[May  5 09:24:06] DEBUG[18678]: audiohook.c:257 audiohook_read_frame_both:
Failed to get 160 samples from write factory 0x9790330
[May  5 09:24:06] DEBUG[18677]: channel.c:4524 ast_generic_bridge: Didn't
get a frame from channel: SIP/1001-09789420
[May  5 09:24:06] DEBUG[18677]: channel.c:4948 ast_channel_bridge: Bridge
stops bridging channels IAX2/1003-3830 and SIP/1001-09789420
[May  5 09:24:06] DEBUG[18677]: cdr_sqlite3_custom.c:261 sqlite3_log:
About to log: INSERT INTO cdr
(calldate,clid,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield,test)
VALUES ('2009-05-05
09:23:33','1003','outgoing','IAX2/1003-3830','Agent1','Queue','Pedidos','33','23','ANSWERED','DOCUMENTATION','Agente3','1241526213.0','','')
[May  5 09:24:06] DEBUG[18677]: cdr_addon_mysql.c:299 mysql_log: Inserting
a CDR record.
[May  5 09:24:06] DEBUG[18677]: cdr_addon_mysql.c:302 mysql_log: SQL
command as follows: INSERT INTO cdr
(calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid)
VALUES ('2009-05-05
09:23:33','1003','1003','121','outgoing','IAX2/1003-3830','Agent1','Queue','Pedidos','33','23','ANSWERED','3','Agente3','1241526213.0')
[May  5 09:24:06] DEBUG[18677]: res_config_mysql.c:1596 mysql_reconnect:
MySQL RealTime: Connection okay.
[May  5 09:24:06] DEBUG[18677]: res_config_mysql.c:830 store_mysql: MySQL
RealTime: Insert SQL: INSERT INTO queue_log (time, callid, queuename,
agent, event, data) VALUES ('1241526246', '1241526213.0', 'Pedidos',
'Agent1', 'COMPLETEAGENT', '10|23|1')
[May  5 09:24:06] DEBUG[18677]: res_config_mysql.c:843 store_mysql: MySQL
RealTime: row inserted on table: queue_log, id: 1312
[May  5 09:24:06] DEBUG[18677]: channel.c:1671 ast_hangup: Hanging up
channel 'SIP/1001-09789420'
[May  5 09:24:06] DEBUG[18677]: chan_sip.c:5601 sip_hangup: Hangup call
SIP/1001-09789420, SIP callid
6086cecc469004ee213732a7121965ff at 192.168.175.134
[May  5 09:24:06] DEBUG[18657]: app_queue.c:1057 handle_statechange:
Device 'SIP/1001' changed to state '1' (Not in use)
[May  5 09:24:06] DEBUG[18657]: app_queue.c:1057 handle_statechange:
Device 'SIP/1001' changed to state '1' (Not in use)
[May  5 09:24:06] DEBUG[18677]: res_config_mysql.c:1596 mysql_reconnect:
MySQL RealTime: Connection okay. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-05-05 10:07 sum            Note Added: 0104208                          
======================================================================