<div class="gmail_quote"><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><p>No, i am standing absolutely at the beginning. I think the table structure should be googleable. But i haven 't found an automatism to dump the queuelog flatfile into a database table. Found a perl script but it doesn' t work for me. </p>
<p></p><blockquote type="cite">Am 03.12.2010 19:29 schrieb "Rodrigo Lang" <<a href="mailto:rodrigoferreiralang@gmail.com" target="_blank">rodrigoferreiralang@gmail.com</a>>:<div><div></div><div class="h5">
<br><br><div class="gmail_quote"><p><font color="#500050">2010/12/3 marcus rothe <<a href="mailto:synco16@googlemail.com" target="_blank">synco16@googlemail.com</a>></font></p>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<p>That sounds good. Rodrigo, allow me one question. I'm not very familar with databases but have the need to report out of the queuelog. Have you got a hint for me how to export the queueslog file into a database table? Thanks in advance, Regards Marcus</p>
</blockquote></div></div></div></blockquote></blockquote><div><br>Hi. <span lang="en"><span title="">Assuming you use Debian </span></span><span lang="en"><span title="">and have all your repositories ok</span></span><span lang="en"><span title="">, do:<br>
<br>Install mysql Database:<br></span></span>
<blockquote style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;" class="gmail_quote"><span lang="en"><span title="">aptitude -y install mysql-server libmysqlclient15-dev mysql-client</span></span><br>
<span lang="en"><span title=""></span></span></blockquote>
<span lang="en"><span title=""><br>Install php5 to run my script:<br></span></span>
<blockquote style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;" class="gmail_quote">
<span lang="en"><span title="">aptitude -y install php5 php5-cli php5-cgi php5-mysql</span></span><br><span lang="en"><span title=""></span></span></blockquote>
<span lang="en"><span title=""><br></span></span>To create the MySQL table I use this script [1], I pasted in the pastebin now. This script creates the CDR and Queue_log tables.<br>
<br>
<span lang="en"><span style="color: rgb(0, 0, 0);" title="">To convert your cvs queue_log for MySQL</span></span>,<span lang="en"><span title=""> use this script [2]. I did it now and have tested, it worked for me. </span><span title="">Make a backup of queue_log before use.</span></span><br>
<br>
[1] <a href="http://pastebin.com/2v5UPg3Q" target="_blank">http://pastebin.com/2v5UPg3Q</a><br>
[2] <a href="http://pastebin.com/TCJHkPXP" target="_blank">http://pastebin.com/TCJHkPXP</a><br>
<br>
<span lang="en"><span title="">Any questions just ask. </span><span title="">If you find an error in php script just let me know, then I stand corrected.</span></span><br>
<br><br><span id="result_box" class="" lang="en"><span style="" title="">And please answer in the list. </span><span style="" title="">So when someone needs the same procedure like you needed now, he can find in list history.</span></span><br>
<br><br>
<br>
Best regards,<br></div><div></div></div>-- <br>Rodrigo Lang<br><a href="http://openingyourmind.wordpress.com/" target="_blank">Opening your mind - Just another Open Source site</a><br><br>