similar to: cdr mysql amaflags field

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

Hi Folks, I figured out how to get the AMAFlags set correctly! It was not documented anywhere I could find, and I grepped through the source code trying to track through the different function calls etc. all to no avail. But... if you note in the sample.call file, they show how to do Set(CDR(userfield|r)=whatever. I tried adding this "|r" piece into amaflags, like so:

Hi, when i use Set(CDR(amaflags)=1) in my dial plan , after a call. i look at the cdr table in mysql database. the value of amaflags is -1 not 1, do you know what's wrong? Thanks! -- Best regards, Sucan

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

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 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 Asterisk-1.8.3.2, dahdi-linux-complete-2.4.1+2.4.1, and libpri-1.4.11.5 installed and running on a Ubuntu 10.04 server all built from source. Everything is working nicely except one small issue. The CDR records are stored in the CSV file correctly and complete. The MySQL storage is working as it should and is automatically updating all the fields except the CLID field. I have

Can someone help me, im using latest CVS, asterisk and cdr_mysql, when I make a bridge call (using .call files in outgoing/) I always get 'billsec=12' in the cdr, both mysql and Master file even if the call lasted longer, watching the Master file while making a call I see it updated at 12 seconds even while im still 'in' the DIAL app and the call continues on just fine. Iv looked

I am trying to configure cdr on a system. We are using nufone and I have set amaflags=billing on both of their sections in iax.conf. Incoming nufone calls show up in cdr with billing, but outgoing calls still show documentation. What do I need to change? We have a handful of SIP phones, 1 X100P outside line for local, and the rest is via nufone. I don't want inter-system calls to be

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

Hello, I have problem with interpretation of CDR entries. What happened? ------------- There was: 1. at 09:00:26 we received call from unknown caller (no callerid) to secretary with extension 17 2. secretary answered and after some conversation called to extension 18 to check if she could transfer customer call 3. at 09:02:55 extension 18 answered and call was forwarded 4. call was very long

Both of our production asterisk servers are dumping core when making writes to our cdr tables. Here is a backtrace of the problems we are having: #0 0x00447b1f in tdserror (tds_ctx=0x1, tds=0xb7938c90, msgno=20004, errnum=9) at util.c:347 347 if (tds_ctx && tds_ctx->err_handler) { (gdb) bt #0 0x00447b1f in tdserror (tds_ctx=0x1, tds=0xb7938c90, msgno=20004, errnum=9) at

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: [general] enable=yes unanswered = yes safeshutdown=yes [mysql] usegmtime=no

Hi all, I have a strange problem, regarding zap channels and cdr. I am using asterisk bristuffed version Asterisk 1.2.2-BRIstuffed-0.3.0-PRE-1i, Copyright (C) 1999 - 2006 Digium, Inc. and others. with two billion ISDN cards. I also installed asterisk addons, last stable version via cvs internal calls, or calls starting from internal sip or iax phone are recorded in the cdr all without any

I'm trying to use the MySQL CDR records. According to dialplan show, the line in the dialplan is: 11. Set(CDR(userfield)=${billing_code}) [pbx_ael] It looks like the value is being set when I watch the console during the call: -- Executing [s at restphone_event_loop:11] Set("SIP/icall-0075a2e0", "CDR(userfield)=boatmenu") in new stack But the record that's

On Sat, 25 Apr 2015 17:11:34 +0200 jg <webaccounts173 at jgoettgens.de> wrote: > > > Hi All > > > > I have dozens of these messages on CLI complaining about database > > connection and error writing CDR to disk. > > > > The curious thing is I can find them all inside the database. > > I "selected" them using uniqueid and manually

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, I have asterisk-server version of 1.8.11-cert7. When external enemy try to using it for calling, server write this string to log: 2014-03-13 09:56:04] VERBOSE[4754] pbx.c: -- Executing [9810972592309759 at from-sip-external:1] NoOp("SIP/external-ip-00065fd2", "Received incoming SIP connection from unknown peer to 9810972592309759") in new stack [2014-03-13

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