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

[Carlos Chavez]

On Mon, 2007-11-05 at 09:40 -0800, James Moore wrote:
> 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.
> 
	Do you have "userfield=1" in your cdr_mysql.conf file?

-- 
Telecomunicaciones Abiertas de México S.A. de C.V.
Carlos Chávez Prats
Director de Tecnología
+52-55-91169161 ext 2001
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20071105/4db89b9c/attachment.pgp