asterisk users - Mar 2011 - Fwd: Asterisk 1.6.2.10 & CDR custom added field

Hello,

is there anyone who can point me to correct information ?

Following http://pbxinaflash.com/forum/showthread.php?t=9042 and 
http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql > Extending CDR 
does not result in a working environment for me.

Any feedback appreciated.



Kind regards,
Jonas.



-------- Original Message --------
Subject: 	[asterisk-users] Asterisk 1.6.2.10 & CDR custom added field
Date: 	Tue, 22 Mar 2011 14:05:23 +0100
From: 	Jonas Kellens <jonas.kellens at telenet.be>
Reply-To: 	Asterisk Users Mailing List - Non-Commercial Discussion 
<asterisk-users at lists.digium.com>
To: 	Asterisk Users Mailing List - Non-Commercial Discussion 
<asterisk-users at lists.digium.com>



Hello list,

I have added an extra field "mycolumn" to the cdr table in my
MySQL-DB.

I simply try to add a value to this column by doing the following in the 
dialplan :

exten => 600,n,Set(CDR(mycolumn)="myvalue")


But this value is not written to the column 'mycolumn' together with the
other CDR-data.

Why is this ?! Do I need further configuration ? (Not according to 
http://pbxinaflash.com/forum/showthread.php?t=9042)


Kind regards,
Jonas.

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20110324/256bae28/attachment.htm>

You have to use adaptive cdr for this functionality. In 1.8 the conf file
for adaptive cdr is cdr_adaptive_odbc.conf. The sample conf file should tell
you everything.

If you are using some other cdr engine then you will have to jump into the
code of asterisk to make it log the item you want, which includes creating
an extra variable in the cdr data struction, creating a function to set/get
its value from dialplan, and then changing the sql command to include the
extra variable for insertion into DB.

On Thu, Mar 24, 2011 at 1:55 PM, Jonas Kellens <jonas.kellens at
telenet.be>wrote:
>  Hello,
>
> is there anyone who can point me to correct information ?
>
> Following http://pbxinaflash.com/forum/showthread.php?t=9042 and
> http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql > Extending CDR
does
> not result in a working environment for me.
>
> Any feedback appreciated.
>
>
>
> Kind regards,
> Jonas.
>
>
>
> -------- Original Message --------  Subject: [asterisk-users] Asterisk
> 1.6.2.10 & CDR custom added field  Date: Tue, 22 Mar 2011 14:05:23
+0100  From:
> Jonas Kellens <jonas.kellens at telenet.be> <jonas.kellens at
telenet.be>  Reply-To:
> Asterisk Users Mailing List - Non-Commercial Discussion
> <asterisk-users at lists.digium.com> <asterisk-users at
lists.digium.com>  To: Asterisk
> Users Mailing List - Non-Commercial Discussion
> <asterisk-users at lists.digium.com> <asterisk-users at
lists.digium.com>
>
>
> Hello list,
>
> I have added an extra field "mycolumn" to the cdr table in my
MySQL-DB.
>
> I simply try to add a value to this column by doing the following in the
> dialplan :
>
> exten => 600,n,Set(CDR(mycolumn)="myvalue")
>
>
> But this value is not written to the column 'mycolumn' together
with the
> other CDR-data.
>
> Why is this ?! Do I need further configuration ? (Not according to
> http://pbxinaflash.com/forum/showthread.php?t=9042)
>
>
> Kind regards,
> Jonas.
>
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>               http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>


-- 
Best Ragards
Rizwan Qureshi
VoIP/Asterisk Engineer
Axvoice Inc.

V: +92 (0) 3333 6767 26
E: rizwanhasham at gmail.com
W: www.axvoice.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20110324/32f1b74d/attachment.htm>