similar to: Default table layout for cdr logging with Mysql

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

Hi all, I think I've run out of options in terms of what I know about this. I have created a user called asteriskuser and granted all privileges to the asteriskcdrdb database. Then I created the table via the cdr_mysql.txt file. I have edited the cdr_mysql.conf file to reflect this, and added load => cdr_addon_mysql.so after compiling it from the latest CVS. If I check the

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

Hello, I have now been playing with Asterisk for about a week and absolutely love it! Unfortunately I seam to be having a problem with cdr records and mysql via the ODBC method It would appear to all be set up properly, and I am able to successfully. log inbound/outbound activity into my mysql cdr database. All the inserted values appear to be correct and meaningful but for the Duration

I have placed the custom-cdr-V1.0.tar for download http://www.itsngroup.com/software/asterisk/downloads/ Thanks > Dear Ben, > I've also the problems as Chris Mason, Can you send us your own AGI CDR > logging application? > Best regards, > Jian Hong Guan > France > www.directcentrex.com > > >

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'm using asterisk 1.8.23.1 but I've seen this same issue in previous versions of 1.8. I have created some work arounds but the behaviour is incorrect. This is the scenario: Call comes in and goes to appropriate dialplan In the dialplan the call is forwarded to another number using a Local channel (and using /n ) e.g. Dial(Local/<my-number>@outbound-context/n,60) The number is

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

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

I'm attempting to setup Asterisk 1.4.0 CDRs to use MySQL. Modules show like cdr_mysql.so tells me it is loaded. Reload cdr with MySQL started or stopped makes no difference in the errors. Ideas? -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20070220/55700f37/attachment.htm

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'm trying to setup remote CDR logging, as directed by: http://www.voip-info.org/tiki-index.php?page=Asterisk%20cdr%20odbc Anyone have example of what I need to change to make an asterisk server log on a remote mysql server? -------------- next part -------------- An HTML attachment was scrubbed... URL:

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

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:

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

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

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

Hello, I've migrated from CSV CDR to MySql CDR and the customization of my CDR's is not working anymore. Do you know if the cdr_mysql is supporting custom cdr's ? If not, is there any alternative/workaround ? Best regards, Patrick

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