<p dir="ltr">Have you considered using something like Splunk to aggregate your log files and store a copy for later analysis? Even if you want it to be available to someone, say a remote customer, via a web panel, I believe you could even have Splunk put it into another database or make a view in Splunk's database.</p>
<p dir="ltr">I believe that might work. </p>
<div class="gmail_quote">On Nov 22, 2012 2:01 AM, "Dmitry" <<a href="mailto:mbike2000ru@yahoo.com">mbike2000ru@yahoo.com</a>> wrote:<br type="attribution"><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 style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif"><br></div></div></div><br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div>