similar to: Deleting some of the CDR data - How to do it safely?

I have a bunch of CDR records in the mysql database "asteriskcdrdb" on a FreePBX system. There is a DAHDI trunk defined in FreePBX which uses the "gN" identifier to make calls. So in this setup the trunk is roughly equivalent to a DAHDI logical group. I want to know, given a CDR, which logical group (and therefore, trunk) was used to place the call, or was used to receive the

Hi Everyone, Just noted that PBXinaFLASH failed me again on yet something else. The uniqueid field didn't update on the asteriskcdrdb in the past few months but it is available in the .csv files in /var/log/asterisk/cdr-csv/*.csv I have already re-did the asterisk-addons install with correct parameters to include future calls "uniqueid" in the table (I have no clue why these

Hello, is there anyone who can point me to correct information ? Following http://pbxinaflash.com/forum/showthread.php?t=9042 and http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql > Extending CDR does not result in a working environment for me. Any feedback appreciated. Kind regards, Jonas. -------- Original Message -------- Subject: [asterisk-users] Asterisk 1.6.2.10 & CDR

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:

Hi guys, I have recently installed a Asterisk Server with CDR Call Detail Records. I have installed it over a Asterisk 1.2 , but now It do not run . I have installed it with the following procedure: # yum install ncurses #yum install openh323-devel # yum install mysql-server # yum install mysql # yum install php-gd # yum install php-mysql # yum install mysqlclient10 # yum install zlib # yum

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 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 Guys I am just looking around for a small billing program but can't really find what I am looking for. It needs to bill straight off the CDR. It should grab all the CDR records from the asteriskcdrdb mysql database then have a rates table to that it calculate a bill from. Is there any open source packages or commercial packages that will account for billing say only 5 extensions?

Hello list, I have added an extra field "mycolumn" to the cdr table in my MySQL-DB. I simply try to add a value to this column by doing the following in the dialplan : exten => 600,n,Set(CDR(mycolumn)="myvalue") But this value is not written to the column 'mycolumn' together with the other CDR-data. Why is this ?! Do I need further configuration ? (Not

Hi, I have Fedora Core 2 running with a T1 card. I try to put the log on db but I get the error: Aug 20 15:17:47 ERROR[262160]: cdr_addon_mysql.c:378 my_load_module: Failed to connect to mysql database asteriskcdrdb on localhost. The database exists and I try with "mysqlaccess localhost asteriskcdrdb" and I get: Access-rights for USER 'localhost', from HOST

Hi Everyone, I am trying to install the new cdr-stats from http://www.cdr-stats.org/ for Asterisk 1.6 but it's installation instructions are all garbled. It mentions both sqlite and mysql and there are no organized documentation. Not to mention that the apache port 8000 and port 9000 are also confusing and I don't know why is it not easy enough as adding a /var/www/html/cdr-stats rather

Hi; I have problem inserting cdr to mysql,Asterisk has logged to asteriskcdrdb successfully.It says: Dec 6 13:36:26 DEBUG[1221985728]: cdr_addon_mysql.c:178 mysql_log: cdr_mysql: inserting a CDR record. Dec 6 13:36:26 DEBUG[1221985728]: cdr_addon_mysql.c:197 mysql_log: cdr_mysql: SQL command as follows: INSERT INTO cdr

Hi, I hope this can help others, so this is it. Use it at your own risk. I have test it on 3 separate systems without any problem. Take care to edit the following files taking into consideration your own settings. If you have all the CDR info in the Master.csv too, then delete all the data from the 'cdr' table in MySQL before running the script bellow in oder to prevent dupplicate

Hi 1. What is the best way to convert wav (44000 Khz) to gsm format for asterisk ? I;ve tried sox command but the outcome is not satisfying...The built-in gsm files shipped with asterisk are simply superb ..How do i create gsm files of similar quality ? Can anyone help me out ? if sox is the only way can anyone tell me the exact command ? 2. Can Freepbx 2.5 installed above asterisk 1.6.0 or

hi all, I've been noticing some unknown traffic in my cdr logs approximately 50 quantity like this; 2009-01-29 08:17:24 SIP/96.9.1... BenQTelecom "BenQ Telecom" s ANSWERED 00:20 I wonder that have anyone ever faced like this problem ? I think it's a security problem, when I googled I have found one topic explanation in english

Hello everybody, I have a question about value dst of cdr table in asteriskcdrdb, so in my db I see many registers with letter "s" in dst field, I found a opinion that "s" is the default extension and the all calls enter the system as "s" and are then changed as they pass through the dial plan, so, if you have an IVR and they hang up during the IVR, the call will be

Greetings list... I have a Trixbox based Asterisk system and would like to implement a loose call accounting system. The system is built on Trixbox version 2.2.8 with Asterisk 1.2.24 and FreePBX 2.3.1. Because there are a couple thousand existing account codes for various projects, and new account codes are created by the accounting dept. I cannot create pin sets using the add on module included

I am trying to get cdr via odbc to work on Asterisk 13.7.2 but I keep getting this error: [Feb 9 16:21:43] WARNING[2088]: cdr_odbc.c:160 execute_cb: cdr_odbc: Error in ExecDirect: -1, query is: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield,peeraccount,linkedid,sequence) VALUES ({ts

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!

6I am using asterisk 1.4.5 and storing cdr in mysql . Here's example of one cdr generated 2007-06-26 00:44:28 682345xxx 6823456xxx s macro-dialout-trunk SIP/343684-09544f20 SIP/provider-0938de98 Dial SIP/provider/1386734xxxx|300| 28 5 60 1 0 ANSWERED I have maximum entries like this one in my cdr . Here outbound extension is shown as