Bug #52839 Cosmetic fixup needed on existing server selection + make more user friendly
Submitted: 14 Apr 2010 20:34 Modified: 2 Jun 2010 8:55
Reporter: Roel Van de Paar Email Updates:
Status: Closed Impact on me:
Category:MySQL Enterprise Monitor: Installing Severity:S2 (Serious)
Version:2.2 OS:Any
Assigned to: BitRock Merlin CPU Architecture:Any

[14 Apr 2010 20:34] Roel Van de Paar
During the installation process of MEM2.2 one is confronted with a selection box to either use the bundled MySQL database or to use an existing MySQL database.

When "use an existing MySQL database" is selected, the user can then enter credentials for this existing MySQL database. When the user does not exist yet on such a database, the following warning is displayed:

Error running C:\Program Files\MySQL\Enterprise\Monitor/mysql/bin/mysql_connection.bat  : ERROR 1045 (28000): Access denied for user 'service_manager'@'localhost' (using password: YES)

Besides the fact that this warning can be fixed up cosmetically (more clearer message (also ref below), mixture of "\" and "/", "Error" and "Warning" shown at the same time, place second part - the actual error at least 2CR's down etc.), this could be made more user friendly:

How about a box that says: "I was unable to login using the credentials provided, likely this is because the 'service_manager'@'somehost' account does not exist yet. Please provide root (or another authoritative user) credentials so that I can create this userID on this server.

How to repeat:
Install MEM2.2 on Windows

Suggested fix:
As per the above.
[14 Apr 2010 20:35] Roel Van de Paar
As per the above

Attachment: Mem2.2 Choosing an existing server.png (image/png, text), 24.74 KiB.

[15 Apr 2010 1:19] Roel Van de Paar
Also, there are no instructions in the 2.2 manual afaics that list how to create the service_manager user account on an existing server (what GRANT's are needed etc.)
[15 Apr 2010 2:59] Roel Van de Paar
Verified by un-install > re-install on same Windows 7 machine.
[12 May 2010 23:35] Enterprise Tools JIRA Robot
Andy Bang writes: 

Rather than the cryptic error message show in the Description of this bug report, please show the following message if you can't connect to the remote instance:

"Error: Unable to login to the existing MySQL server to verify its ability to serve as an Enterprise Monitor data repository.  Please be sure the username, password, hostname, and port are all correct and try again."
[13 May 2010 14:21] BitRock Merlin
Patch sent to Keith. Notice that this issue reverts the #48253 issue (Service Manager Installer should show mysql error for remote installations).
[13 May 2010 23:56] Enterprise Tools JIRA Robot
Andy Bang writes: 
In build
[28 May 2010 15:56] Enterprise Tools JIRA Robot
Carsten Segieth writes: 
OK in, where we accept the implementation of the message box as a "Warning" (I checked with Andy)..
[2 Jun 2010 8:55] MC Brown
A note has been added to the 2.2.1 changelog. 

In addition, I've updated the installation instructions to note the requirements for the repo user.