similar to: problem with inserting records into cdr

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

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

I have asterisk 13.5 configured with a simple dial plan, 3 SIP clients two Laptops and smartphone with softphones installed. Now I am trying to store cdr into a database but not able to make a connection of ODBC drivers to MySQL is there an option or anything. Thanks in advance My configuration:: *sip.conf* [general] trasport=udp ;Data format | sample commennt [template01](!) type=friend

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

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

Hello, We installed AsteriskNOW (Asterisk version 1.6.2.19) and purchased FFA and G.729 licenses and installed them successfully. When we tried to install asterisk addons (we need the CDRs), we get license conflict error messages. Searching google, we see that there's a way to force install the addons, but that "way" isn't properly detailed, so we didn't manage to do it.

Hi all! I?m not sure if it is the correct place but, I?ve five boxes running asterisk and each one with his own cdr mysql database. What Im looking for is to get a core CDR system that holds information stored on each asterisk server. Have you any suggestion/process to accomplish that?. Thanks!!! Gustavo A. Gonz?lez

Good morning everyone. I wonder if it is possible, without touching the source code, to Asterisk save the cdr with date in unix time instead of the default date. It's possible? Thanks in advance, -- Rodrigo Lang Opening your mind - Just another Open Source site<http://openingyourmind.wordpress.com/> -------------- next part -------------- An HTML attachment was scrubbed... URL:

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

Hello, After 2 weeks and 4 days without a problem, Asterisk went down. What happened is that I am using Asterisk 1.2.1 on a machine and have a MySQL for CDR on another machine. The machine with MySQL went down and the Asterisk box was unable to connect to MySQL. This made Asterisk to go down and it was unable to restart until MySQL was back. I know that Asterisk displays a lot of warnings, but

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

Hello list, I keep on getting the error : ERROR[1707] cdr_addon_mysql.c: Cannot connect to database server 127.0.0.1: (1045) Access denied for user 'asteriskcdr'@'localhost' (using password: YES) I have a 'cdr' table in my MySQL-DB. On this table the user 'asteriskcdr' has select, insert, update privileges. GRANT SELECT , INSERT ,UPDATE ON `Asterisk`.`cdr`

Hi list! I'm getting this error frequently: ERROR[25193][C-0004f387]: cdr_mysql.c:203 mysql_log: Cannot connect to database server localhost: (2026) SSL connection error: SSL_CTX_set_default_verify_paths failed Right now, as a workaround, I reload Asterisk via cron once an hour, and after the reload everything is fine again _for a while_. Still, over the course of a month I lose about

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

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

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