<p>I have this in /etc/my.cnf: <br> <br>[mysqld]<br>datadir=/var/lib/mysql<br>socket=/var/lib/mysql/mysql.sock<br>user=mysql<br># Default to using old password format for compatibility with mysql 3.x<br># clients (those using the mysqlclient10 compatibility package).<br>
old_passwords=1</p><p>log-error=/var/log/mysqld.log<br> <br> <br> [mysqld_safe]<br>log-error=/var/log/mysqld.log<br>pid-file=/var/run/mysqld/mysqld.pid<br>log=/var/log/mysql_query.log</p><p><br></p><p><b>But it doesn't log anything to /var/log/mysql_query.log</b></p>
What else am i missing?<div><br></div><div>Thanks<br><div class="gmail_quote">On Thu, Jul 8, 2010 at 1:20 AM, Steve Edwards <span dir="ltr"><<a href="http://asterisk.org">asterisk.org</a>@<a href="http://sedwards.com">sedwards.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">On Thu, 8 Jul 2010, bruce bruce wrote:<br>
<br>
> Thanks for the input. Tailing the mysql log file doesn't show me<br>
> anything even though FreePBX does right to the asterisk table. I think<br>
> log is more for errors and unexpected shutdowns etc....and not queries.<br>
> In the my.cnf file there is no configuration to higher or lower the<br>
> verbose to show queries. Any other method of checking queries coming<br>
> through? Maybe FreePBX uses MySQL direct sockets and its different?<br>
<br>
</div>Googling "mysql query log" brings up:<br>
<br>
<a href="http://dev.mysql.com/doc/refman/5.1/en/query-log.html" target="_blank">http://dev.mysql.com/doc/refman/5.1/en/query-log.html</a><br>
<br>
as the first hit.<br>
<br>
--<br>
Thanks in advance,<br>
-------------------------------------------------------------------------<br>
Steve Edwards <a href="mailto:sedwards@sedwards.com">sedwards@sedwards.com</a> Voice: +1-760-468-3867 PST<br>
Newline Fax: +1-760-731-3000<br>
<font color="#888888"><br>
--<br>
</font><div><div></div><div class="h5">_____________________________________________________________________<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></div></blockquote></div><br></div>