MySQL Bugs: #42067: Some advisor rules have the advice untranslated

Bug #42067	Some advisor rules have the advice untranslated
Submitted:	12 Jan 2009 21:50	Modified:	5 Feb 2009 11:23
Reporter:	Marcos Palacios	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Localization	Severity:	S3 (Non-critical)
Version:	2.0.2.7131	OS:	Any
Assigned to:	Toru Sugihara	CPU Architecture:	Any

Description:
The Advice in the following advisor rules is not translated:

Advisor: Performance
Rule: Stored Procedures Found With SELECT * Syntax (v 1.1 *)
Rule: Excessive Disk Temporary Table Usage Detected (v 1.8 *)

Note: in the Schema Advisor, all but 2 of the rules have the same issue, example rule: Object Changes Detected (v 1.6 *)

Advisor: Security
Rule: Account Has Old Insecure Password Hash (v 1.1 *)

It is most likely that all new rules in version 2.0 do not have the Advice translated.

See examples in the attached files.

How to repeat:
- install the 2.0 monitor and the 2.0.2.7131 Platinum Advisor bundle
- change the user locale to japanese (JP)
- inspect the rules indicated above, looking at field "アドバイス"

Suggested fix:
- incorporate the JA translation resource with the Advice for new rules

Tested on service manager build 2.0.4.7138 and found that the rules still have the Advice untranslated.

Updated translation text was received and checked in just *after* the 2.0.4.7138 bundles were built, so they'll be in the next release.

Tested with advisor bundle 2.0.4.7140. Found some rules now have the translation BUT not ALL rules. The ones missing its translation are listed below (advisor and rule are indicated). Notice the 2 rules with additional issues.

Security: Account Has Old Insecure Password Hash   (v 1.1 *)
Security: Account Has Global Privileges   (v 1.4 *)
Security: Server Has Accounts Without A Password   (v 1.3 *)
Security: Account Has An Overly Broad Host Specifier   (v 1.4 *)
Security: User Has Rights To Database That Does Not Exist   (v 1.0 *)
Security: Account Has Strong MySQL Privileges   (v 1.3 *)
Security: Non-Authorized User Has DB, Table, Or Index Privileges On All Databases   (v 1.0 *)
Security: Non-Authorized User Has GRANT Privileges On All Databases   (v 1.0 *)

Heat Chart: RAM Usage Excessive   (v 1.7 *)

Heat Chart: MySQL Agent Memory Usage Excessive   (v 1.0 *)
Note: In this rule, the title, Problem Description, and Advice are untranslated.

Heat Chart: Temporary Tables To Disk Ratio Excessive   (v 1.91 *)
Note: In this rule, not only is the Advice untranslated but its English text is slightly different from the text in the Advice of the English rule. E.g., "If Query Analyzer is enabled, browse..." is NOT in the Japanese Advice.

Patch applied in versions => 2.0.4.7141.

Status updated by mistake. Setting back to 'verified'.

In 2.0: Pushed up to revision 262.

In 2.1: Pushed up to revision 252.

Patch installed in versions => 2.0.4.7142 and 2.1.0.1007

The 2 rules attached above are from advisor bundle 2.0.4.7142.

Awaiting new advisor build with latest translation corrections.

Pushed the latest translations to both the 2.0 and 2.1 codelines.

Verified fixed in advisor bundle 2.0.5.7144.

An entry was added to each of the 2.1.0, 2.0.5 and 2.0.4 changelogs:

A number of Advisor rules had advice text that had not been translated into Japanese. The Advisors that contained untranslated rules included Performance, Schema and Security.