[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Enabling more detailed logging
From:       Victoria Reznichenko <victoria.reznichenko () ensita ! net>
Date:       2003-10-31 13:01:57
[Download RAW message or body]

Morten <lists@kikobu.com> wrote:
> 
> Hi, I would like some more extensive logging output, so
> I can see what sessions begin etc. In other words, enable
> general logging. I'm running RedHat 9 w. mysql-3.23.58
> 
> I've tried to add the log=[file] to my.cnf:
> 
> [mysqld]
> datadir=/var/lib/mysql
> socket=/var/lib/mysql/mysql.sock
> 
> [mysql.server]
> user=mysql
> basedir=/var/lib
> 
> [safe_mysqld]
> err-log=/var/log/mysql/mysqld-err.log
> pid-file=/var/run/mysqld/mysqld.pid
> log=/var/log/mysqld/mysqld.log
> log-long-format
> 
> But the mysqld.log does not come. The mysqld-err.log does.

You put error log to the /var/log/mysql directory, but general log file to the \
/var/log/mysqld directory. Is this a typo?

> The DB gets started via the init script that comes with
> the RPM, ie:
> 
> /usr/bin/safe_mysqld  --defaults-file=/etc/my.cnf
> 
> What am I missing? How do I enable more detailed logging?


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@ensita.net
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]