CentOS - Sep 2009 - mysql query logging

Nothing I have done so far seems to work

# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
max_allowed_packet=2MB

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-query=/var/log/mysql-query.log

empty

and then I added to /etc/init.d/mysqld

get_mysql_option mysqld_safe log "/var/log/mysqld-query.log"
querylogfile="$result"
-and-
start(){
        touch "$querylogfile"
        chown mysql:mysql "$querylogfile"
        chmod 0640 "$querylogfile"

but nothing is logged.

Can someone toss me a bone here?

Craig


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

> # cat /etc/my.cnf
> [mysqld]
> datadir=/var/lib/mysql
> socket=/var/lib/mysql/mysql.sock
> user=mysql
> # Default to using old password format for compatibility with mysql 3.x
> # clients (those using the mysqlclient10 compatibility package).
> old_passwords=1
> max_allowed_packet=2MB
> 
> [mysqld_safe]
> log-error=/var/log/mysqld.log
> pid-file=/var/run/mysqld/mysqld.pid
> log-query=/var/log/mysql-query.log
> 
> empty
> 
> and then I added to /etc/init.d/mysqld
> 
> get_mysql_option mysqld_safe log "/var/log/mysqld-query.log"
> querylogfile="$result"
> -and-
> start(){
>         touch "$querylogfile"
>         chown mysql:mysql "$querylogfile"
>         chmod 0640 "$querylogfile"
> 
> but nothing is logged.
Try to put
log=/var/log/mysqld.log
into [mysqld] section of my.cnf

HTH
Sasha