similar to: mysql CDRs in web based tool

Hello! I have been doing some tests with call transfers and I have been looking at the CDRs that Asterisk generates. Scenario 1: A calls B B answers and does a blind transfer to C (using # key) C answers and talks with A Scenario 2: A calls B B answers and does an attended transfer do C (using the phone's transfer key) C answers, B hangs up, and C talks with A For scenario 1, the CDR shows

I have created an asterisk.org blog entry: http://www.asterisk.org/node/48358 to describe what I will shortly be committing to trunk to correct the weaknesses of CDRs, that asterisk users and developers have been complaining about for quite some time. Highlights: Restructuring the code and philosophy of CDRs. Plans to eliminate the ForkCDR() application Plans to create

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

All, According to my readings CDRs are stored at the end of the call. My concerns is when asterisk goes down (I know that it's never happen but it's just in case) or when the is a power shutdown of the server. then CDRs are not stored in mysql. is there a way to store periodially CDR during a call, and set the periodical timer regarding the context. if no is there a way to retreive CDR,

Hello guys, I need to be able to throw cdrs on more than one servers at a time. Please let me know how this can be done. Thanks

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>

Is there a way to retrieve the Call-ID from a call made using the 'Dial' command on a SIP channel without CDRs (i.e. variable) ? Thanks, - Darren

Does anyone know where that nice .php is that was written to access the CDRs from mysql DB? Bruce W. Hedreen Computer Technologies of Eastern Carolina, LLC --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003 -------------- next part -------------- An HTML attachment was

How can I download the asterisk-addons and setup CDR support for mysql? I reviewed the wiki but did not find instructions on dowloading. Just a sample of the cdr_mysql.conf file. DaL -- David A. Lauer Network Engineer Tristar Communications dalauer@tristarcorp.net 954.977.8081 ext. 21

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 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! I just found out that Asterisk (1.4) does not write CDRs if the incoming call was not forwarded but handled internally without answering the call. E.g.: [from_pstn] exten => 997,1,Answer() exten => 997,2,Playback(tt-weasels) exten => 997,3,Hangup() exten => 999,1,Playback(tt-weasels|noanswer) exten => 999,4,Hangup() For incoming calls to 997 a CDR will be written, but not

Dear All, We are trying to install CDR Stats module. We are able to open its web pages but unable to retrieve data from CDRs. Can anybody suggest that how to connect this module with Asterisk CDRs database ? Regards, -- Kashif Naeem Business Development Manager Hadi Telecom www.haditelecom.com Cell: +92 (0)345 4226006 Office: +92 (0)42 5692766 Email: kashif at haditelecom.com MSN:

Hello I configured Asterisk to put CDRs in the database like it was explained in: www.voip-info.org/wiki/view/Asterisk+cdr+pgsql What I want to know is how do the billing solutions (like Asterisk2Billing) work with Asterisk. The billing system just use the information that Asterisk puts in the CDR table? Or they connect directly to Asterisk? Or is Asterisk that has, before the Dial command,

Suggestions on how to use Asterisk to collect CDRs from a OpenSER-based proxy / call routing setup? I need to get simple CDRs; not for detailed settlement/rating, but just for reconciliation with an ultimate TDM carrier just to make sure we only get billed for what we're actually using. I'd use the often-heralded approach of dumping a call from OpenSER into Asterisk and having it

For redundancy I would like to write the CDRs on tow mysql servers. cdr_mysql.conf accept only one configuration [global], how to add a second host? Thanks Rosario -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20050609/9eacbae2/attachment.htm

Looking at the code, it would appear that the 'callstart' column of the cdrs table should really be called 'callend': $dialstr = "IAX2/$res->{path}/$phone|30|HL(" . ($maxtime * 60 * 1000) . ":60000:30000)"; $res = $AGI->exec("DIAL $dialstr"); $answeredtime =

Hello, There seems to be a problem with asterisk cdrs when calls are generated via AMI Originate using Local channels. Asterisk writes CDR as soon as A party off-hooks. Resulting in very inaccurate billsec and duration values. Expected CDR in case of local channel origination should be 2 records, one can be when A party answers, and the other should be written when B party hangs up the phone.

Hi, Has anyone made a successfull instalation of cdr_odbc?? I've install unixODBC-2.2.8 (made my own RPM) and then built the module. I'm trying to send the cdrs to a M$ SQL server. The sql connection works because I can do any query via isql. When I do the calls I get the following output on the asterisk console: -- Executing Hangup("SIP/test1-a5e1", "") in new

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