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

[bruce bruce]

I have this in /etc/my.cnf:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
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*
What else am i missing?

Thanks
On Thu, Jul 8, 2010 at 1:20 AM, Steve Edwards <asterisk.org at sedwards.com>wrote:

> On Thu, 8 Jul 2010, bruce bruce wrote:
>
> > 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. Any other method of checking queries coming
> > through? Maybe FreePBX uses MySQL direct sockets and its different?
>
> Googling "mysql query log" brings up:
>
> http://dev.mysql.com/doc/refman/5.1/en/query-log.html
>
> as the first hit.
>
> --
> 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/20100708/83e02f55/attachment.htm