similar to: CDR records.. How do you deal with them?

Hi list, I have a couple of questions related to asterisk billing and the generation of cdr logs. I've searched the wiki but have not found my answers, hopefully you guys can help. 1) When are asterisk CDR logs _normally_ generated? When the call arrives, when the call hangs up, or both? I have looked at the records created and it seems to only generate it at the time the call is

I have a Astlinux system that can't run mysql. I want to bill calls by extension but all I have is the raw CDR files. Is there any software that cal produce a simple call accounting from text CDR files? -- Chris Mason NetConcepts (264) 497-5670 Fax: (264) 497-8463 Int: (305) 704-7249 Fax: (815)301-9759 UK 44.207.183.0271 Cell: 264-235-5670 Yahoo IM: netconcepts_anguilla@yahoo.com --

Hi All, I'm stuck and need some help. I have installed the Asterisk CDR Analyser Version 2.0.1. It mostly works except for the CDR Report. I get the following error even though it lists the CDR details. Database error: Invalid SQL: SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE UNIX_TIMESTAMP(calldate) >=

Hi all, I need 2 CDR Records of below 2 numbers for outgoing calls, detail is given as below: *96XXXXXXXX88XXXXXXXX* *=> Call file : outbound call generate through below file* Test.call ====== Channel: local/s at outgoing/n WaitTime: 45 Context: outgoing_ivrs Extension: s Priority: 1 Set: contact_no=96XXXXXXXX extensions.conf ============ [outgoing] exten => s,1,NoOP(----- First LEG

Hello Asterisk-Users, For some reason my CDR records for disposition and billsec are not working correctly. I always receive a 0 for billsec and the disposition is always at "NO ANSWER', even when I grab the calls. I experience this with Asterisk 1.6.0.1 and Asterisk 1.4.22. Here is information on how I do the call: -----------------------------------------------------------------

My CDR is displaying wildly inaccurate results. When I make a call the CDR records the time between connecting into the server and hanging up, instead of recording the time between dialling from the server to the PSTN destination via VOIP termination. It is alright to log the duration of the connection to the server, but why it does not log calls for termination via voip provider is the main

Hi list, I use AMI to originate calls for outbound campaigns via local channel. I use CDR records to have status of the calls such as : disposition, if call was answered by live human or answering machine, reason of call failure and make accounting based on total calls that have been made. My problem is that I have more than one CDR records for a single call. One for the Leg A

Hi ! I just wrote cdr_sqlite.c, see http://bugs.digium.com/bug_view_advanced_page.php?bug_id=0001986 This little app creates automatically the sqlite database file in /var/log/asterisk/cdr.db, creates a table 'cdr' inside it and inserts all CDR records into this table. Please comment. I'll use this in my project DESTAR (http://www.holgerschurig.de/destar.html) to show these

dear all, i facing one big issue in CDR , i have one user connected in meetme and then and after some time one user are joined meetme bu this user was originally dialed by , AMI via Originate and when remote user picked up call he joined meetme room everything is fine , but now 1 st user kicked 2 nd user , via using menu options or by typing "meetme kick 1234 2' user disconnected

I'm trying to configure CDR records to store them in MySQL database but those instruction are not very clear from: http://www.voip-info.org/tiki-index.php?page=Asterisk+cdr+mysql I've MySQL up and running I'm just not sure what database to create and as the configuration Sample cdr_mysql.conf is not consistent from instruction on: Create the database Do I create database name

Hello! I just encountered a strange thing in my mysql cdr records. From a certain date on Asterisk (1.4.6) stopped to populate the CLIR and SCR flieds in the cdr table. As far as I know no changes happened to the system on that date and until then CLIR are recorded properly. The CLIR is still transmitted by the PRI and is shown in the console when a call comes in. But no traces of it in the CDR.

I installed asterisk on two machine to load balance and to fail over. One is local and one is on a remote location. The record the cdr I use the mysql module and odbc. So I update a local (on each asterisk box) mysql db using mysql module and also I update a centralized mysql db using ODBC. I tought in this way I couldn't loose any record. But this is not true. Even with 2 updating process I

Hi Rosario, I have a problem about CDR: inbound calls are not correctly logged in CDR, it says they are always answered even if they are not. It is very strange since outbound calls and internal calls don't suffer this problem. I'll tell you more: I made Asterisk print the DIALSTATUS variable and it is ok, says BUSY when my internal hardphone SIP is busy. Or maybe it is allright and

I am experiencing a very wired problem. Some of my cdr are lost. I use logging cdr to csv, mysql and odbc. But some of them are lost. They miss in csv mysql and odbc, so i'm pretty sure it is related to asterisk functioning. I am running asterisk 1.0.7; this is simple configuration file: extensions.conf [general] static=yes writeprotect=no [macro-gw-voipjet] exten =>

I am using VoiceOne http://voiceone.it/ as my management interface. I am not 100% sure when it started, but my CDR is now full of "s" as the DST instead of the actual dialed number. As I understand it - it is because it is being recorded in the CDR while in a macro (as below). Is there any work around so that I can record the actual dialed number? [macro-dialout] exten =

Our phone operators work off of an Asterisk queue. They take calls from customers and take orders with our back end systems. What I need to be able to do is tie the orders taken to the specific CDR record that reflects the call from which the order originated. The typical/sample CDR table doesn't have a primary key. I can add an auto-generated PK, but the CDR is not written until the

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

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

Hi, I have some (5-10 per day on an average 250 calls/day) incoming calls dropped after 25 to 60 seconds. Asterisk is 1.2.10 + BriStuff 0.3.0-PRE1s on one hand (with 4 ISDN lines...) Snom 320 SIP IP Phone (release 6.2.3) on the other. With SIP Debug on, it *_looks_* like a normal call clearing, but the users are complaining, stating that no one on either end had hanged up. Doing a "sip

hi i've made some test calls, i've notice that a call of the duration of 1:29 minutes is recorded in the cdr database as 1:45 minutes, is it normal? i think that 15 seconds are too many... how can i correct this? thanks