similar to: Setting custom field in CDR

Hi All, http://www.voip-info.org/wiki/index.php?page=Asterisk+func+cdr Under example: exten => s,2,Set(CDR(MyFavoriteBand)=Foo Fighters) exten => s,3,Set(CDR(MyFavoriteSong)=Hero) and under description: -userfield: The channel's user specified field. ""-any custom value that you wish to store."" My question is how do you setup more custom fields in the cdr and be

Hello, I have Asterisk-1.8.3.2, dahdi-linux-complete-2.4.1+2.4.1, and libpri-1.4.11.5 installed and running on a Ubuntu 10.04 server all built from source. Everything is working nicely except one small issue. The CDR records are stored in the CSV file correctly and complete. The MySQL storage is working as it should and is automatically updating all the fields except the CLID field. I have

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 at restphone_event_loop:11] Set("SIP/icall-0075a2e0", "CDR(userfield)=boatmenu") in new stack But the record that's

I'm unable to set any cdr fields except userfield and accountcode using Set(CDR(lastapp)="foo") [for example]. This is 1.2.4. I'm using the cdr_addon_mysql plugin, which handles userfield, accountcode, and uniqueid fine. Is this broken in Asterisk, or the addon? The addon code looks like it's just copying what's passed in. Eric.

Hello, We have finally upgraded to Asterisk 1.4, however we've run into two issues that weren't occurring before the upgrade. Issue #1: We're an outgoing call center and need to record all calls. We use the uniqueid field in the CDR to match with the recording, which we labeled with {UNIQUEID} in MixMonitor. For some reason, the uniqueid is not correct in the CDR. Here is the

I am trying to get cdr via odbc to work on Asterisk 13.7.2 but I keep getting this error: [Feb 9 16:21:43] WARNING[2088]: cdr_odbc.c:160 execute_cb: cdr_odbc: Error in ExecDirect: -1, query is: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield,peeraccount,linkedid,sequence) VALUES ({ts

Hi, Is there a way to enable the usage of UNIQUEID CDR field using a MySQL database backend for storing CDRs without having to recompile asterisk-addons as stated here http://www.voip-info.org/wiki-Asterisk+cdr+mysql ? After version 1.4 it is said in release that it can be done (not sure if it applies to mysql backend) How would it be the syntax in cdr.conf? I tried this without success in

2013/3/29 Julian Lyndon-Smith <asterisk at dotr.com> > check out the endbeforehexten option in cdr.conf > > this needs to set to "yes" > > Julian > Unfortunately, this doesn't help. Let's drop the hangup handler at the moment, and focus on the "saving to file" part. Then my issue is I can't update CDR value is hangup exten. Here is a

The CDR, both the csv file and in MySQL does not contain the dialed number (src) in case of a call placed using .call files. "","","302","extensions","","Zap/4-1","SIP/7777-82c8","Dial","SIP/7777|40|whtWHT","2006-12-29 15:48:56","2006-12-29 15:48:59","2006- 12-29

On Sat, 25 Apr 2015 17:11:34 +0200 jg <webaccounts173 at jgoettgens.de> wrote: > > > Hi All > > > > I have dozens of these messages on CLI complaining about database > > connection and error writing CDR to disk. > > > > The curious thing is I can find them all inside the database. > > I "selected" them using uniqueid and manually

Hi All I have dozens of these messages on CLI complaining about database connection and error writing CDR to disk. The curious thing is I can find them all inside the database. I "selected" them using uniqueid and manually compared each column with the cdr_adaptive_odbc.c error line. "mysqlcheck -a -e -v DBase" and "mysqlcheck -c -e -v DBase" both returned OK for

Hi People, I had success to do my asterisk to record CDR in a databese MYSQL... Now, I need to do it to record CDR in Oracle... Does Anybody knows how to do this?? Every hints are welcome.... Thank`s all Everton Goularth Uberlandia - MG - Brazil _______________________________________________________ Yahoo! Mail - Sempre a melhor op??o para voc?! Experimente j? e veja as

Hi list! I'd like to save all information about calls (CDR) in a MySQL-Database. I created the DB and a user for Asterisk on a separate server, then I configured my cdr_mysql.conf so: [global] hostname=192.168.10.3 dbname=asterisk table=cdr password=MYSECRET user=asterisk port=3306 and my cdr.conf so: [general] enable=yes unanswered = yes safeshutdown=yes [mysql] usegmtime=no

Hi a new small question ;=) We have two Asterisk, connected in IAX2. On the first, in dialplan, we have: exten => _XX.,1,Set(IAXVAR(ACCOUNTID)=${CDR(accountcode)}) we sent into the IAXVAR "ACCOUNTID" the accountcode. On the second, in dialplan, we have: exten => 18,2,AGI(Caller-ID.agi,${IAXVAR(ACCOUNTID)}) That's work, the second server get the variable. I

Hi All, Just wanted to share a story: We turned up a new customer yesterday evening, typical situation, Cisco 2600 Router with T1 PRI card pointed to the customer's analog PBX with 2 data T1's linked back to our network. The router PRI was configured as a gateway on our CCM 4, like we've done numerous times in the past. The customer needed LD Authorization codes enabled, got

Hello, I'm using Asterisk with Realtime extensions and ODBC CDR. And I'm have some trouble with the CDR userfield that is not changed when using the SET command in the realtime dialplan. In my dialplan (extensions.conf, the file) I'm setting the userfield like this : exten => s,n,Set(CDR(userfield)="X") Later, my dialplan switches to the realtime part and this is an

Hi guys, I'm trying to write hangup causes from asterisk into the CDR record. Using version 1.4.24.1 at the moment, but no joy so far. Has anyone implemented this?

Hi list , I have a question with account codes, all my outgoing calls are authenticated, but now the boss wants to monitor these calls with the codes. example: maria has an extension "110", but peter was in place and use the phone maria , maria then says that she did not make that call to that number of cell. like to know who made it?, I think the pin code is my friendo , my users have

Hi For whatever reason we've getting 2 or 3 CDR lines logged for each call, often in different formats: as1:~# grep test-89-1e2c /var/log/asterisk/cdr-csv/*.csv

cdr_mysql doesn't set the userfield when it's set inside a macro called from a feature (1.4.25, addons 1.4.8). I have a feature code: autorecord => *1,self,Macro,apprecord The apprecord macro looks like: [macro-apprecord] exten => s,1,Playback(beep) exten =>