Morten <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ 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/[EMAIL PROTECTED]