similar to: detail records graphic

hello everyone. I am running asterisk and all of my CDRs are in the default csv. the system is so limited to ram (only 256) and I cannot run MySQL or any other program to give CDRs a fancy view. at the moment the only other software running is nginx for a static webpage with guidance on the system. I do now want to move to sql or similar databases because the machine cannot handle it (I have

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

Is anyone out there using AMAFlags? I'd like to set this field as a marker to distinguish different types of calls in CDRs, but can't seem to make it respond to the documented commands Set(CDR(amaflags)=bill) or SetAMAFlags(bill). I've googled this issue, seen others have had this problem with IAX, with different DB drivers for CDR records, etc. I'm using SIP and LOCAL

On Sat, 2009-02-07 at 15:51 -0500, Alexander Lopez wrote: > > > -----Original Message----- > > From: Steve Murphy [mailto:murf at digium.com] > > Sent: Saturday, February 07, 2009 1:59 PM > > To: Alexander Lopez > > Subject: RE: [asterisk-dev] 1.4 and CDRs -- The Breaking Point > > > > On Fri, 2009-02-06 at 12:28 -0500, Alexander Lopez wrote: >

Hi Folks, I figured out how to get the AMAFlags set correctly! It was not documented anywhere I could find, and I grepped through the source code trying to track through the different function calls etc. all to no avail. But... if you note in the sample.call file, they show how to do Set(CDR(userfield|r)=whatever. I tried adding this "|r" piece into amaflags, like so:

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 Like we can define cdr field format for csv, is it possible to define if cdrs are stored in a database? Also, what will be size limit for database CDR storage ? -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110712/b5356cfd/attachment.htm>

Hi, We have free pbx installed on asterisk 1.4.25.1. Mysql is installed and asterisk is connecting to it. CDR modules are all loaded as well. For some reason, it is not creating master.csv and no cdrs are generated. Can anyone help please. --- Kind Regards, Deepika Nijhawan VoIP Engineer Oxygen8 Communications T: +44(0) 871 434 9151 +44(0) 121 620 9151

Hi all ! I'm trying to make a automonitor generated filename to "make its way" into CRD(usrefiled), so I can keep track of recorded conversations in CDR logs. Looking how to do that, I have found cool (but almost undocumented) option of res_monitor: if you set monitor format in form of "format:<string>" (i.e. "wav:monitor"), res_monitor will prefix the

Hi. i am running asterisk 11.5.1 in my system (debian squeeze) and i do get the CDRs through the csv file, that asterisk creates. i would like to have the CDRs in a nice web based tool and after some search i have found http://acdr.com.au/ i do have it installed with all the dependencies (apache, php, mysql), but i do not know how to interface the CDRs. has anyone used this tool or any other

Hello, I have an application that needs to record outgoing calls. It's running on Asterisk 1.4.18, with CDR data stored in MySQL. Outgoing calls are recorded based on their uniqueid. When outgoing calls are placed, there is a line like this on my extensions.conf: exten => _.,n,MixMonitor(/var/spool/asterisk/monitor/${UNIQUEID}.gsm) For regular outgoing calls, this works fine. The

Hi all, I am having a curious problem. I use two cdr backends, csv and MySQL. These are my settings: Call Detail Record (CDR) settings ---------------------------------- Logging: Enabled Mode: Batch Log unanswered calls: Yes * Batch Mode Settings ------------------- Safe shutdown: Enabled Threading model:

Hi guys, I've been looking for a table layout that I should be using for cdr logging to a Mysql database. Everything I find seems to be a little different. What should I be starting with before I start adding custom fields in the future? Also note I want to import some Master.csv files in to this database as well. If I can't do this I'll just start fresh, but pack porting old cdrs

Hi, I hope this can help others, so this is it. Use it at your own risk. I have test it on 3 separate systems without any problem. Take care to edit the following files taking into consideration your own settings. If you have all the CDR info in the Master.csv too, then delete all the data from the 'cdr' table in MySQL before running the script bellow in oder to prevent dupplicate

Hi All My dial plan has the following context: [sip-guest] exten => _!.,1, Answer exten => _!.,n, verbose(1,[${EXTEN}@${CONTEXT}]) exten => _!.,n, resetcdr(w) exten => _!.,n, resetcdr(w) exten => _!.,n, set(DNIS=${EXTEN}) exten => _!.,n, resetcdr(w) exten => _!.,n,

I have a problem with CDR recording in Asterisk 1.2.x. This is the situation: An Asterisk 1.2.0 (BRIstuffed-0.3.0-PRE-1 with florz) machine with a single HFC-S ISDN BRI card. I log the call records to both the Master.csv and MySQL. The problem is that when an incoming call from the ISDN line is logged to the CDR, the "src" and the "clid" field show up as something like

Kapejod is working on a fix for the CDR problem in bristuff. See below ----- Forwarded message from kpj@junghanns.net ----- Resent-From: tzafrir.cohen@xorcom.com Resent-Date: Fri, 10 Feb 2006 13:01:25 +0200 Resent-Message-ID: <20060210110125.GU16880@xorcom.com> Resent-To: tzafrir@cohens.org.il Envelope-to: tzafrir.cohen@xorcom.com Delivery-date: Fri, 10 Feb 2006 05:19:50 -0500 Date: Fri,

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

Hello - I am upgrading from asterisk v1.2 to v1.6 and I am seeing a problem with recording CDRs using MySQL. Unlike all of the other postings and web pages I have found on this issue, my installation successfully stores the -first- CDR, but nothing after that. As background info, I will note that I don't use CDRs for billing, but more in a logging fashion, to record how a given call

We have just implemented cdr-custom. Works fine minus the timestamps that appear in the CDR. The system's timezone is GMT. In the configuration usegmtime=yes is set. However, all of the CDRs in the Custom CDR comes as GMT-5. Another oddity is that the standard cdr/Master.csv is using GMT. Please advise. Thanks, kw -------------- next part -------------- An HTML