similar to: CDR Timestamps (cdr-custom)

Hi list, I am using Asterisk1.6.2 form a long time and upgarding to Asterisk-1.8.23.1. I am using mysql backend for cdr. in asterisk-1.6.2 i have usegmtime=yes and it works as expected insert cdr date in GMT0. now i tested Asterisk-1.8.23.1 and asterisk-11.5 with same results no matter what i configure in cdr_mysql.conf "timezone=UTC usegmtime=yes" cdr always inserted in local time. I

I have been forced to introduce a Cisco 7971G-GE into my network, because "it has a pretty screen." I have wasted nearly three days fighting with the thing based upon the information on voip-info.org and a few other forums. Asterisk is reporting a 401 Unauthorized. Which typically means bad username/password combination. Unfortunately, all of the usernames and passwords I see in

svn trunk. I'm trying to get cdr to work with my odbc database. I have followed a checklist that I had previously but still can't get it to work. There are no errors (verbose 40 and debug 40), I get [cdr_odbc.so] => (ODBC CDR Backend) == Parsing '/etc/asterisk/cdr_odbc.conf': Found *CLI> cdr status CDR logging: enabled CDR mode: simple CDR registered backend:

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

Hello, When I bridge an incoming and outgoing call (attempting to simulate call-forwarding) I'm only getting one CDR -- that of the outgoing call. A (PSTN) calls B (residing on Asterisk) and the Asterisk calls C (cell phone on PSTN) and bridges the call. The only CDR created is from B to C. I have even tried using Answer() and ForkCDR() to get two CDRs, but to no avail. I am starting to

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

Hi, I have configured the cdr throught ODBC with this files: /etc/cdr_odbc.conf [global] dsn=asterisk2 ;loguniqueid=yes dispositionstring=yes table=cdr ;"cdr" is default table name usegmtime=no ; set to "yes" to log in GMT hrtime=yes ;Enables microsecond accuracy with the billsec and duration fields /etc/cdr.conf [general] enable=yes unanswered =

HI, I am trying to setup CDR with ODBC and MySQL but get the following error :- [Apr 28 21:30:01] ERROR[14567]: cdr_odbc.c:133 odbc_log: Unable to retrieve database handle. CDR failed. I can successfully connect with iSQL so ODBCINST and ODBC ini files must be okay. I have modified /etc/asterisk/cdr_odbc.conf to include :- [global] dsn=asterisk username=asterisk password=*******

Hi, I`ve recently upgraded a server from 1.8 to Asterisk 13. While everything is under control, I have one issue with the way CDRs are kept for queues. And I don`t mean ?I don`t like it?. I mean it crashes the server. I realize there are multiple CDRs per queue call ? one per ring/per phone, basically. The issue is that whenever the number of CDRs ?to be recorded? for a call exceeds 5000,

Hello, I'm trying to configure Asterisk with Radius cdr support. Asterisk version 1.6.2.13 Server Radius: Freeradius version 1.X Radius client: radiusclient-ng version 0.5.5 With the Asterisk core debug on 1 when a call terminate, on the console appear this error: Unable to create RADIUS record. CDR not recorded! My cdr.conf is: [radius] usegmtime=yes ; log date/time in GMT

I've taken the liberty of starting a new thread to discuss the design of the Asterisk CDR mechanism. The discussion has been kindly initiated by murf putting together a proposal: http://svn.digium.com/svn/asterisk/team/murf/RFCs. After reading the proposal I still don't think it's the right way to go. To my mind adding more channel variables increases the complexity in a situation

Hi, as far as I know my problem is not a bug but wanted behaviour. Let's assume the following dialplan: exten => 123,1,Answer exten => 123,n,Dial(DAHDI/g0/00492112233,20,g) [...] exten => 123,n,Hangup I do an dial-in with my SIP-Client (or phone). The Dial-Application starts the outdial and I get connected with my partner. After hangup, only 1 CDR is generated. But I(!) need 2

Hi Gang I have not yet managed to find a solution to correctly generate CDRs for this situation: Alice calls Bob. Bob has call forwarding delayed 20s to Charlie. Charlie picks up immediately. exten => bob,1,DBget(cfwdly=CFDLY/${exten}); $cfwdly contains charlie same => n,Set(CDR(src)=${CALLERID(number)}) ; src 'alice' same => n,Set(CDR(dst)=${exten}) same =>

Hi all, I'm looking for a reporting solution for Asterisk CDRs. I have a small Asterisk server that will eventually have 4 - 6 trunks. the system is up and the CDRs are being written to a MySQL DB. I tried installing Areski, but had no success .. I assume it's no longer supported... the last update was in March 2005 according to this page..

I can?t see cdrs for calls completed with astcc app, this is the log in asterisk console: DBD::mysql::db do failed: Unknown column 'callstart' in 'field list' at /var/lib/asterisk/agi-bin/astcc.agi line 90, <STDIN> line 31. -- AGI Script astcc.agi completed, returning 0 cdrs table exist but I am not sure why is empty and why was not created properly, any idea? --

Greetings list, Whilst running through a routine check of some CDRs, I've noticed that the originating channel's accountcode isn't preserved on creating a local channel. For example, if we start with: exten => 123,1,Set(CDR(accountcode)=foo) exten => 123,n,Queue(bar,nrtw,,,) And the queue 'bar' is defined as follows: [bar] member => Local/456 at outbound member

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 all, I use astersk 11.7.0 on Ubuntu 12.04.01 TLS (i386). I use cdr_adaptive_odbc to write CDR to my MySQL's cdr table. After my testing, this scenario is working well. After a long idle time, I didn't make any call to the asterisk server. When I try to make a call again after 8 hours, I found that the cdr lost. It cannot be inserted to cdr table. Also, I could not find the insert CDR

Hello Asterisk Community, Is there a way to check in asterisk cdrs and extension forwarded? I mean, i'm calling to a ISDN number, wich goes to extension 8222, but this extension is forwarded to another one, the problem is that in CDRs i am able to see the the first step of the call, but never see the forwarded extension, how can i do that? Thanks!