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 <[email protected]>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 [email protected] 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
