[asterisk-users] Queue_log into MySQL - best practices

[Dmitry]

Lenz, Thank you for your answer

Here is what I think:


1) If I use an external Perl/Python daemon to parse queue_log and put it into the MYSQL database - I must also monitor this script (for example,to restart it in case of failure) although this external daemon is rather easy to maintain and it means an "independence" from the DEPRECATED app_mysql.

2)If I use the app_mysql module- although it is very convenient (asterisk developers maintain it) but as it has a DEPRECATED status - I am afraid using this module (I am not sure about its future).
3) Still know nothing about odbc support for queue_log

So I chose 1).



________________________________
 From: Lenz Emilitri <lenz.loway at gmail.com>
To: Dmitry <mbike2000ru at yahoo.com>; Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users at lists.digium.com> 
Sent: Thursday, November 22, 2012 3:36 PM
Subject: Re: [asterisk-users] Queue_log into MySQL - best practices
 

Hi Dmitry,

we usually advise against writing queue_log events straight to a database, as it is marginally more likely that the DB has issues that a simple flat file. And when data is lost it's lost forever. Still everybody seems to love writing data straight to the DB :)
l.



2012/11/22 Dmitry <mbike2000ru at yahoo.com>

Hi, 
>
>
>I use asterisk 1.8.
> Currently I use a perl daemon to parse queue_log into MySQL. It works reliably.
>
>
>But I know that there is a method (http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL and http://work.mikeboylan.com/asterisk-queuelog-to-mysql) to write to MySQL directly with app_mysql which has a DEPRECATED status.
>
>
>My question is:
>What is the best/preffered approach to put queue_log into MySQL in asterisk 1.8 and up?
>1) To use external daemons to parse /var/log/queue_log?
>2) To use the deprecated app_mysql? the status does not guarantee that this application will be in the future
>3) To use odbc to access mysql? but I could not find a procedure for it. And I doubt it is possible.
>
>
>BR,
>Dmitry Pavlenko


-- 

Loway - home of QueueMetrics - http://queuemetrics.com

Test-drive WombatDialer beta @ http://wombatdialer.com 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20121125/c8fc854f/attachment.htm>