MySQL Bugs: #40058: add an advisor rule to check privileges of the agent account

Bug #40058	add an advisor rule to check privileges of the agent account
Submitted:	15 Oct 2008 15:33	Modified:	16 Oct 2009 16:09
Reporter:	Axel Schwenke	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Enterprise Monitor: Advisors/Rules	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Currently the agent is not very helpful to find out about MySQL privileges missing from the agent account. I.e. if the SUPER privilege is missing, then SHOW ENGINE INNODB STATUS will silently fail and there will be no InnoDB graphs.

See also bug #40050.

How to repeat:
Revoke the SUPER privilege from the agent account and see how there appears no message in the agent log.

Suggested fix:
Add an advisor rule to check if the agent account has all the necessary privileges.