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

[bruce bruce]

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?

Thanks,
Bruce

On Wed, Jul 7, 2010 at 9:50 PM, Zeeshan Zakaria <zishanov at gmail.com> wrote:

> On a separate terminal, you can do something like 'tail -f
> /var/log/mysqld.log' or whatever the name of the mysql log file is.
>
> Zeeshan A Zakaria
>
> --
> www.ilovetovoip.com
>
> On 2010-07-07 9:43 PM, "Carlos Chavez" <cursor at telecomabmex.com> wrote:
>
>  *On Wed, 7 Jul 2010 19:19:28 -0400, bruce bruce wrote*
>
> > Hi Guys,
> >
> > This is something related and yet un-related to Asterisk. I have a
> FreePBX/Asterisk...
> It is called the mysql query log.  Mysql can create a log of all queries it
> receives.  When using Freepbx Asterisk has no knowledge that Mysql is
> involved (only for CDR) so Asterisk does not send anything configuration
> related to Mysql.
>
> --
> Carlos Chavez
> Director de Tecnología
> Telecomunicaciones Abiertas de México S.A. de C.V.
> Tel: +52-55-91169161 Ext 2001
>
> --
> _____________________________________________________________________
> -- 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100708/bb59724f/attachment.htm