It was't a permission issue though. I did compare with another server, that
had the same thing working.
[root@server1 mysql]# ls -lh /var/log/mysqld.log
-rw-r--r-- 1 mysql root 60M Jun 16 18:40 /var/log/mysqld.log
[root@server1 mysql]# grep err-log /etc/my.cnf
On this server now, I have commented err-log and use log_error , which
happily writes to the log file
root@server [~]# grep err-log /etc/my.cnf
root@server [~]# ls -lh /var/log/mysqld.log
-rw-r--r-- 1 mysql root 728 Jun 16 17:51 /var/log/mysqld.log
err-log was under safe_mysqld, so neither any fault in its position in
On Wed, Jun 17, 2009 at 12:21 AM, lists-mysql <
> 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.feedback@stripped>
> > To: mysql@stripped
> > 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
> > root@server[~]# ll /var/log/mysqld.log
> > -rw-r--r-- 1 mysql root 0 Nov 24 2008 /var/log/mysqld.log
> > root@server[~]#
> > Please advise what i can look for to fix this issue.
> ------------ End Original Message ------------