similar to: CDR Help

Hi to all. What can i do if a customer needs to log in the CDR all the dialpan actions related to a call? I mean, not only the lastapp e the lastdata but all the dialpan actions! I know that the actual CDR system store one record for each call (and for billing purposes this can be correct) but in some cases the approach needed is something similar to the queue_log. I know that exists ResetCDR

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

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

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 have problem inserting cdr to mysql,Asterisk has logged to asteriskcdrdb successfully.It says: Dec 6 13:36:26 DEBUG[1221985728]: cdr_addon_mysql.c:178 mysql_log: cdr_mysql: inserting a CDR record. Dec 6 13:36:26 DEBUG[1221985728]: cdr_addon_mysql.c:197 mysql_log: cdr_mysql: SQL command as follows: INSERT INTO cdr

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, I am diverting an incoming call to a mobile phone and a landline using the following:- exten => 0203000000,3,Dial(SIP/442080000000 at sipprovider&SIP/44700000000 at sipprovider,120,r) For billing purposes, i need to be able to work out whether the diverted call was answered by the mobile or whether it was answered by the landline. The CDR only shows the full Dial() information, and

Hi We're using asterisk 1.8.23.1. Our inbound calls are routed into the default context with explicit number matching. If found they are passed on to a distinct context for the number being called using the Goto application. If the call is successful or even if it has no answer, the cdr dcontext field has the correct second context. However, if the call fails or is busy, and even though we

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

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, I have problem with interpretation of CDR entries. What happened? ------------- There was: 1. at 09:00:26 we received call from unknown caller (no callerid) to secretary with extension 17 2. secretary answered and after some conversation called to extension 18 to check if she could transfer customer call 3. at 09:02:55 extension 18 answered and call was forwarded 4. call was very long

Hi all, I have a strange problem, regarding zap channels and cdr. I am using asterisk bristuffed version Asterisk 1.2.2-BRIstuffed-0.3.0-PRE-1i, Copyright (C) 1999 - 2006 Digium, Inc. and others. with two billion ISDN cards. I also installed asterisk addons, last stable version via cvs internal calls, or calls starting from internal sip or iax phone are recorded in the cdr all without any

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

Upgraded from 16.2.14 to 1.6.2.15 on Fedora 13, with aastra 9133i and 57i. On 9133i and 57i: #<extension># works for a blind transfer. Xfer<extension>Xfer doesn't! All this worked on 1.6.2.14. Nothing useful on cli, verbose 3, DEBUG. Here extension 169 answers an outside call, and tries to transfer it to 145 using the Xfer button: -- SIP/169-0000009c answered

-----Original Message----- From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of jg Sent: Monday, July 06, 2015 4:14 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDR in an MySQL-Database > Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database.

Both of our production asterisk servers are dumping core when making writes to our cdr tables. Here is a backtrace of the problems we are having: #0 0x00447b1f in tdserror (tds_ctx=0x1, tds=0xb7938c90, msgno=20004, errnum=9) at util.c:347 347 if (tds_ctx && tds_ctx->err_handler) { (gdb) bt #0 0x00447b1f in tdserror (tds_ctx=0x1, tds=0xb7938c90, msgno=20004, errnum=9) at