similar to: MySql and custom CDR

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

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, 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 guys, I would llike to ask for your help on a problem I'm having with the cdr functionality. I installed asterisk 1.0.4, and asterisk-addons-1.0.4 and followed the procedures for installation and mysql configuration. Everything seems fina. The cdr_mysql module is loaded, and I get no error messages. But the cdr's are not going to the mysql database, they are going to a csv file in

Can someone tell me what is wrong here: Feb 2 19:45:44 ERROR[1074441696]: cdr_addon_mysql.c:381 my_load_module: Failed to connect to mysql database asteriskcdrdb on localhost. The database is created, cdr table also, the username and password is right. I have tried configuring cdr_mysql.conf to connect via localhost mysql.sock or via tcp port, but in both cases I got this error. Thanks!

-----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 all, I'm trying to activate (on Asterisk 1.6.0.13) the cdr_mysql addon, but without success. Is there a proper online manual that describes all the steps to follow and debugging/monitoring information? When I type in the CLI "module show", cdr_addon_mysql.so is not listed, although in modules.conf, I added the line "load => cdr_addon_mysql.so". I also tried

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 all, I am using the msql cdr module to store cdr in db, I realised that it does't capture the start and end time af a particular call record. Therefore I dive into the source code to add the start and end time into the query (add something like cdr->start, cdr->end), but end up getting segfault. the original version of cdr_mysql.so works fine but I need the start time and end

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'm trying to add mysql CDR onto a vanilla Asterisk 1.2 install. The add-ons pack has been installed for a while, so now I'm trying to add the Mysql config. I've created a mysql database, added the grants for a user acces, and can run a mysql -u asteriskcdruser -p and can connect to the database. I've been using this as a guide:

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

Hi, Need help on mysql cdr, i keep on seeing this log on the console. but my db is up and i see the calls being logged on the cdr table. is there a timeout when there is no activity? can i remove the timeout if there is any? thanks [Nov 25 13:22:37] ERROR[21026]: cdr_addon_mysql.c:171 mysql_log: cdr_mysql: Server has gone away. Attempting to reconnect. [Nov 25 14:20:32] ERROR[21061]:

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:

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

For the information of others (and Google) this is the table structure I used to get cdr_mysql working: CREATE TABLE cdr ( calldate varchar(255) NOT NULL default '', clid varchar(255) NOT NULL default '', src varchar(255) NOT NULL default '', dst varchar(255) NOT NULL default '', dcontext varchar(255) NOT NULL default '', channel varchar(255)

Hi All, I have some Asterisk 1.2 servers using the cdr_mysql addon (1.2.3) spitting cdr's over to a MySQL database on another server. All is working well except for a strange problem I ran into this morning. During some cdr database maintenance, the cdr table was locked for a few minutes, during this condition all the Asterisk servers stopped processing calls and reported this error: Jan 5

Hi. For several months now asterisk will mysteriously stop inserting records into cdr database. I am using mysql and the asterisk addons 1.6.2 to accomplish this. Sometimes there is a strange error about column names, but often there is no error, it just stops. I just have to restart asterisk to get things going again, so I am stumped as to what is happening, or even how to troubleshoot. I

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