Re: [asterisk-users] queue log realtime mysql

On 04-11-14 11:52, Jonas Kellens wrote: On 04-11-14 11:50, Ishfaq Malik wrote: On 4 November 2014 10:40, Jonas Kellens > wrote: Hello, I have 5 Asterisk servers all using mysql realtime to store queue log information. There is 1 out of 5 serv

Re: [asterisk-users] queue log realtime mysql

On 04-11-14 11:50, Ishfaq Malik wrote: On 4 November 2014 10:40, Jonas Kellens > wrote: Hello, I have 5 Asterisk servers all using mysql realtime to store queue log information. There is 1 out of 5 servers which stores the data in 4 columns :

Re: [asterisk-users] queue log realtime mysql

On 4 November 2014 10:40, Jonas Kellens wrote: > Hello, > > I have 5 Asterisk servers all using mysql realtime to store queue log > information. > > There is 1 out of 5 servers which stores the data in 4 columns : 'data1' > --> 'data 5'. > > All other servers store data in 1 column 'data' with t

[asterisk-users] queue log realtime mysql

Hello, I have 5 Asterisk servers all using mysql realtime to store queue log information. There is 1 out of 5 servers which stores the data in 4 columns : 'data1' --> 'data 5'. All other servers store data in 1 column 'data' with the data seperated by pipe. I see no difference in my conf

[asterisk-users] Queue Log data weirdness with Feature Transfers

Been chasing this down off and on for a while. There have been discussion in Jira and Mantis and Dev lists about this but they all seem to seriously pre-date 1.8.x (1.4 and 1.6.x). Calls delivered to a queue agents (Switchboard for example) that are subsequently transferred to an extension show t

Re: [asterisk-users] Queue Log in Mysql

Sorry, to not answer before! Thanks a lot, as sun as i am able i will test this setup! []'sf.rique On Fri, Jun 17, 2011 at 4:50 AM, Ishfaq Malik wrote: > On Thu, 2011-06-16 at 19:12 -0300, Henrique Fernandes wrote: > > It is possible to log queue in mysql without turning on realtime > > aster

Re: [asterisk-users] Queue Log in Mysql

On Thu, 2011-06-16 at 19:12 -0300, Henrique Fernandes wrote: > It is possible to log queue in mysql without turning on realtime > asterisk? > > Thanks! > > []'sf.rique > -- Hi Yes, you can pick and choose which things you want to use your DB by defining them in your extconfig.conf so, in extco

[asterisk-users] Queue Log in Mysql

It is possible to log queue in mysql without turning on realtime asterisk? Thanks! []'sf.rique -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar ev

Re: [asterisk-users] Queue log in MySQL DB

Give it a shot and check! :) Yes you will have your Queue log records in table. [SATISH] On Wed, Jun 8, 2011 at 12:46 PM, Jonas Kellens wrote: > On 06/08/2011 09:10 AM, Satish Barot wrote: > >> >> Set queue_log = no in logger.conf. By default it is set to 'yes'. >> >> [SATISH] >> > > Will there t

Re: [asterisk-users] Queue log in MySQL DB

On 06/08/2011 09:10 AM, Satish Barot wrote: Set queue_log = no in logger.conf. By default it is set to 'yes'. [SATISH] Will there then still be queue logging at all ? Kind regards, Jonas. -- _ -- Bandwidth and Colocation P

Re: [asterisk-users] Queue log in MySQL DB

Set queue_log = no in logger.conf. By default it is set to 'yes'. [SATISH] On Wed, Jun 8, 2011 at 12:30 PM, Jonas Kellens wrote: > Hello list, > > I have configured extconfig.conf to save queue log into my MySQL-DB. > > I notice however that there is still logging too in > /var/log/asterisk/que

[asterisk-users] Queue log in MySQL DB

Hello list, I have configured extconfig.conf to save queue log into my MySQL-DB. I notice however that there is still logging too in /var/log/asterisk/queue_log. How can I disable queue logging into text files ? Kind regards, Jonas. -- __

[asterisk-users] Queue log on MySQL realtime

Hi all, I'm experimenting with the MySQL realtime logging of queue log, using backports for 1.4. When I configure the logging of queue log as realtime, the previous way to save it onto the plain text file stops working. Is there a way to make it work both ways, just like the CDR works, where y

Re: [asterisk-users] queue log parser

On Mon, Jan 5, 2009 at 10:12 PM, David fire wrote: > > if you don't know any parser maybe you can send me a link or a pdf whit info > on how to parse the log. > ...check queuelog.txt under the doc/ directory on the asterisk source distribution (apparently, under 1.6 it is queuelog.tex... no m

[asterisk-users] queue log parser

