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.
On Thu, Jul 8, 2010 at 9:55 PM, Steve Edwards <[email protected]>wrote: > On Thu, 8 Jul 2010, bruce bruce wrote: > > > I have this in /etc/my.cnf: > > > > [mysqld] > > datadir=/var/lib/mysql > > socket=/var/lib/mysql/mysql.sock > > user=mysql > > old_passwords=1 > > log-error=/var/log/mysqld.log > > > > [mysqld_safe] > > log-error=/var/log/mysqld.log > > pid-file=/var/run/mysqld/mysqld.pid > > log=/var/log/mysql_query.log > > > > But it doesn't log anything to /var/log/mysql_query.log > > Move the "log" line to [mysqld] and restart MySQL. Personally, I'd create > the log file in /tmp/ so there are no permissions issues. > > Be aware that using the query log may expose confidential information if > you have other users and they have read access to the file. > > -- > Thanks in advance, > ------------------------------------------------------------------------- > Steve Edwards [email protected] Voice: +1-760-468-3867 PST > Newline Fax: +1-760-731-3000 > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
