[debian-mysql] Bug#745071: Bug#745071: mysql-server: MySQL not logging to syslog as intended

[Arto Jantunen]

Demetris Demetriou <mitsosgtir at gmail.com> writes:

> Package: mysql-server
> Severity: important
>
> Hello,
> MySQL on Debian Wheezy does not log to syslog as intended:
>
> /etc/mysql/my.cnf Line 75:
> # Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
>
> /etc/mysql/conf.d/mysqld_safe_syslog.conf contents
> [mysqld_safe]
> syslog
>
> According to this, mysql should be logging to syslog, but no entries are being
> registered. To correct this, I had to change the following:
>
> /etc/init.d/mysql Lines 108-109:
>             # Start MySQL!
>             /usr/bin/mysqld_safe > /dev/null 2>&1 &
>
> Change to:
>             # Start MySQL!
>             /usr/bin/mysqld_safe --syslog > /dev/null 2>&1 &
>
>
> Issue a sudo service mysql restart and syslog entries start firing up, using
> "mysqld:", "mysqld_safe:" and "/etc/mysql/debian-start[ProcessID]:" tags.
>
> This is a serious bug since it completely disables the MySQL logging
> facilities. Neither syslog, nor /var/log/mysql.log nor /var/log/mysql.err nor
> any /var/log/mysql/* log contain anything related to MySQL. Checking backlogs
> shows that this went on for a long long time, so I cannot be sure how long the
> bug was left in the package. To make myself clear, ALL error logs are
> completely empty (in the case of syslog, NO entries for mysql exist). Checking
> a couple of servers shows that it is indeed across architectures as well, with
> this behaviour showing up on x86_64 and ARM as well.

I don't have --syslog set, and Mysql logs through syslog just fine. The
log entries end up in /var/log/daemon.log, as set on line 29 of the init
script, "ERR_LOGGER="logger -p daemon.err -t /etc/init.d/mysql -i"". Are
you certain you are not getting log output there?

-- 
Arto Jantunen