[asterisk-users] Problem with CDR userfield not being set

James Moore banshee at banshee.com
Mon Nov 5 11:40:36 CST 2007


I'm trying to use the MySQL CDR records.

According to dialplan show, the line in the dialplan is:

11. Set(CDR(userfield)=${billing_code})       [pbx_ael]

It looks like the value is being set when I watch the console during the call:

-- Executing [s at restphone_event_loop:11] Set("SIP/icall-0075a2e0",
"CDR(userfield)=boatmenu") in new stack

But the record that's created in mysql has a blank userfield:

INSERT INTO `cdr` (`calldate`, `clid`, `src`, `dst`, `dcontext`,
`channel`, `dstchannel`, `lastapp`, `lastdata`, `duration`, `billsec`,
`disposition`, `amaflags`, `accountcode`, `uniqueid`, `userfield`)
VALUES \
('2007-11-05 17:25:17','(removed)','(removed)','s','restphone_event_loop','SIP/icall-0075a2e0','','Read','Result|/var/lib/asterisk/sounds/restphone_cepstral/016d4fda5256dc9a944d7102fac4',25,15,'ANSWERED',3,'1\
','','');

What am I missing?  I'm running 1.4.13.

 - James Moore



More information about the asterisk-users mailing list