List:General Discussion« Previous MessageNext Message »
From:Madan Thapa Date:June 16 2009 11:51pm
Subject:Re: mysqld not writing to err-log
View as plain text  
Hi Rick,

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
err-log=/var/log/mysqld.log
[root@server1 mysql]#





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
#err-log=/var/log/mysqld.log
root@server [~]#
root@server [~]# ls -lh /var/log/mysqld.log
-rw-r--r--  1 mysql root 728 Jun 16 17:51 /var/log/mysqld.log
root@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-mysql@stripped> 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.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 ------------
>
>
>

Thread
mysqld not writing to err-logMadan Thapa16 Jun
  • Re: mysqld not writing to err-logWalter Heck - OlinData.com16 Jun
Re: mysqld not writing to err-logMadan Thapa17 Jun
Re: mysqld not writing to err-logMadan Thapa17 Jun