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 > -- Atis Lezdins, VoIP Project Manager / Developer, IQ Labs Inc, a...@iq-labs.net Skype: atis.lezdins Cell Phone: +371 28806004 Cell Phone: +1 800 7300689 Work phone: +1 800 7502835 _______________________________________________ -- 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