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 15:40	Modified:	20 Jan 2010 15:54
Reporter:	Sheeri Cabral (Candidate Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Proxy: Install/Config	Severity:	S3 (Non-critical)
Version:	0.7.0	OS:	Linux
Assigned to:	Kay Roepke	CPU Architecture:	Any
Tags:	log, qc, syslog

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

Keith Russell writes: 
Patch available in build.

Diego Medina writes: 
Verified fixed on 0.8

A note has been added to the 0.8.0 changelog.