Bug #53557 MEM installer does not give useful message when upgrading if db backend is down
Submitted: 11 May 2010 9:12 Modified: 24 May 2010 13:51
Reporter: Roel Van de Paar (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Installing Severity:S3 (Non-critical)
Version:2.2.0.1709 OS:Any
Assigned to: Andy Bang CPU Architecture:Any

[11 May 2010 9:12] Roel Van de Paar
Description:
Using mysqlmonitor-2.2.0.1709-linux-x86_64-update-installer.bin

Previous Installation [/opt/mysql/enterprise/monitor]:
Warning: DbExisting.ThrowError.MySQLConnection

How to repeat:
This happened after the db was stopped to do a backup, and forgot to restart it.

Suggested fix:
Instead please state: "Unable to reach the MySQL db server, please check it is running."
[12 May 2010 9:43] BitRock Merlin
Hi Andy,

This is an issue on our side, the "DbExisting.ThrowError.MySQLConnection" string should be completely removed when we fixed the #48253 issue (Service Manager Installer should show mysql error for remote installations). Following the approach commented in this issue, the installer will throw the MySQL connection error. We will send you the fix today.
[12 May 2010 16:58] BitRock Merlin
Patch sent to Keith.
[12 May 2010 18:50] Enterprise Tools JIRA Robot
Keith Russell writes: 
Patch checked in to installer repository.
[13 May 2010 23:54] Enterprise Tools JIRA Robot
Andy Bang writes: 
In build 2.2.1.1718.
[19 May 2010 18:34] Enterprise Tools JIRA Robot
Marcos Palacios writes: 
Tested successfully with Monitor upgrade installer build 2.2.1.1720 on Mac OS X 10.5.
[20 May 2010 0:10] Enterprise Tools JIRA Robot
Marcos Palacios writes: 
Also: Tested successfully with Monitor upgrade installer build 2.2.1.1720 on Fedora 6 (Linux x86). The message displayed is:

"Warning: 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.
Press [Enter] to continue :"
[20 May 2010 17:07] Enterprise Tools JIRA Robot
Marcos Palacios writes: 
Also: Tested successfully with Monitor upgrade installer build 2.2.1.1720 on Microsoft Windows XP. The message displayed is the same as in the previous 2 tests.
[24 May 2010 13:51] MC Brown
A note has been added to the 2.2.1 changelog;

        If the backend MySQL database being used for &merlin_server;                                                                                       
        is unavailable during an update installation, the installer                                                                                        
        may give a misleading message indicating the problem.