MySQL Bugs: #52839: Cosmetic fixup needed on existing server selection + make more user friendly

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:	None
Category:	MySQL Enterprise Monitor: Installing	Severity:	S2 (Serious)
Version:	2.2	OS:	Any
Assigned to:	BitRock Merlin	CPU Architecture:	Any

Description:
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:

---------------------------
Warning
---------------------------
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)
---------------------------
OK   
---------------------------

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.

As per the above

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

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.)

Verified by un-install > re-install on same Windows 7 machine.

Andy Bang writes: 
BitRock,

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."

Patch sent to Keith. Notice that this issue reverts the #48253 issue (Service Manager Installer should show mysql error for remote installations).

Andy Bang writes: 
In build 2.2.1.1718.

Carsten Segieth writes: 
OK in 2.2.1.1721, where we accept the implementation of the message box as a "Warning" (I checked with Andy)..

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.