Hi Rick, It was't a permission issue though. I did compare with another server, that had the same thing working.
[r...@server1 mysql]# ls -lh /var/log/mysqld.log -rw-r--r-- 1 mysql root 60M Jun 16 18:40 /var/log/mysqld.log [r...@server1 mysql]# grep err-log /etc/my.cnf err-log=/var/log/mysqld.log [r...@server1 mysql]# On this server now, I have commented err-log and use log_error , which happily writes to the log file r...@server [~]# grep err-log /etc/my.cnf #err-log=/var/log/mysqld.log r...@server [~]# r...@server [~]# ls -lh /var/log/mysqld.log -rw-r--r-- 1 mysql root 728 Jun 16 17:51 /var/log/mysqld.log r...@server [~]# err-log was under safe_mysqld, so neither any fault in its position in my.cnf ( http://mysqldatabaseadministration.blogspot.com/2006/07/err-log-or-log-error.html) [safe_mysqld] #err-log=/var/log/mysqld.log ================================ On Wed, Jun 17, 2009 at 12:21 AM, lists-mysql < replies-lists-b3z1-my...@listmail.innovate.net> wrote: > This might be an issue of permissions (/var/log is controlled by > root). So, you might try "touch"-ing /var/log/mysqld.log and setting > ownership to mysql.mysql. Then [re-]start mysqld and see if the log > gets written to. > > Related, the logging entry in my my.cnf is "log-error=" not your > "err-log=". I haven't looked in the documentation to see if your > version should work, but mine does, so you might want to try it. > > - Rick > > ------------ Original Message ------------ > > Date: Tuesday, June 16, 2009 11:18:25 PM +0530 > > From: Madan Thapa <madan.feedb...@gmail.com> > > To: mysql@lists.mysql.com > > Subject: mysqld not writing to err-log > > > > Hi, > > > > mysqld is not writing to err-log and i do not see any log > > generated upon mysql service restart. > > > > > > In my.cnf > > ========= > > [safe_mysqld] > > err-log=/var/log/mysqld.log > > pid-file=/var/lib/mysql/mysql.pid > > open_files_limit=16384 > > > > > > > > r...@server[~]# ll /var/log/mysqld.log > > -rw-r--r-- 1 mysql root 0 Nov 24 2008 /var/log/mysqld.log > > r...@server[~]# > > > > > > > > Please advise what i can look for to fix this issue. > > ------------ End Original Message ------------ > > >
