similar to: Right timing for a queue call

Hi guys I've just read this about the upcoming release of * 1.6: ?Better reporting through a new call event logging capability in Asterisk 1.6 will allow complete tracking of events that take place during a call. The goal, according to Fleming, is to provide more detail than traditional CDR (Call Detail Recording) features offer and to allow for more granular tracking and auditing.? That

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

Dears, I need to save some information on userfield when calls end in Asterisk13, but I have two error cases: 1. With endbeforehexten=no in cdr.conf, I have a registry in cdr, but userfield is not set. 2. With endbeforehexten=yes, I have two lines in cdr, one with duration, src e dst correct, and a second line with userfield setting and dst h. I am using cdr_odbc.conf, with Asterisk11.14.0 it

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

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

Hi, Surely, I must be overlooking something. If I run the following SQL queries I don't get the same number of rows. Is this coherent? mysql> select * from queue_log where queuename = '4010' and FROM_UNIXTIME(time) between 20080308000000 and 20080313145900 group by callid; 357 rows in set (0.01 sec) mysql> select * from cdr where dst = 4010 and calldate between 20080308000000

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

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. I am using two servers in my configuration: one for phones registration and another one as gateway, where all the providers are connected. Both are connected through an IAX trunk. I am having some trouble on matching both CDR?s, since durations for a call are not always the same in both servers, start/end date time are sometimes also different, etc. Is there any way to send the uniqueid of

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

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 =>

I need to carry a variable over into the 'h' priority - so I can go back and clean up DB entries in a mysql database (time of call and so on) I tried using UNIQUEID but it seems that 'h' generates a new one. Anyone have any ideas? What can I use to carry a variable over into 'h'?? later, PaulH

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 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, I am moving my call center to 1.4. Previously I was recording calls in agents.conf with the following config recordagentcalls=yes recordformat=wav createlink=yes So I had the filename in all calls which was *connected to agents*. I am looking for a similar functionality for 1.4. I am now recording calls using the following configuration. [general] persistentmembers = no eventwhencalled =

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, 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 am already using the unique in both servers, but both generate different id?s, but i am unable to get the original one from the gateway box to store it in the final CDR? -- Rui Mota Sent with Sparrow (http://www.sparrowmailapp.com/?sig) On Friday 26 June 2015 at 14:52, Tech Support wrote: > Check out the ?uniqueid? parameter in cdr.conf and cdr_adaptive_odbc.conf. > John V. >

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

Hi, Since a few days I'm experiencing this: > cdr_odbc: Connected to asterisk > cdr_odbc: Error in Query -1 > cdr_odbc: Query FAILED Call not logged! > cdr_odbc: Connected to asterisk > cdr_odbc: Reconnecting to dsn asterisk > cdr_odbc: Trying Query again! > cdr_odbc: Error in Query -2 > cdr_odbc: Query FAILED