Putting it in /tmp/ just did the job. Sorry, I posted my older my.cnf file. I actaully did have the log under mysqld rather than the safe version but it didn't work. I will put this to privilage problems.<br><br><div class="gmail_quote">
On Thu, Jul 8, 2010 at 9:55 PM, 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>
</div><div class="im">> 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>
</div><div class="im">> old_passwords=1<br>
> log-error=/var/log/mysqld.log<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<br>
><br>
> But it doesn't log anything to /var/log/mysql_query.log<br>
<br>
</div>Move the "log" line to [mysqld] and restart MySQL. Personally, I'd create<br>
the log file in /tmp/ so there are no permissions issues.<br>
<br>
Be aware that using the query log may expose confidential information if<br>
you have other users and they have read access to the file.<br>
<font color="#888888"><br>
--<br>
</font><div><div></div><div class="h5">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>
<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>
</div></div></blockquote></div><br>