hi i am integrating asterisk whit an open source CRM or maybe i am integrating an open source crm whit asterisk any way the CRM is vtiger, (www.vtiger.com) i need an opensource queue log parser to put inside the crm agent statics. i need any parser i can port it to php or to java if you don't know

Re: [asterisk-users] queue log in mysql

2009/1/4 Tilghman Lesher > On Sunday 04 January 2009 14:42:50 David fire wrote: > > i cant find any how to store the queue log in mysql instead of file. > > any one can send me a link or a pdf? in voip info i found how to setup a > > realtime queue but not to store the log in mysql. > > The realt

Re: [asterisk-users] queue log in mysql

thanks 2009/1/4 Robert Broyles > With regards to storing queue_log data in mysql, it depends on the > Asterisk service your running. > > 1.6.x check out the following: > http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL > > 1.2.x OR 1.4.x check out the following patch/solution: > >

Re: [asterisk-users] queue log in mysql

On Sunday 04 January 2009 14:42:50 David fire wrote: > i cant find any how to store the queue log in mysql instead of file. > any one can send me a link or a pdf? in voip info i found how to setup a > realtime queue but not to store the log in mysql. The realtime family (in extconfig.conf) is call

Re: [asterisk-users] queue log in mysql

With regards to storing queue_log data in mysql, it depends on the Asterisk service your running. 1.6.x check out the following: http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL 1.2.x OR 1.4.x check out the following patch/solution: http://www.plack.net/index.php/2007/01/07/asteri

[asterisk-users] queue log in mysql

hi i cant find any how to store the queue log in mysql instead of file. any one can send me a link or a pdf? in voip info i found how to setup a realtime queue but not to store the log in mysql. end beyond the storing where i can find a good queue log parser? it must be opensource because is to in

Re: [asterisk-users] queue log vs. cdr

--- Atis Lezdins <[EMAIL PROTECTED]> wrote: > Hmm, didn't knew that queue_log can be written into > MySQL.. Asterisk 1.6 beta has that through realtime. But I'm using a custom import script in earlier Asterisk versions. > Is callid in queue_log the same uniqueid? yes. > You can do > somethin

Re: [asterisk-users] queue log vs. cdr

Yes it is. The reason you get more entries in queue_log is that there are several queue_log events per call - most commonly you get an "ENTERQUEUE", "CONNECT" and "COMPLETECALLER/AGENT" for each call. Vieri wrote: > Hi, > > Surely, I must be overlooking something. If I run the > following SQL que

Re: [asterisk-users] queue log vs. cdr

On 3/13/08, Vieri <[EMAIL PROTECTED]> wrote: > 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 2008030800

[asterisk-users] queue log vs. 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 2008030800 and 20080313145900 group by callid; 357 rows in set (0.01

[asterisk-users] Queue log analyser / report

Hi, ANyone knows of a fully GPL/OpenSource queue report/analyser project ? Asterisk-stat uses Postgres and that's a no go for us + it's not open QueueMetrics is not Open at all. Any suggestion welcome. Andre ___ --Bandwidth and Colocation provid

[Asterisk-Users] Queue - Log if caller disconnects

I am having the same problem with my IAX clients. I posted some issues that are causing my remote IAX agents to be disconnected due to errors in setting up the IAX stream. I have found that calls will abandon when a dynamic agent is logged into a down phone, the agent obviously can’t logout

RE: [Asterisk-Users] Queue - Log if caller disconnects

AM To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] Queue - Log if caller disconnects Hello List, i'm wondering if there is any way to get a AGI executed if a caller disconnects while he is INSIDE the queue application. If so, i would like to log the call as missed. Hope someon

[Asterisk-Users] Queue - Log if caller disconnects

Hello List, i'm wondering if there is any way to get a AGI executed if a caller disconnects while he is INSIDE the queue application. If so, i would like to log the call as missed. Hope someone can help. Greetings, Michael ___ --Bandwidth and Colo

Re: [Asterisk-Users] Queue Log

> > 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> > > 1st fie

[Asterisk-Users] Queue Log Analyser Build into IPS

IPSwitchBoard Version 0.123 - 17 July 2005 * Queue Analysis has been added to IPSwitchBoard. In order to properly manage ACD queues, it is important to be able to keep track of details of call setups and teardowns in much greater detail than traditional call detail records provide. In order to sup

[Asterisk-Users] Queue Log Analyser Build into IPS 0.123

IPSwitchBoard Version 0.123 - 17 July 2005 * Queue Analysis has been added to IPSwitchBoard. In order to properly manage ACD queues, it is important to be able to keep track of details of call setups and teardowns in much greater detail than traditional call detail records provide. In order to

Re: [Asterisk-Users] Queue Log

