[asterisk-users] CDR MYSQL missing field data

[Tilghman Lesher]

On Monday 28 March 2011 07:57:10 Eric W. Davenport wrote:
> Thanks Tilghman for your response.
> 
> I have the following in my cdr_mysql.conf
> 
> I put it in sometime yesterday and did not have it till then.
> 
> However, it did not make any difference.

Did you reload after making the change to the config file?

> [columns]
> static "<value>" => <column>
> alias <cdrvar> => <column>

These are bogus and should never have been uncommented.

> alias start => calldate
> alias callerid => clid

These are fine.

> alias src => src
> alias dst => dst
> alias dcontext => dcontext
> alias channel => channel
> alias dstchannel => dstchannel
> alias lastapp => lastapp
> alias lastdata => lastdata
> alias duration => duration
> alias billsec => billsec
> alias disposition => disposition
> alias amaflags => amaflags
> alias accountcode => accountcode
> alias userfield => userfield
> alias uniqueid => uniqueid

There is no reason to have any of these uncommented, unless the column
specified after the arrow is different from the field specified before.

-- 
Tilghman