similar to: asterisk CDR and mysql

Hello, I created a new field named pre_dst of type varchar(80) exactly like dst field in cdr table. In the dialplan I put: exten => _7.,1,Set(CDR(pre_dst)=${EXTEN:1}) and when I call, all goes fine except that pre_dst has always NULL value in cdr. Do you know why? Is something wrong I did? I know that original fields in cdr are only readable, but in this cas pre_dst is one I created

Hello, We have finally upgraded to Asterisk 1.4, however we've run into two issues that weren't occurring before the upgrade. Issue #1: We're an outgoing call center and need to record all calls. We use the uniqueid field in the CDR to match with the recording, which we labeled with {UNIQUEID} in MixMonitor. For some reason, the uniqueid is not correct in the CDR. Here is the

What would it do if you exten => h,1,ResetCDR(w) exten => h,2,NoCDR() exten => h,3,DEADAGI(get-unqiueid.php) I have not tried it but in theory it should write the first CDR and then kill the write of the second NO ANSWER CDR. Let me know if it works for you as I may need to do it on some of my h exten code as well. Bryant ---------------------------------------- From:

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

Hello folks, i installed asterisk 1.8 from repo: https://wiki.asterisk.org/wiki/display/AST/Asterisk+Packages And Looked at this article about CDR in mysl. http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql I installed asterisk-mysql pacakge from debian repo. The cdr in mysql is working, but i can not get cdr adaptive colums are not, i use this in my extension.conf exten =>

> Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database. > I created the DB and a user for Asterisk on a separate server, then I > configured my cdr_mysql.conf so: > > [global] > hostname=192.168.10.3 > dbname=asterisk > table=cdr > password=MYSECRET > user=asterisk > port=3306 > > and my cdr.conf so: > >

Luca Bertoncello wrote: > Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database. > I created the DB and a user for Asterisk on a separate server, then I > configured my cdr_mysql.conf so: > > [global] > hostname=192.168.10.3 > dbname=asterisk > table=cdr > password=MYSECRET > user=asterisk > port=3306 > > and my

Hello, I have now been playing with Asterisk for about a week and absolutely love it! Unfortunately I seam to be having a problem with cdr records and mysql via the ODBC method It would appear to all be set up properly, and I am able to successfully. log inbound/outbound activity into my mysql cdr database. All the inserted values appear to be correct and meaningful but for the Duration

HI, I am trying to setup CDR with ODBC and MySQL but get the following error :- [Apr 28 21:30:01] ERROR[14567]: cdr_odbc.c:133 odbc_log: Unable to retrieve database handle. CDR failed. I can successfully connect with iSQL so ODBCINST and ODBC ini files must be okay. I have modified /etc/asterisk/cdr_odbc.conf to include :- [global] dsn=asterisk username=asterisk password=*******

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

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

Hello, I am using CDR mysql to log to remote server: in modules.conf, I preload the modules: [modules] preload => cdr_mysql.so preload => app_mysql.so and in cdr_mysql.conf, I have all the details defined (hostname, dbname, table, password, user, port). In a situation when I start asterisk, and the remote database in unreachable, asterisk waits for several minutes before it actually

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

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

Hello! I just encountered a strange thing in my mysql cdr records. From a certain date on Asterisk (1.4.6) stopped to populate the CLIR and SCR flieds in the cdr table. As far as I know no changes happened to the system on that date and until then CLIR are recorded properly. The CLIR is still transmitted by the PRI and is shown in the console when a call comes in. But no traces of it in the CDR.

I installed asterisk on two machine to load balance and to fail over. One is local and one is on a remote location. The record the cdr I use the mysql module and odbc. So I update a local (on each asterisk box) mysql db using mysql module and also I update a centralized mysql db using ODBC. I tought in this way I couldn't loose any record. But this is not true. Even with 2 updating process I

Hi All, Currently i'm facing with a cdr issue, When i originate a call (outbound call) to uncorrect/unregistration user, asterisk inform me that call was failed but in mysl-cdr (cdr-csv also) records. Here are 2 samples +---------------------+------+-----+-----+----------+---------------------+------------+----------+-------------+-----------+ | calldate | clid | src | dst |

-----Original Message----- From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of jg Sent: Monday, July 06, 2015 4:14 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDR in an MySQL-Database > Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database.