Logger

[jholder]

Howdy,
I tried to run logmysql.server start with grant tables.

[root@tusd-exch01 zcs]# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
060330 12:58:50 mysqld ended


So, I thought I'd take a look at the mysqld.log

060330 12:58:49 mysqld started
060330 12:58:50 [ERROR] /opt/zimbra/logger/mysql/bin/mysqld: unknown variable 'defaults-file=/opt/zimbra/conf/my.logger.cnf'

060330 12:58:50 mysqld ended

So I decided to look at the my.logger file.

[mysqld]

basedir      = /opt/zimbra/logger/mysql
datadir      = /opt/zimbra/logger/db/data
socket       = /opt/zimbra/logger/db/mysql.sock
pid-file     = /opt/zimbra/logger/db/mysql.pid
bind-address = localhost
port         = 7307

skip-external-locking

log-slow-queries = /opt/zimbra/log/logger_myslow.log
long-query-time  = 1
log-long-format
log-queries-not-using-indexes
log-bin

thread_cache      = 10
max_connections   = 10

# We do a lot of writes, query cache turns out to be not useful.
query_cache_type = 0

[mysqld_safe]

err-log = /opt/zimbra/log/logger_mysqld.log

Does this log look correct?

thx

[KevinH]

Did you try to start it as root?

[jholder]

The way noted above is as root. Should I try as Zimbra?

[jholder]

Can someone post their my.logger.cnf file?

thanks

[phoenix]

What you've posted above is what I have in my.logger.cnf