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

Hi Guys,

This is something related and yet un-related to Asterisk. I have a
FreePBX/Asterisk server running and I want to trace everything that FreePBX
does to MySQL. Is there a verbose CLI to MySQL that I can pull up on
terminal and make configuration change to FreePBX and see it in real-time on
the terminal as to what is added to which MySQL table and where?

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20100707/de29fd5b/attachment.htm

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 server running and I want to trace everything that FreePBX does
to MySQL. Is there a verbose CLI to MySQL that I can pull up on terminal and
make configuration change to FreePBX and see it in real-time on the terminal as
to what is added to which MySQL table and where?
> 
> Thanks
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
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20100707/08402997/attachment.htm

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