Jonas Kellens
2011-Mar-24 08:55 UTC
[asterisk-users] 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>
Rizwan Hisham
2011-Mar-24 09:45 UTC
[asterisk-users] Fwd: Asterisk 1.6.2.10 & CDR custom added field
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>
Maybe Matching Threads
- Asterisk 1.6.2.10 & CDR custom added field
- Basic question: Reading in multiple choice question responses to a single column in data frame
- pjproject 2.5.5 + asterisk-certified-13.8-cert1 : many Error loading module...undefined symbol
- Asterisk 11.23.0 on CentOS6 : how to get ICE support ?
- basic information defining functions