similar to: Preserve CDR unique across multiple servers

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

Check out the ?uniqueid? parameter in cdr.conf and cdr_adaptive_odbc.conf. John V. From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Rui Mota Sent: Friday, June 26, 2015 7:05 AM To: asterisk-users at lists.digium.com Subject: [asterisk-users] Preserve CDR unique across multiple servers Hi. I am using two servers in my

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

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 would like to see the DNID in my MySQL CDR logs. I have read one big thread in the Asterisk Developer List, but I could not figure out how to implement it ? Is there a simple step-by-step. Thx in advance. Vai

Hi to all, I actually have an asterisk server configured to write CDR mysql records in the same machine (localhost), but I want to write this records to another machine also in mysql at the same time, It is possible? It means that I want save the records in both machines. Thanks in advance. Ricardo Melendez -------------- next part -------------- An HTML attachment was scrubbed... URL:

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

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

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

With endbeforehexten=no I actually get two CDR entries. One for the call and a second one for the "h" extension. "","13","10","sip-locals","""13"" <13>","SIP/13-00000006","SIP/10-00000007","Dial","SIP/10","2015-08-04 06:28:44","2015-08-04

Hi, I'm trying to migrate from Asterisk 1.8 to Asterisk 13 and can't figure this one out. I'm pretty sure the question has been already asked, but I failed to find a solution. Can you modify CDR values in an h-extension? My cdr.conf contains: [general] enable=yes unanswered=yes endbeforehexten=yes initiatedseconds=no batch=no The diaplan contains a simple "h" extension

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

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

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, Reading this old thread, may I ask if keeping hangup handlers from updating CDR values still enforced in Asterisk 15 ? If positive, would it be very complex to add in Asterisk, a configuration option allowing a system administrator to list in cdr.conf, the CDR fields allowed to be updated in hangup handlers ? I'm planning to store some RTCP stats. Saving them in CDR(userfield) would be

I would like to send the CDR records from all our machines around the world to a single database. But I need the hostname included with each record for monitoring purposes. Is there a better way than using the userfield and adding SetCDRUserfield for every call to set the userfield to the name of the host? Thanks...

Hello everybody, I'd like to have more detailed records for calls related to queues. For instance, if A enters in queue X, waits for Y secs and then talks to peer Z for T seconds, I'd like to have two entries in my CDR: - src: A, dst: X, duration: Y, state: ANSWERED - src: A, dst: Z, duration: T, state: ANSWERED This independently from how many peers the Queue app calls without success