<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Great backports! :-)<br>
<br>
This should really be merged into 1.4.<br>
<pre class="moz-signature" cols="72">--
Regards,
Robert Broyles</pre>
<br>
<br>
Atis Lezdins wrote:
<blockquote
cite="mid:670f60170903060314q10fee428q793c4acb2df7e105@mail.gmail.com"
type="cite">
<pre wrap="">Well, i can share mine backports of queue_log into mysql for 1.4.
Basically you need two backports (that's why there are numerous
files). Realtime store/destroy allows Asterisk Realtime engine to use
INSERT's on MySQL. It needs two patches - one for Asterisk, one for
Asterisk-addons (mysql part). And then there's itself queue_log
realtime patch.
I'm using it on Asterisk 1.4.19 for some half year already, so it
could be considered stable. I just tested and it does apply cleanly to
Asterisk 1.4.23 (and was previously working with latest Addons-1.4.7).
Also an advantage of this is - that it's already merged into 1.6.0, so
upgrade shouldn't be a problem.
So, some brief instructions:
1) apply <a class="moz-txt-link-freetext" href="http://ftp.iq-labs.net/realtime_store_destroy-1.4/asterisk_realtime_store_destroy_1.4.19.patch">http://ftp.iq-labs.net/realtime_store_destroy-1.4/asterisk_realtime_store_destroy_1.4.19.patch</a>
to Asterisk
2) apply <a class="moz-txt-link-freetext" href="http://ftp.iq-labs.net/queue_log-1.4/asterisk_queue_log_realtime_1.4.19.patch">http://ftp.iq-labs.net/queue_log-1.4/asterisk_queue_log_realtime_1.4.19.patch</a>
to Asterisk
"make && make install"
3) "make dist-clean" on Asterisk-addons
4) Apply <a class="moz-txt-link-freetext" href="http://ftp.iq-labs.net/realtime_store_destroy-1.4/asterisk_addons_realtime_store_destroy_1.4.6.patch">http://ftp.iq-labs.net/realtime_store_destroy-1.4/asterisk_addons_realtime_store_destroy_1.4.6.patch</a>
to Asterisk-addons
"make && make install"
* ensure that res_mysql.conf has working connection:
[general]
dbhost = localhost
dbname = asterisk
dbuser = asterisk
dbpass = pass
dbport = 3306
dbsock = /tmp/mysql.sock
* add to extconfig.conf:
queue_log => mysql,asteriskcdrdb,queue_log
* create mysql table:
CREATE TABLE queue_log (
id int(10) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT
time int(10) unsigned,
callid varchar(20),
queuename int(10) unsigned,
agent varchar(40),
event enum('ABANDON','ADDMEMBER','AGENTCALLBACKLOGIN','AGENTCALLBACKLOGOFF','AGENTDUMP','AGENTLOGIN','AGENTLOGOFF','COMPLETEAGENT','COMPLETECALLER','CONFIGRELOAD','CONNECT','EDITMEMBER','ENTERQUEUE','EXITEMPTY','EXITWITHKEY','EXITWITHTIMEOUT','PAUSEALL','PAUSE','QUEUESTART','REMOVEMEMBER','RINGNOANSWER','SYSCOMPAT','TRANSFER','TRANSFERATTENDED','UNPAUSE','UNPAUSEALL'),
data varchar(255)
)
Regards,
Atis
On Thu, Mar 5, 2009 at 8:54 PM, Robert Broyles <a class="moz-txt-link-rfc2396E" href="mailto:robert@poornam.com"><robert@poornam.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">The patch I was referring to is:
<a class="moz-txt-link-freetext" href="http://www.plack.net/index.php/2007/01/07/asterisk_modification_for_queue_logging">http://www.plack.net/index.php/2007/01/07/asterisk_modification_for_queue_logging</a>
It doesn't work for the current SVN 1.4
--
Regards,
Robert Broyles
Anthony Francis wrote:
Yeah, I need to make a new patch for 1.6 to go to it myself. I wrote a
patch way back for 1.2 that allowed all queue log events to sh,ow up in
the AMI, just haven't had time to make a new version for 1.6.
Maybe this time I can get the patch in trunk and it will always be there.
Robert Broyles wrote:
Problem is, without going to 1.6, I can't get the queue log or events
posted to MySQL in realtime.
There used to be a patch out there for queue_log, but it doesn't work
with versions 1.4.21 or higher.
--
Regards,
Robert Broyles
Anthony Francis wrote:
Robert Broyles wrote:
I saw some of the heat about the $20 bounty earlier. So I don't want to
put a low bounty out.
Quote me a bounty, and I'll see if I can get it approved by management. :-)
I'm in need of getting this bug fixed. Bug has all of the details, but
basically 1.4.22 broke it all.
I've waited as long as I can - hoping the bug would 'resolve itself' -
but now I'm putting a bounty out on it.
<a class="moz-txt-link-freetext" href="http://bugs.digium.com/view.php?id=13691">http://bugs.digium.com/view.php?id=13691</a>
I would not recommend using CDR's for queue data, instead I use the
queue events, or at a minimum the queue log.
------------------------------------------------------------------------
_______________________________________________
-- Bandwidth and Colocation Provided by <a class="moz-txt-link-freetext" href="http://www.api-digital.com">http://www.api-digital.com</a> --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
<a class="moz-txt-link-freetext" href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a>
_______________________________________________
-- Bandwidth and Colocation Provided by <a class="moz-txt-link-freetext" href="http://www.api-digital.com">http://www.api-digital.com</a> --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
<a class="moz-txt-link-freetext" href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a>
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
</body>
</html>