List:General Discussion« Previous MessageNext Message »
From:Luc Foisy Date:February 21 2002 6:02pm
Subject:RE: Logging problem with --log, my.cnf etc.
View as plain text  
Does mysql have permission to write to that location?

-----Original Message-----
From: alastair [mailto:alastair@stripped]
Sent: Thursday, February 21, 2002 10:33 AM
To: mysql@stripped
Subject: Logging problem with --log, my.cnf etc.


Hello,

I am using MySQL 3.23.36 on Linux. This is a small gripe about a product
I am otherwise very happy with. I hope I have not missed the obvious or
been stupid some other way.

The problem - I want to log somewhere other than $DATADIR. Things are
set up like ;

| log                     | ON
| log_update              | OFF
| log_bin                 | OFF
| log_slave_updates       | OFF


I would have liked to use the my.cnf file to achieve this but it doesn't
appear to work i.e. a line like (in the [mysqld] section) ;

log=/var/log/mysql.log

has no effect. Looking at 'mysqld --help' output would show this is set
i.e.

logfile:     /var/log/mysql.log

but this file is not created. In fact, logging appears to stop.

So, I thought I would try adding the argument to my mysql init script -
args that are passed to 'safe_mysqld' i.e.

In /etc/init.d/mysql I added ;

--log=/var/log/mysql.log

to the command line for 'safe_mysqld'.

But this too had no effect - no log file created, no logging.

So ... I decided to look at 'safe_mysqld'. This is a much more complex
program but, seemed to me, to be potentially ignoring a '--log' line
i.e.

In the 'case' statement near the top ;

for arg do
  case "$arg" in
  # these get passed explicitly to mysqld
   --basedir=*) MY_BASEDIR_VERSION=`echo "$arg" | sed -e "s;--basedir=;;"`
;;
   --datadir=*) DATADIR=`echo "$arg" | sed -e "s;--datadir=;;"` ;;
   --pid-file=*) pid_file=`echo "$arg" | sed -e "s;--pid-file=;;"` ;;
   ...

There is no catch for '--log', and I assume the catchall default ;

  *)
   if test -n "$pick_args"
   ...

misses it as well (or it's ignored later ...).


So ... I (probably badly) hacked this script a bit and now I have
logging to /var/log/mysql.log.


I was looking in some 'changelogs' and found no mention of problems. I
also searched the list archives and found one other person with a
similar problem which was never resolved ;

http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msp:24135:lkonncgmkabnpiggbdio

So, would someone take a look at this and see if they can figure out
where the problem lies? I admit it might be me.

Cheers,



-- 
Alastair                   |                               |
alastair@stripped        |                               |
http://www.nucoda.com      |                               |
------------------------------------------------------------

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread100625@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-luc_foisy=technical-magic.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thread
Logging problem with --log, my.cnf etc.alastair21 Feb
RE: Logging problem with --log, my.cnf etc.Luc Foisy21 Feb
  • Re: Logging problem with --log, my.cnf etc.alastair21 Feb
RE: Logging problem with --log, my.cnf etc.Luc Foisy21 Feb
  • Re: Logging problem with --log, my.cnf etc.alastair21 Feb