Actually that's a great question. "service mysqld restart" was done twice. I also checked the privilege of the file to be assigned to mysqld user as is the mysql.log file in the directory /var/log/ and which does it's reporting properly. thanks,Bruce
> Subject: Re: [on-asterisk] MySQL querey log to trace FreePBX inputs > From: [email protected] > Date: Thu, 8 Jul 2010 22:52:20 -0400 > To: [email protected] > > Dumb question, but did you restart mysqld after making the log change ? > > > --- > > Andre Courchesne - Consultant > > http://www.net-forces.com > > MSN: [email protected] > > Skype: VoipForces > > > > L'information contenue dans le présent document est la propriété de Andre > Courchesne. Et est divulguée en toute confidentialité. Cette information ne > doit pas être utilisée, divulguée à d'autres personnes ou reproduite sans le > consentement écrit explicite de Andre Courchesne. > > The information contained in this document is confidential and property of > Andre Courchesne. It shall not be used, disclosed to others or reproduced > without the express written consent of Andre Courchesne. > > > > > > On 2010-07-08, at 8:15 PM, Bruce N wrote: > > > > > Hi Everyone, > > > > > > > > But when I make changes to freePBX extensions the file mysql_query.log > > doesn't have anything logged. I want to see exactly which table and field > > is effected when a change is made in FreePBX. > > > > > > > > What am I missing? > > > > > > > > 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 > > > > > > > > [mysqld_safe] > > log-error=/var/log/mysqld.log > > pid-file=/var/run/mysqld/mysqld.pid > > log=/var/log/mysql_query.log > > > > > > > > > > > > > > > > Thanks, > > > > Bruce > > > > _________________________________________________________________ > > Learn more ways to connect with your buddies now > > http://go.microsoft.com/?linkid=9734388 > _________________________________________________________________ Learn more ways to connect with your buddies now http://go.microsoft.com/?linkid=9734388
