MySQL Bugs: #38613: agent does not log incorrect mysql credentials at default log level

Bug #38613	agent does not log incorrect mysql credentials at default log level
Submitted:	6 Aug 2008 21:32	Modified:	11 Sep 2008 12:23
Reporter:	Sloan Childers	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Agent	Severity:	S3 (Non-critical)
Version:	2.0.0.7024	OS:	Any
Assigned to:	Jan Kneschke	CPU Architecture:	Any

Description:
the out of the box agent installation does not log if the managed mysqld instance credentials are incorrect

How to repeat:
install the agent and give an incorrect mysqld instance password for the managed instance

Suggested fix:
either turn up the default log level to include warnings and errors out of the box or change the credentials failure to an error

revno: 981
revision-id: jan@mysql.com-20080814220656-acmkl673837nqvvd
committer: jan@mysql.com
timestamp: Fri 2008-08-15 00:06:56 +0200
message:
  reduced the default log-level to "warning" to catch login failures to mysqld (fixes #38613)

Now we log:

2008-08-15 00:08:01: (warning) authentication failed on mysql-server 127.0.0.1: Access denied for user '...'@'192.168.2.106' (using password: YES) (1045)

I don't agree with upping the default level to warning (we have just explicitly disabled this as well). 

Setting this back to verified so that we can raise the specific connection errors to critical instead.

revno: 982
revision-id: jan@mysql.com-20080815122924-486gkotdu4jprk15
timestamp: Fri 2008-08-15 14:29:24 +0200
message:
  changed default log-level back to "critical" and raised the log-level of the connect-errors to critical instead

tested OK in 2.0.0.7049:
2008-09-11 14:19:31: (critical) C:\cygwin\home\mysqldev\bs\merlin\agent-2.0\src\mysql-proxy-0.7.0r1030\plugins\agent\agent_mysqld.c:581: agent connecting to mysql-server failed: mysql_real_connect(host = '127.0.0.1', port = 3351, socket = ''): Access denied for user 'agent'@'localhost' (using password: YES) (mysql-errno = 1045)