<div>Hi Dmitry,<br></div><div>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 :)</div>
<div>l.</div><div class="gmail_extra"><br><br><div class="gmail_quote">2012/11/22 Dmitry <span dir="ltr"><<a href="mailto:mbike2000ru@yahoo.com" target="_blank">mbike2000ru@yahoo.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div style="font-size:12pt;font-family:times new roman,new york,times,serif"><div>Hi, </div><div><br></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif">
I use asterisk 1.8.</div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif"> Currently I use a perl daemon to parse queue_log into MySQL. It works reliably.</div>
<div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif"><br></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif">
But I know that there is a method
(<a href="http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL" target="_blank">http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL</a> and <a href="http://work.mikeboylan.com/asterisk-queuelog-to-mysql" target="_blank">http://work.mikeboylan.com/asterisk-queuelog-to-mysql</a>) to write to MySQL directly with app_mysql which has a DEPRECATED status.</div>
<div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif"><br></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif">
My question is:</div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif">What is the best/preffered approach to put queue_log into MySQL in asterisk 1.8 and up?</div>
<div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif">1) To use external daemons to parse /var/log/queue_log?</div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif">
2) To use the deprecated app_mysql? the status does not guarantee that this application will be in the future</div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif">
3) To use odbc to access mysql? but I could not find a procedure for it. And I doubt it is possible.</div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif">
<br></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif">BR,</div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif">
Dmitry Pavlenko</div></div></div></blockquote></div><br><br clear="all"><br>-- <br><div>Loway - home of QueueMetrics - <a href="http://queuemetrics.com" target="_blank">http://queuemetrics.com</a><br></div><div>Test-drive WombatDialer beta @ <a href="http://wombatdialer.com" target="_blank">http://wombatdialer.com</a>
</div><br>
</div>