similar to: .call files with application/data are not generating correct CDR

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, I'm trying to use Asterisk to place Automated Voice Calls. A verbose log from Asterisk CLI taken when I place a call in the spool directory looks like this: -- Attempting call on SIP/MTN-NEW/my-number for application MP3Player(/myfile) (Retry 1) == Using SIP RTP CoS mark 5 > Channel SIP/MTN-NEW-00000005 was never answered. [Jul 20 10:52:11] NOTICE[14580]: pbx_spool.c:339

Hey, I just found this in ML archives. I have pretty the same situation - i had very well written CDR processing engine on asterisk, making use of ResetCDRs, however now when we're migrating to 1.4, it's a bit pain to deal with extra CDR records. My engine is built so that MYSQL CDR can be used directly for reports (imagine - you get whatever report you need immediately). So, this way i

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

I'd like to know how everyone else is going about getting correct CDR information for calls. Right now I notice that if a call come in and gets parked the CDR info doesn't how the correct info on who picked that call up, also when someone transfer a call there isn't a new record being made so the duration of the call shows up for who received the call and transferred it. I started

Hi, I have asterisk-server version of 1.8.11-cert7. When external enemy try to using it for calling, server write this string to log: 2014-03-13 09:56:04] VERBOSE[4754] pbx.c: -- Executing [9810972592309759 at from-sip-external:1] NoOp("SIP/external-ip-00065fd2", "Received incoming SIP connection from unknown peer to 9810972592309759") in new stack [2014-03-13

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

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

In my application, I am using AMI to run an Originate command between a channel and a dialplan application (NOT a context). In my case, the application I want to invoke is FastAGI. The Originate AMI command works correctly, but Asterisk generates a very short (0-1s) duration for the CDR that results from this call, regardless of the time spent running the FastAGI application. I want the CDR

How is the billsec field calculated in CDRs? I have a situation where billsec is being reported as 0 despite the call being answered and a conversation occurring. An example record follows: '2007-11-06 21:36:50', '6495566778', '6495566778', '0116495566778', '1100012_1', 'Local/0116495566778 at 1100012_1-887b,2',

Greyman-- I'm taking this discussion to the list. Folks, what we are talking about here, is me trying to get a grasp around Greyman's (Aaron's) request for a bare-bones CDR generation that describes just total connect time for channels, stripping out all the details. Who cares about xfer, park, hold, etc.? So in the following is our discussion about what *should* be there, and in

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

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

Hello, I'm working on some dialplan rules to pull multiple users into a conference call. I have some fairly straightforward rules which start up a new MeetMe conference, allow escape with the * key to invite more users, then use a features.conf sequence to bring the new user into the conference with ChannelRedirect. The problem I'm running into is the time in the MeetMe conference

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