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

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@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