[asterisk-users] GURUs - How to monitor all MySQL actions on an Asterisk/FreePBX server?

[bruce bruce]

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 <asterisk.org at sedwards.com>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       sedwards at sedwards.com      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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100709/e87ecf04/attachment.htm