MySQL Bugs: #36431: syslog logging does not work in mysql proxy (use-log-syslog not working)

Bug #36431	syslog logging does not work in mysql proxy (use-log-syslog not working)
Submitted:	30 Apr 2008 17:40	Modified:	25 Sep 14:31
Reporter:	Sheeri Cabral (Candidate Quality Contributor)
Status:	Patch queued
Category:	Proxy: Install/Config	Severity:	S3 (Non-critical)
Version:	0.7.0	OS:	Linux
Assigned to:	Kay Roepke	Target Version:
Tags:	log, syslog, qc

Description:
Trying to use the 
use-log-syslog option does not work.  I have one client that reported an error when he
used the "use-log-syslog" option, the proxy did not start because it did not recognize
the "use-log-syslog" option.  That might have been 0.6.0 or 0.6.1.  In researching the
issue I came across this forum post by another person which has his ideas:

http://forums.mysql.com/read.php?146,207048,207220#msg-207220
"As I also reported in a previous post here, the --log-use-syslog option does not log to
anywhere. I suspect a problem with the "#ifdef HAVE_SYSLOG_H" conditional compilation
pragmas in the source code. HAVE_SYSLOG_H is apparently not defined anywhere. I didn't
try to define it in order to see if syslog starts to log something."

(the "also reported in a previous post" seems to be
http://forums.mysql.com/read.php?146,206429,206532#msg-206532 which does not give more
information).

How to repeat:
Install proxy.  Try the use-log-syslog option.  If proxy does start, see that no logs are
getting put into syslog.

Suggested fix:
Have the option actually work.....or throw a warning on startup at least, that the
function will be available in a future version.

Sheeri,

Thank you for your bug report. This issue has been committed to our source repository of
that product and will be incorporated into the next release.

Best,
Kay

will there be a fix in the next release, or just a warning that will tell people
use-log-syslog doesn't work?

Syslog support is supposed to work in the next release.

Thank you for the answer....I have one question, you said on 30 April:

"This issue has been committed to our source repository of that product and will be
incorporated into the next release."

But the status is marked as "Patch Pending"....

Which is correct?

Heidi Bergh-Hoff writes: 
Does this bug have a fix queued? Does it need further testing?

Diego Medina writes: 
Verified fixed on 0.8.0 (on Linux)

Still trying to found out where the logs end up on Mac OS X 10.5

Kay Roepke writes: 
There was a off-by-one bug in selecting the syslog log level. The patch is pending, as we
wait for the 0.8.0 build, it will most likely be fixed in 0.8.1.

Kay Roepke writes: 
bugfix is available at lp:~kay-roepke/mysql-proxy/bug-36431