[asterisk-users] hostname in MySQL CDR records

[Anthony Messina]

On Tuesday 27 November 2007 11:50:09 am Ricardo Carvalho wrote:
> You can also use CDR(userfield) parameter and that way you can write in the
> column userfield of your CDR table of the DB, the hostname of the asterisk
> for each call. You can try something like the following in the dialplan of
> each machine:
>
> Set(CDR(userfield)=hostname_of_the_machine)
>
> Regards,
> Ricardo Carvalho.

that's what i do currently, but i was wondering if it was possible to have 
custom cdr fields in cdr_addon_mysql as it is when using csv files.

with a "core show function CDR", it states:

  All of the above variables are read-only, except for accountcode,
  userfield, and amaflags. You may, however,  supply
  a name not on the above list, and create your own
  variable, whose value can be changed with this function,
  and this variable will be stored on the cdr.

but it seems like these "create my own variables" do not appear in mysql, 
though they do appear in the csv files.

-- 
Anthony -  http://messinet.com - http://messinet.com/~amessina/gallery
8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E
-------------- 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/20071127/83b47327/attachment.pgp