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 <[email protected]> To: Dmitry <[email protected]>; Asterisk Users Mailing List - Non-Commercial Discussion <[email protected]> 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 <[email protected]> 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
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
