Alrite guys. I added log=/tmp/logfile in /etc/my.cnf and removed "log = FILE, TABLE". Now it is logging each query. Thanks for the support.
Sachin On Mon, Oct 6, 2008 at 3:13 PM, Sachin Gaikwad <[EMAIL PROTECTED]> wrote: > More on this: > > I set following in /etc/my.cnf: > > log = FILE, TABLE > > after this I am not able to start my mysqld, it fails with timeout > error message "Timeout error occurred trying to start MySQL Daemon." > > Thanks, > Sachin > > On Mon, Oct 6, 2008 at 3:01 PM, Sachin Gaikwad <[EMAIL PROTECTED]> wrote: >> Thanks a bunch for the quick reply. >> I will surely write a C program to read this logfile of general queries. >> But before that I am not able to find this logfile for general queries. >> >> I started my server like this: >> >> $/etc/init.d/mysqld start --log=logfile --log-output=/tmp >> >> Meaning log file will be in = /tmp/logfile >> >> $mysql >> mysql> select * from whowhatwhen; >> xxxxxx >> xxxxxxx >> xxxx >> xxxxx >> mysql> >> >> So this query should exist in logfile. But I am not able to see this >> logfile in /tmp itself. What am I missing ? >> >> Thanks, >> Sachin >> >> On Mon, Oct 6, 2008 at 2:29 PM, Weston, Craig (OFT) >> <[EMAIL PROTECTED]> wrote: >>> This problem is Chapter 16.6 of The MYSQL Cookbook, (second edition) >>> that has made my(sql) life much easier. You might want to look around >>> at http://artfulsoftware.com/ which has lots of examples and a great >>> e-book resource. >>> >>> Both of these are fantastic resources for me, and they are probably my >>> most used books in my mysql library. >>> >>> Good luck, >>> >>> Craig >>> >>> >>> -------------------------------------------------------- >>> This e-mail, including any attachments, may be confidential, privileged or >>> otherwise legally protected. It is intended only for the addressee. If you >>> received this e-mail in error or from someone who was not authorized to >>> send it to you, do not disseminate, copy or otherwise use this e-mail or >>> its attachments. Please notify the sender immediately by reply e-mail and >>> delete the e-mail from your system. >>> >>> >>> -----Original Message----- >>> >>> From: Sachin Gaikwad [mailto:[EMAIL PROTECTED] >>> Sent: Monday, October 06, 2008 2:07 PM >>> To: mysql@lists.mysql.com >>> Subject: Access Rights ? >>> >>> Hi all, >>> >>> I am newbie using MySQL. I want to log each client request to database >>> server. I thought when server checks access rights of user(client) >>> will be good place to "log" all "access/read/update" requests. >>> >>> If somebody knows where exactly this is done in source code, I will >>> get a real kick start. Right now I am browsing through the source code >>> through cscope to find out this. >>> >>> Any help in this regard is appreciated. >>> >>> Thanks, >>> Sachin >>> >>> -- >>> MySQL General Mailing List >>> For list archives: http://lists.mysql.com/mysql >>> To unsubscribe: >>> http://lists.mysql.com/[EMAIL PROTECTED] >>> >>> >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]