similar to: How to install the new cdr-stats?

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?

Hi, I write the CDR of my Asterisk 1.2.17 server in MySQL database using cdr_addon_mysql.so. Now I'm trying to write some custom values to userfield column by the SET(CDR(USERFILED)=SOME_TEXT) sintax, but nothing gets writeen in MySQL cdr table!! Why? I'm I skeeping something or what? Taking a look at the URL:

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

Hi, I have configured the cdr throught ODBC with this files: /etc/cdr_odbc.conf [global] dsn=asterisk2 ;loguniqueid=yes dispositionstring=yes table=cdr ;"cdr" is default table name usegmtime=no ; set to "yes" to log in GMT hrtime=yes ;Enables microsecond accuracy with the billsec and duration fields /etc/cdr.conf [general] enable=yes unanswered =

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

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

Hi everybody, i've been googling for quite some time now but can't find an answer to my problem... I'm using Asterisk 1.2.12.1 with mysql as the cdr backend. In the dialplan i've written exten => 1234,n,Set(CDR(userfield)=blah) exten => 1234,n,Answer() exten => 1234,n,Queue(.....) exten => 1234,n,Hangup() When I'm doing a call I can see that the statement is

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!

Trying to do something like this in the sip.conf under my incoming provider profiles: setvar=CDR(accountcode)=${EXTEN} It seems to show up in the CDR but it's showing up exactly like this "${EXTEN}". Is there a way to stuff the DNIS (number dialed) into the accountcode for CDR? I have already accomplished setting on a number by number basis, I just want to do it globally for all

I have A@H 2.1, running * 1.2.1. I am trying to put information into the userfield with SetCDRUserField and AppendCDRUserField. However, the field is never populated in the cdr - I've checked the csv files and the MySQL asteriskcdrdb table. The field is defined in the MySQL table, but is always empty. The csv files that get created don't have a userfield at all, that is, there

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

Humm whats is the diferent? Em 16/12/2015 14:19, "Annus Fictus" <annusfictus at gmail.com> escreveu: > CDR-STATS is for reporting. > > A2Billing is for billing... > > Regards > > El 16/12/2015 a las 11:15, Vitor Mazuco escribi?: > >> Hi everyone! >> >> I'm trying to install CDR-Stats (cdr-stats.org), but it very difficult. >>

Hi everyone! I'm trying to install CDR-Stats (cdr-stats.org), but it very difficult. Is there others optins for billing? Thanks

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