<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content=text/html;charset=iso-8859-1>
<META content="MSHTML 6.00.6000.16825" name=GENERATOR></HEAD>
<BODY id=MailContainerBody
style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-TOP: 15px"
bgColor=#ffffff leftMargin=0 topMargin=0 CanvasTabStop="true"
name="Compose message area">
<DIV><FONT face=Arial size=2>Thanks for all the ideas, Joe. I've enabled logging
and warnings, but I'm not seeing any warnings get popped anywhere. Errors appear
to be showing up in syslog, which is great. But I can't get warnings to show up.
According to the MySQL docs, if the value for log-warning is >1, then
connection related info is written to the error log:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><EM>"The --log-warnings option or log_warnings
system variable can be used to control warning logging to the error log. The
default value is enabled (1). Warning logging can be disabled using a value of
0. If the value is greater than 1, aborted connections are written to the error
log."</EM></FONT></DIV>
<DIV><EM><FONT face=Arial size=2></FONT></EM> </DIV>
<DIV><FONT face=Arial size=2>So I've set the log level in the DB:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>mysql> show global variables like
'log_warn%';<BR>+---------------+-------+<BR>| Variable_name | Value
|<BR>+---------------+-------+<BR>| log_warnings |
1 |<BR>+---------------+-------+<BR>1 row in set (0.00
sec)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>mysql> set global log_warnings=2;<BR>Query OK, 0
rows affected (0.00 sec)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>mysql> show global variables like
'log_warn%';<BR>+---------------+-------+<BR>| Variable_name | Value
|<BR>+---------------+-------+<BR>| log_warnings |
2 |<BR>+---------------+-------+<BR>1 row in set (0.00
sec)<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Logging in with the u/p and host that result in the
"access denied" error message doesn't cause anything to show up in the syslog.
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>In addition, I've also just started mysqld from the
command line with logging and log-warnings enabled:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>$ sudo /usr/sbin/mysqld --log-warnings=2
--log-error</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>... and still, the access attempt doesn't show
up in any of the logs. (And I don't see any other warnings logged anywhere).
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm stumped. : )</DIV></FONT></BODY></HTML>