Great backports! :-) This should really be merged into 1.4.
-- Regards, Robert Broyles Atis Lezdins wrote:
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 http://ftp.iq-labs.net/realtime_store_destroy-1.4/asterisk_realtime_store_destroy_1.4.19.patch to Asterisk 2) apply http://ftp.iq-labs.net/queue_log-1.4/asterisk_queue_log_realtime_1.4.19.patch to Asterisk "make && make install" 3) "make dist-clean" on Asterisk-addons 4) Apply http://ftp.iq-labs.net/realtime_store_destroy-1.4/asterisk_addons_realtime_store_destroy_1.4.6.patch 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 <rob...@poornam.com> wrote:The patch I was referring to is: http://www.plack.net/index.php/2007/01/07/asterisk_modification_for_queue_logging 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. http://bugs.digium.com/view.php?id=13691 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 http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
DISCLAIMER : This email and any files transmitted with it are property of Poornam Info Vision Pvt. Ltd. This email contains confidential information intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender immediately and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Warning: Although the company has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments.
_______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
