similar to: concurrent call tracking

I've tried every combination I could find on the net and so far there is no joy The thing is I can do this update from the command line: Maybe some new eyes might find the answer? exten => update,1,MYSQL(Connect connid localhost root password dax) exten => update,n,MYSQL(QUERY resultid ${connid} UPDATE\ caller\ SET\

Hi List, When a user is on a call, sometimes they hear digits dialing as if the other end is randomly pressing the keypad with their face...but they aren't. It has happened while I've been on calls also, very odd and annoying. Has anyone come across this on Asterisk before? TIA, Skyler

A friend and I have recently added the ability to announce the callers position in the call queue every x seconds.. or even just inject an anouncement every x seconds. All setup in queues.conf and can be setup per queue. My next project is to add the ability to announce the callers estimated wait time. I want some feedback to see whats the best method to calculate that? What do you want just

Hi List, Has anyone heard of an ATA device that supports TCP & TLS? Not much comes up in searching, thought to check here for some device suggestions. TIA, Skyler

hi, we want to extract the information when the most callers are entering our phone system based on an interval of 15 minutes. this is quite simple (although not perfect) with select calldate, count(*) as anzahl from cdr where calldate > '2019-10-12' group by unix_timestamp(calldate) DIV 900 having ; Unfortunately we have lots of callers who calls multiple times when they are

Hi all, Anyone know how to make asterisk properly reply to options keep-alive? Or just force a 200 OK somehow? I recently took over a server and they have ~80 pap2 devices that send nat keep-alive and * always replies with 481 No subscription. It's more of an annoyance, I know but I like to keep my pcap's clean. S. -------------- next part -------------- An HTML

Hello. I am trying to write an interactive function that asks the user for a vector of observations. Unfortunately, if a user inputs a vector, R treats the vector name as a string instead of a variable. Here is an example: vector.input<-function(){ k<-as.integer(readline("Input number of vectors: ")) obs<-as.integer(readline("Input number of observations per vector

> Is anybody on this list actually using iax2 for > anything mission-critical? Yes. 2K inbound / outbound calls a day to 30 remote locations, aggregated to 2 PRI's tied together with IAX2. All with IP address specified rather than hostname. All with Asterisk 1.0.9. All with 99.9% completion rate, and it would be 99.999% if we weren't using consumer grade DOCSIS cable modems in the

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

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 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'm stuck and need some help. I have installed the Asterisk CDR Analyser Version 2.0.1. It mostly works except for the CDR Report. I get the following error even though it lists the CDR details. Database error: Invalid SQL: SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE UNIX_TIMESTAMP(calldate) >=

Dears, I need to save some information on userfield when calls end in Asterisk13, but I have two error cases: 1. With endbeforehexten=no in cdr.conf, I have a registry in cdr, but userfield is not set. 2. With endbeforehexten=yes, I have two lines in cdr, one with duration, src e dst correct, and a second line with userfield setting and dst h. I am using cdr_odbc.conf, with Asterisk11.14.0 it

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,all for a long time, i cant understand the difference between ${CDR(calldate)} and ${CDR(start)} , ${CDR(answer)} i know ${CDR(start)} mean when a call is start. and ${CDR(answer)} means when a call was pick up. but what's ${CDR(calldate)} mean? Could you help me ? Thansk a lot! -- Thanks for your supporting, have a nice day. Sucan

Hi, Surely, I must be overlooking something. If I run the following SQL queries I don't get the same number of rows. Is this coherent? mysql> select * from queue_log where queuename = '4010' and FROM_UNIXTIME(time) between 20080308000000 and 20080313145900 group by callid; 357 rows in set (0.01 sec) mysql> select * from cdr where dst = 4010 and calldate between 20080308000000

This is really a query about MySQL which I am trying to use to set up a database which I will then access with RODBC. I have my data in a .csv file, and some of the fields are date/time fields. I tried to create a table using mysql with the definition of the date/time field given by CallDate DATETIME, but I got an error saying that the first row has 28/07/2006 0:00 in that field. What I

Dear Tariq; About elastix.org, this can be use with Asterisk or it is coming as a complete IP Telephony, Call Center, IVR and Reporting? Because, I do not need to install another IP Telephony on the server which already has asterisk which is an IP Telephony, this will cause a problem in the service (for example, when listening for SIP port of 5060).

Guys. Ive seen on my asterisk messages log that asterisk has shutdown itself about 12 times in 5 days... The logs show nothing but: [Jun 28 09:40:02] WARNING[3172]: Unicall/4 event Drop call [Jun 28 09:40:02] WARNING[3172]: Unicall/4 event Release call [Jun 28 09:40:02] VERBOSE[3172]: [Jun 28 09:40:02] -- Unicall/4 released [Jun 28 09:40:02] VERBOSE[3084]: [Jun 28 09:40:02] Asterisk cleanly

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