similar to: Problem with Queue_log and CDR.

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

Hi, I am running a call center based on Asterisk and building some statistics based on the queue_log file. I have some doubts about it that maybe you could help (actually, maybe these doubts are suggestions for enhancements!): 1st Scenario - Agent receives the call, and puts it on parking for somebody else to pick it up. Parking # 7000 (for attender transfer)

I went to run my queue_log parser so that I could send out a monthly report to one of my customers, and I noticed that every valid call complete action (COMPLETEAGENT, COMPLETECALLER) is followed by an ABANDON: Here is a complete-caller: 1123325015|1123325011.2|mainq|NONE|ENTERQUEUE||00110102102 1123325020|1123325011.2|mainq|Agent/21|CONNECT|5

Does anyone know why i would get this RINGNOANSWER events in queue_log when clearly the agent is busy and call-waiting is disabled. 1309550595|1309550570.399965|2253|Local/05 at from-internal/n|CONNECT|2|1309550593.399966|0 1309550632|1309550533.399961|2253|Local/11 at from-internal/n|COMPLETECALLER|1|74|1 1309550663|1309550640.399969|2253|NONE|ENTERQUEUE||zzzzzzzzzz

On Thu, Oct 20, 2016 at 4:50 AM, marek cervenka <cervajs2 at gmail.com> wrote: > i tested this > > # cat /etc/asterisk/extconfig.conf > [settings] > queue_log => sqlite3,cdrDb > > # cat /etc/asterisk/res_config_sqlite3.conf > [cdrDb] > dbfile = /var/lib/asterisk/realtime.sqlite3 > > sqlite3 /var/lib/asterisk/realtime.sqlite3 > > CREATE TABLE

I just installed 1.4.23.1 with the queue realtime logger backport. Here are my configs: musiconhold.conf [default] mode=files directory=/var/lib/asterisk/moh-native random=yes queues.conf [7703] wrapuptime=0 timeout=15 strategy=rrmemory retry=5 queue-youarenext=queue-youarenext queue-thereare=queue-thereare queue-thankyou=queue-thankyou queue-callswaiting=queue-callswaiting

Well, I'm writing yet another queue_log analyser program in PHP, and I have noticed the following entry in my queue_log file from today: 1104796626|1104796618.532|queue|NONE|ENTERQUEUE||no 1104796664|1104796618.532|queue|NONE|EXITWITHTIMEOUT|1 So, pretty sure that I didn't make someone wait 30 minutes in my queue. extensions.conf snippet: [remote-oldnum] exten => s,1,Answer exten =>

> > Sorry, of course cdr.conf not queues.conf. marcus > > Am 01.12.2010 19:16 schrieb "marcus rothe" <synco16 at googlemail.com>: > > > Hi Rodrigo, have you got enabled the appropriate line in queues. Conf? > Regards Marcus > > Thanks very much, I include the line "unansweredy=yes" in the cdr.conf and solve the problem. Thanks again! --

Hi all Using asterisk 16.25.0 (I know it's a bit old) I'm trying to parse the realtime queue_log and I realized that not every call has a ENTERQUEUE event. I see that if there's an internal call to an extension that has a dialplan forward to a queue (no call is placed to the extension before calling the queue), the ENTERQUEUE event is not generated in the queue_log For calls from

Hello everyone, This is is my first email to this group. I'm am writing a small php program to pull some info out of our Asterisk's queue_log. I'm having trouble figuring out what some of the parameters mean. Here's an example: 1118098465|1118098465.47|salesq|NONE|ENTERQUEUE||"Ray Balbin 25" <(716)250-3405> I found a doc that tells me about everything from

hi, is it possible log cel/queue_log to sqlite? via odbc? any experience? marek

Hello list, I don't know if anybody faced this issue, but I finally found a workaround. I am using an external program with an AMI connection to originate outbound calls to Local/ channels, and on the dialplan context I dial outside with the corresponding trunk according to the prefix of the dialed number. The problem here was CDR, more precisely the uniqueid. Reading these mail lists I

Hello! I'm trying to registers events of queues in /var/log/asterisk/queue_log and Mysql database .I have configured realtime queue_log on MySQL and works well, but /var/log/asterisk/queue_log file is empty, since you're not registering events of queues. Removing extconfig.conf configurations (queue_log => mysql,general), /var/log/asterisk/queue_log works well, events logs on

Hi, I'm trying to registers events of queues in /var/log/asterisk/queue_log and Mysql database .I have configured realtime queue_log on MySQL and works well, but /var/log/asterisk/queue_log file is empty, since you're not registering events of queues. Removing extconfig.conf configurations (queue_log => mysql,general), /var/log/asterisk/queue_log works well, events logs on

Hello! I'm trying to registers events of queues in /var/log/asterisk/queue_log and Mysql database .I have configured realtime queue_log on MySQL and works well, but /var/log/asterisk/queue_log file is empty, since you're not registering events of queues. Removing extconfig.conf configurations (queue_log => mysql,general), /var/log/asterisk/queue_log works well, events logs on

Hello list, I'm looking for a way to have the estimated hold time on a queue prior to joining it. someone suggested to me to Queue() first for 1 sec, read variable QUEUEHOLDTIME, validade it and Queue() again. But as we're using real time configuration that would mean a event ENTERQUEUE and a LEAVEQUEUE too much in MySQL's queue_log any suggestions?? Thanks in advance

Hi , I;ve Asterisk 1.6.0 with static agents (sip softphones with extns 100 & 101 ) in a queue..When a caller arrives in queue , it lands on first 100 , 100 then does a blind transfer to 101 .. so that the caller can converse with 101 .. strangely enough the queue_log shows : 1253814090|1253814090.12|55365|NONE|ENTERQUEUE||98221232123

Hi, I am trying to log queue_log to odbc (MS SQL) I have res_odbc.conf configured and modules.conf have preload => res_odbc.so preload => res_config_odbc.so extconfig.conf has queue_log => odbc,asterisk. When I start asterisk I get the following messages. The important one being: Realtime mapping for 'queue_log' found to engine 'odbc', but the engine is not available

I'm in search of useful ACD type statistics from the queues. Ie talk time, ratio's, dropped calls etc. The flat file queue_log is nice, but more useful would be the data in Postgres or Mysql. Unfortunately the queue module does not yet support ODBC DB logging (yet). In the meantime this quick and dirty hack gets the job done. Replace the flat file with a unix named pipe.

Hi, I am using RT engine to log queue_log to a mysql database. My extconfig is [settings] queue_log => mysql,asterisk16_production Logging to mysql is working fine. But I find that the queue_log file now only has QUEUESTART lines for eg: 1250519094|NONE|NONE|NONE|QUEUESTART| 1250519186|NONE|NONE|NONE|QUEUESTART| How can I have queue_log in both db as well as in a file? thanks and