[asterisk-users] Bounty- CDR Bug Fix

[Robert Broyles]

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 <robert at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090306/3a21639d/attachment.htm