similar to: Is uniqueid/sequence a safe CDR table primary key ?

Hi asterisk-users, We have recently moved to the 13.x branch of Asterisk from 11.x, and we're trying to correlate CDR records from multiple-legs for billing purposes. As part of this change we have added 'linkedid' to our CDR table schema in an attempt to join the multiple records into one billable record. The call path can be simplified as (transport types in brackets): SIP

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

I'm having an issue with CDR. Basically, I expect to have all "legs" of a call having the same linkedid and differing only by the sequence value. That does happen, but I'm getting null dst values after doing an attended transfer. I'm not sure if this is a bug or I'm doing something wrong. I'm running Asterisk 13.2.0. Here's the console log, step by step: First,

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

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

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

Is uniqueid globally unique? I have three Asterisk installations and I need to store data from all of them in same database, in same table. Will this uniqueid field be unique? -- Tomislav Par?ina Lama Computers Split Stinice 12, 21000 Split Tel.: +385(21)270248 Mob.: +385(91)1212148 SIP: tomo@sip.lama.hr e-mail: tparcina#lama.hr http://www.lama.hr -------------- next part -------------- A

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

I've taken the liberty of starting a new thread to discuss the design of the Asterisk CDR mechanism. The discussion has been kindly initiated by murf putting together a proposal: http://svn.digium.com/svn/asterisk/team/murf/RFCs. After reading the proposal I still don't think it's the right way to go. To my mind adding more channel variables increases the complexity in a situation

HI Matt, I am trying to replicate this particular problem. We are seeing more frequently where the Event: AsyncAGIExec is never being sent. The two scenarios I have seen in tests yesterday and today... We sendl an AMI action. For example, play a short file or hangup. AMI Events will indicate it did the work, but we never receive the Event: AsyncAGIExec with a result at all. Asterisk debug

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

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

After an upgrade to Asterisk 12, I'm "collecting" channels. When I enter and then exit a conference room, I see: -- <CBAnn/207-0000067f;1> Playing 'confbridge-leave.slin' (language 'en') -- Channel CBAnn/207-0000067f;2 joined 'softmix' base-bridge <5edb1920-3774-4ba3-8c4d-23e8fd04519c> -- Channel CBAnn/207-0000067f;2 left

hello list, i need your help about cdr ,i have installed the module cdr in my asterisk 1.4 . for the inbound calls when i call my sip exten like below : exten => 506,1,Dial(SIP/223, 10) exten => 506,n,Dial(SIP/276, 10) in CDR i have just one line with SIP /276 the last line but there is no historic for the first SIP 223 recid Record ID | calldate |clid |src

I set uniquename = MYHOST in asterisk.conf (under [options]) so that my uniqueid data shows up as MYHOST.time.seq. First of all, I would like to know if uniquename (or sysname?) will still be valid across future * versions (mainly 1.6). Secondly, is there a way to specify uniquename as an asterisk option at the command line? (asterisk -h doesn't show me anything regarding this feature)

Sometimes I get the following error on the console: [May 31 11:14:01] ERROR[23502]: cdr_addon_mysql.c:230 mysql_log: mysql_cdr: Failed to insert into database: (1062) Duplicate entry '1180628004.3214' for key 1 -- Zap/38-1 answered UniCall/11-1 Why would the UNIQUEID be duplicated? Isn't is supposed to be UNIQUE? This worries me a bit because the customer is losing calls that

Hey All, We are running a small SIP/IAX termination service at the moment (planning on growing it) with 2 asterisk machines. One terminates the SIP/IAX calls from our customers and one is our gateway to our upstream provider. Both machines are logging CDR data to the same postgres table using the cdr_psql module. The problem I am having is I'm trying to work out how to link the CDR records

Hi all, Just thought I'd update this thread in case anyone else is Googling trying to find out how to do this... I found the solution to my problem to be to use the IAXVAR() function to pass the accountcode between the Asterisk boxen and update the CHANNEL(accountcode) with that variable. Thanks to Richard @ Digium for the reply that clarified my misunderstanding. Calum On Wed, 2018-10-03

We are communicating with Asterisk via AMI. Running Asterisk version 13.18.5 on an Ubuntu box. If you look at the event response, the Result field is filled with random characters. I'm not sure what to do because that is a completely random result. It makes no sense. We send the following command to asterisk via AMI Action: AGI ActionID: C44415 Channel: SIP/192.168.40.105-00001338

Hi, I've noticed that the UNIQUEID for a call is not the same in the Dialplan (when executed e.g. exten => s,n,NoOp(${UNIQUEID}) as it is when passed via STDIN to an AGI script. Is this normal, and is this supposed to behave this way? The UNIQUEID received in the AGI is usually .001 higher than the one in the dial plan -- but sometimes it is also a second behind. Here's an example