similar to: Remote CDR logging on mysql:

Folks! Let me clarify something to the Asterisk community about the CDR tool. 1) This is *not* my code to start with. I picked the original code from this forum here... http://www.voip-info.org/tiki-index.php?page=Asterisk%20CDR%20Areski%20GUI 2) The original code was not working (for most part, as the MySql portion has bugs) and I fixed this and added a few bells and whistles. 3) The

I would like to send the CDR records from all our machines around the world to a single database. But I need the hostname included with each record for monitoring purposes. Is there a better way than using the userfield and adding SetCDRUserfield for every call to set the userfield to the name of the host? Thanks...

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

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

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

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

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

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

Hello, I'm using Asterisk 1.6.2.0-beta3 with asterisk-addons-1.6.2.0-rc1 to write cdr into mysql. I followed: http://www.spiration.co.uk/post/1327/asterisk-addons%20setting%20up%20mysql%20cdr%20for%20Asterisk, and it is mostly working however CLID is not written to mysql, although it appears in Master.csv. What do I possibly missing? TIA -- Best regards, pepesz76

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi guy's I've got an existing application which takes CDR information from a com port from an avaya switch, that we use for billing and accounting. Since the cost up upgrading the Index platform is extortionate, we're looking into alternatives and I've been told to come look at asterisk. First off, asterisk is excellent...

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

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

In my application, I am using AMI to run an Originate command between a channel and a dialplan application (NOT a context). In my case, the application I want to invoke is FastAGI. The Originate AMI command works correctly, but Asterisk generates a very short (0-1s) duration for the CDR that results from this call, regardless of the time spent running the FastAGI application. I want the CDR

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

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,

Hi. i am running asterisk in a low powered machine (alix2d13 from pcengines) without any gui. the machine works fine to route all my calls for the office. the problem is the management of the CDRs. i can see the master.csv file, but it is not very friendly for the secretary of this office to manage the calls. is there a way to have a nice way to see the CDRs?Since the machine is very small on

When you use a product which version number is 11 or even 12, you might go with the assumption all big bugs are fixed and then you find there is a huge, important, expensive bug still running in the code we are relaying upon... The problem is simple. If you transfer a call, that dialing will be not reported in the CDR, so no billing will happen. This is a simple example: Extension 100 calls

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