I'm looking for a similar script. Care to share? -bill On 7-Jun-05, at 10:43 AM, Hugo Begglo wrote: 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

Re: [Asterisk-Users] Queue Log

Thank Brian ! That gave us the last piece we needed. Regards, Hugo Brian Roy wrote: On 6/7/05, Johann <[EMAIL PROTECTED]> wrote: Hugo, 1118098465|1118098465.47|salesq|NONE|ENTERQUEUE||"Ray Balbin 25" <(716)250-3405> 2nd column is not really sure...maybe the duration?

Re: [Asterisk-Users] Queue Log

On 6/7/05, Johann <[EMAIL PROTECTED]> wrote: > Hugo, > > > 1118098465|1118098465.47|salesq|NONE|ENTERQUEUE||"Ray Balbin 25" > > <(716)250-3405> > 2nd column is not really sure...maybe the duration? Asterisk UniqueID of the call. -Brian ___ Asterisk-U

Re: [Asterisk-Users] Queue Log

Thanks Johann. - that helps out . Johann wrote: Hugo, 1118098465|1118098465.47|salesq|NONE|ENTERQUEUE||"Ray Balbin 25" <(716)250-3405> 1st column is unixtime stamp for the current date 2nd column is not really sure...maybe the duration? 3rd column is the queue name 4th column is their age

Re: [Asterisk-Users] Queue Log

Hugo, 1118098465|1118098465.47|salesq|NONE|ENTERQUEUE||"Ray Balbin 25" <(716)250-3405> 1st column is unixtime stamp for the current date 2nd column is not really sure...maybe the duration? 3rd column is the queue name 4th column is their agent number (or NONE if there isn't one) --johann

[Asterisk-Users] Queue Log

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"

Re: [Asterisk-Users] queue log analyser?

y 2005 11:08 To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] queue log analyser? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ben Merrills wrote: | There's a few (open source/free) ones in development. I myself am | developing one of them. | | Ben |

Re: [Asterisk-Users] queue log analyser?

I've not released the source yet, I asked last week on the mailing list for people to send me over some example queue_logs, because so far I've only been able to test the software against my own. I have however made a lot of changes to it since last I posted about it. How is the progress on thi

Re: [Asterisk-Users] queue log analyser?

D] On Behalf Of João Amaro Sent: 20 January 2005 11:08 To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] queue log analyser? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ben Merrills wrote: | There's a few (open source/free) ones in development. I my

RE: [Asterisk-Users] queue log analyser?

: Re: [Asterisk-Users] queue log analyser? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ben Merrills wrote: | There's a few (open source/free) ones in development. I myself am | developing one of them. | | Ben | Hi. Why not join all the project in just one ? Actually which queue log analyzers

Re: [Asterisk-Users] queue log analyser?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ben Merrills wrote: | There's a few (open source/free) ones in development. I myself am | developing one of them. | | Ben | Hi. Why not join all the project in just one ? Actually which queue log analyzers projects are beeing developed ? Check the mail

Re: [Asterisk-Users] queue log analyser?

2005 15:33 To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] queue log analyser? hi I really want a good queue_log analyser, but I don't want to waste > EUR 1000 for something like that, so I thought starting a small project for it. I started off in php just creating a basic p

RE: [Asterisk-Users] queue log analyser?

There's a few (open source/free) ones in development. I myself am developing one of them. Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roy Sigurd Karlsbakk Sent: 19 January 2005 15:33 To: asterisk-users@lists.digium.com Subject: [Asterisk-

[Asterisk-Users] queue log analyser?

hi I really want a good queue_log analyser, but I don't want to waste > EUR 1000 for something like that, so I thought starting a small project for it. I started off in php just creating a basic parser for the log, and I'll go on extending it. See http://karlsbakk.net/asterisk/scripts/queue

Re: [Asterisk-Users] Queue Log Parser

n Merrills" <[EMAIL PROTECTED]> > To: "Asterisk Users Mailing List - Non-Commercial Discussion" > > Sent: Thursday, January 13, 2005 10:03 AM > Subject: [Asterisk-Users] Queue Log Parser > > I don't know if anyone noticed my post a few months ago on the > a

Re: [Asterisk-Users] Queue Log Parser

Sent: Thursday, January 13, 2005 10:03 AM Subject: [Asterisk-Users] Queue Log Parser I don't know if anyone noticed my post a few months ago on the asterisk-user mailing list, but I've been writing a queue log parser. I was wondering if anyone had any queue_logs (the bigger the better

[Asterisk-Users] Queue Log Parser

I don't know if anyone noticed my post a few months ago on the asterisk-user mailing list, but I've been writing a queue log parser. I was wondering if anyone had any queue_logs (the bigger the better) that I would use as sample data? I would of course be willing to post the stats up for the people