Re: [asterisk-users] queue_log in MySQL database
On 01/13/2011 2:07 PM, Tom Rymes wrote: That will require additions to your login/logout context that write entries to the log each and every time a user logs in/out. You can then report on that data. While there's a thread going on about this topic, and while I've written the above comment, can anyone confirm that the "QueueLog" command will indeed write entries out to the realtime queue_log, not just the file based log? Many thanks, Tom -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] queue_log in MySQL database
On 01/13/2011 11:25 AM, Danny Nicholas wrote: *From:*asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] *On Behalf Of *Jonas Kellens *Sent:* Thursday, January 13, 2011 10:19 AM *To:* Asterisk Users Mailing List - Non-Commercial Discussion *Subject:* [asterisk-users] queue_log in MySQL database Hello, can /var/log/messages/queue_log be saved in a MySQL database ?? So it would be easier to work with... Kind regards, Jonas. I’d say that depends on your release. Check this link http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL Specifically, you're looking for the part I added that mentions the changes to how extconfig.conf entries are referenced. You need to use the context name, not the database name. You'll also want to note the information about changes made to the data structures for Asterisk 1.8. As far as your request about tracking the time a call is in the queue, that's information that is directly available in the queue_log. One important question that you haven't asked is "How do I track how long each user was logged in to the queue, even if they received no calls?". That will require additions to your login/logout context that write entries to the log each and every time a user logs in/out. You can then report on that data. You might want to reconsider reinventing the wheel on this one. Have you checked into Queuemetrics at http://www.queuemetrics.com ? Tom -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] queue_log in MySQL database
On 13 January 2011 16:28, Jonas Kellens wrote: > > > I actually found this : > http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL > > But a second question : > > how can I know how long a caller stayed inside the queue untill it was > answered by a member ?? > > The queue_log table contains exactly that information - Along with a few other events, it indicates when a caller joined a queue, and when an agent gets given the call. Take the difference between the 2 times and you have the number that you need. Cheers, Steve -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] queue_log in MySQL database
-Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Jonas Kellens Sent: Thursday, January 13, 2011 10:29 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] queue_log in MySQL database On 01/13/2011 05:25 PM, James Lamanna wrote: > Hi Jonas, > > On Thu, Jan 13, 2011 at 8:19 AM, Jonas Kellens wrote: > >> Hello, >> >> can /var/log/messages/queue_log be saved in a MySQL database ?? >> >> So it would be easier to work with... >> > I don't think Asterisk has this support built-in...maybe 1.8 does? > However, what I do to manage queue_log is I have a small daemon that I > have written in Python that watches the queue_log file, parses each > incoming line, and stores it in a MySQL table. > > -- James > > -- I actually found this : http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL But a second question : how can I know how long a caller stayed inside the queue untill it was answered by a member ?? Kind regards, Jonas. Just a WAG, but I'm guessing that you would cross-reference to the CDR for this information. -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] queue_log in MySQL database
On 01/13/2011 05:25 PM, James Lamanna wrote: Hi Jonas, On Thu, Jan 13, 2011 at 8:19 AM, Jonas Kellens wrote: Hello, can /var/log/messages/queue_log be saved in a MySQL database ?? So it would be easier to work with... I don't think Asterisk has this support built-in...maybe 1.8 does? However, what I do to manage queue_log is I have a small daemon that I have written in Python that watches the queue_log file, parses each incoming line, and stores it in a MySQL table. -- James -- I actually found this : http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL But a second question : how can I know how long a caller stayed inside the queue untill it was answered by a member ?? Kind regards, Jonas. -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] queue_log in MySQL database
_ From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Jonas Kellens Sent: Thursday, January 13, 2011 10:19 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [asterisk-users] queue_log in MySQL database Hello, can /var/log/messages/queue_log be saved in a MySQL database ?? So it would be easier to work with... Kind regards, Jonas. I'd say that depends on your release. Check this link http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] queue_log in MySQL database
Hi Jonas, On Thu, Jan 13, 2011 at 8:19 AM, Jonas Kellens wrote: > Hello, > > can /var/log/messages/queue_log be saved in a MySQL database ?? > > So it would be easier to work with... I don't think Asterisk has this support built-in...maybe 1.8 does? However, what I do to manage queue_log is I have a small daemon that I have written in Python that watches the queue_log file, parses each incoming line, and stores it in a MySQL table. -- James -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users