similar to: CDR Disposition for call queue's

Hi all! I have installed a quite old Asterisk 1.6.2.0-rc2 with latest DAHDI on Ubuntu 9.10 from repository. It is working now but mysql logging is very strange. All calls have logged in mysql cdr table, which is fine, but disposition is 'NO ANSWER' even if I had talked on phone. Duration is correct but billsec is zero. Any idea why? Unfortunately I cannot upgrade to newer version because

Hello to everybody, I have a problem with the disposition filed that asterisk write in mysql table. What I notice is that for every outbound calls (for example to a mobile phone) I see in disposition field the string "ANSWERED" when I reject the call and also when I really answer the call, while in the variable DIALSTAUS I have the correct status of the call (BUSY, CHANUNAVAIL,

Is there any way to have more specific disposition codes in the CDR? Currently there are only 3 values: ANSWER, NO ANSWER, BUSY. In this way, when i call a cell phone that is switched off i get "NO ANSWER", while i would like to be able to log that the call is not answered because "The customer you have dialed is unavailable at the moment". The same for "non

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, Asterisk version : 1.2.7.1 stable version We try agent.conf setting of createlink=yes We always can not see this link value to be filled in MySQL's table filed : userfield But we can see the record file has been created correctly. In debug mode, no userfiled shown in SQL command, May 17 18:10:51 DEBUG[2889] pbx.c: Function result is '"unknown" <2001>' May

Hi All, I know this was a bug a while back. I am using Asterisk 1.6.0.8 and logging cdr's to MySQL. All records show FAILED for the disposition regardless of what really happens. Please let me know if there is something more I could post to help figure this out. Thanks -------------- next part -------------- An HTML attachment was scrubbed... URL:

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 |

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 noticed a problem this morning with our cdr logging. We have a cron job that places a call file into the spool directory having asterisk call itself to check to make sure its still handling incoming calls correctly, then queries the CDR database in mysql and makes sure that appropriate records exist. I can confirm that the call is happening correctly, but I'm missing records in the

Hello, I have a TDM400P with 2x2 configuration of FXOs and FXSs. I set a test extension of '444' to dial out a specific zap trunk and call a local #. First time I call out to '444' everything works fine. If I hang up the call, and within 10 seconds dial the same number again, I get a fast busy. Seems it isn't letting go of the trunk or something, and I don't have a

Hi all, Have been experimenting with agents and queues instead of placing calls direct to a user's phone extension, but I've run into problems with calls to both the agent and the extension which creates a zombie and double records calls abandoned etc. We're using a unique queue for each agent (only a handful of users) to try and get some agent/queue information to see what the

Hello I just settup a realtime mysql table for sip_peers. All peers (friends) is autenticateing but when i want to initiate a call between them i got the following error. Someone have some ideea? Thank you. ---<Cut Here>--- pbx*CLI>console dial 1014 == Console is full duplex -- Executing [1014@default:1] Dial("OSS/dsp", "SIP/1014|40|t") in new stack

> 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

According to http://www.voip-info.org/wiki-Asterisk+variable+DIALSTATUS when a caller hangs up before the callee has time to pick the phone up then DIALSTATUS should be CANCEL. And it is. However, the disposition field in the CDR table is "NO ANSWER". So if I analyze the CDR data I won't be able to discriminate calls cancelled by the caller and calls not answered by the callee

It looks like when you use odbc for CDR storage, rather than getting a Dispositon string like ANSWERED, CONGESTION etc, you'll get an integer (1,2,4,8). Does anyone know where I can find what strings (ANSWERED etc) these integers map to? Doug.

I have an application where I need to send outbound prerecorded messages. The Asterisk "call file" process works fine if I am sending the call via SIP or IAX, but not via ZAP over a PRI channel. The destination device (my cell phone) never rings. The only unusual thing I see is on the fifth line of the "full" log, below, "channel.c: Don't know what to do with

Hi, I'm currently running CVS-HEAD 2005-09-03 I do plan to upgrade to the newest version, but need to do some testing with it first. In the mean time... does anyone know what these messages below are about? I've never seen it before, but when it happened it locked Asterisk up pretty good. Feb 10 10:16:51 DEBUG[14917] chan_zap.c: Echo cancellation already on Feb 10 10:16:57

So I'm noticing from the docs/ on Asterisk Addons 1.4.10 that the database structure for cdr_mysql is: CREATE TABLE cdr ( calldate datetime NOT NULL default '0000-00-00 00:00:00', clid varchar(80) NOT NULL default '', src varchar(80) NOT NULL default '', dst varchar(80) NOT NULL default '', dcontext varchar(80) NOT NULL default '', channel

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