Thanks for the input. Tailing the mysql log file doesn't show me anything even though FreePBX does right to the asterisk table. I think log is more for errors and unexpected shutdowns etc....and not queries. In the my.cnf file there is no configuration to higher or lower the verbose to show queries.<div>
<br></div><div>Any other method of checking queries coming through? Maybe FreePBX uses MySQL direct sockets and its different?<br><br></div><div>Thanks,</div><div>Bruce</div><div><br><div class="gmail_quote">On Wed, Jul 7, 2010 at 9:50 PM, Zeeshan Zakaria <span dir="ltr"><<a href="mailto:zishanov@gmail.com">zishanov@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><p>On a separate terminal, you can do something like 'tail -f /var/log/mysqld.log' or whatever the name of the mysql log file is.</p>
<p>Zeeshan A Zakaria</p>
<p>--<br>
<a href="http://www.ilovetovoip.com" target="_blank">www.ilovetovoip.com</a></p>
<p></p><blockquote type="cite"><div class="im">On 2010-07-07 9:43 PM, "Carlos Chavez" <<a href="mailto:cursor@telecomabmex.com" target="_blank">cursor@telecomabmex.com</a>> wrote:<br><br>
</div><div bgcolor="#ffffff">
<font size="2"><div class="im"><b>On Wed, 7 Jul 2010 19:19:28 -0400, bruce bruce wrote</b>
<br></div><p><font color="#500050">> Hi Guys, <br>> <br>> This is something related and yet un-related to Asterisk. I have a FreePBX/Asterisk...</font></p><div class="im">It is called the mysql query log. Mysql can create a log of all queries it receives. When using Freepbx Asterisk has no knowledge that Mysql is involved (only for CDR) so Asterisk does not send anything configuration related to Mysql.
<br>
<br>--
<br>
Carlos Chavez
<br>
Director de Tecnología
<br>
Telecomunicaciones Abiertas de México S.A. de C.V.
<br>
Tel: +52-55-91169161 Ext
2001
<br>
</div></font>
</div>
<br><div class="im">--<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></div></blockquote><p></p>
<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><br></div>