[asterisk-users] Bounty- CDR Bug Fix

[Atis Lezdins]

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
>



-- 
Atis Lezdins,
VoIP Project Manager / Developer,
IQ Labs Inc,
atis at iq-labs.net
Skype: atis.lezdins
Cell Phone: +371 28806004
Cell Phone: +1 800 7300689
Work phone: +1 800 7502835