Re: [asterisk-users] GURUs - How to monitor all MySQL actions on an Asterisk/FreePBX server?
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@sedwards.comwrote: 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 etcand 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 sedwa...@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 -- _ -- 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
Re: [asterisk-users] GURUs - How to monitor all MySQL actions on an Asterisk/FreePBX server?
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 sedwa...@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
Re: [asterisk-users] GURUs - How to monitor all MySQL actions on an Asterisk/FreePBX server?
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@sedwards.comwrote: 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 sedwa...@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 -- _ -- 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
Re: [asterisk-users] GURUs - How to monitor all MySQL actions on an Asterisk/FreePBX server?
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 -- _ -- 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
Re: [asterisk-users] GURUs - How to monitor all MySQL actions on an Asterisk/FreePBX server?
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 cur...@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
Re: [asterisk-users] GURUs - How to monitor all MySQL actions on an Asterisk/FreePBX server?
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 etcand 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 zisha...@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 cur...@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 -- _ -- 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
Re: [asterisk-users] GURUs - How to monitor all MySQL actions on an Asterisk/FreePBX server?
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 etcand 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 sedwa...@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