asterisk users - Nov 2007 - Problem with CDR userfield not being set

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

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

On 11/5/07, Carlos Chavez <cursor at telecomabmex.com>
wrote:
>         Do you have "userfield=1" in your cdr_mysql.conf file?
Thanks - that took care of it.

 - James