MySQL Bugs: #45339: SSL does not work if you upgrade the monitor from 1.3 to 2.1

Bug #45339	SSL does not work if you upgrade the monitor from 1.3 to 2.1
Submitted:	4 Jun 2009 18:27	Modified:	25 Jun 2009 14:13
Reporter:	Marcos Palacios	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Installing	Severity:	S3 (Non-critical)
Version:	2.1.0.1053	OS:	Any
Assigned to:	BitRock Merlin	CPU Architecture:	Any

Description:
When a 1.3 monitor is upgraded directly to 2.1, and having SSL requested in the upgrade dialog, SSL still does not work in the upgraded Monitor.

This feature was working in bld 2.1.0.1049 (and bld 2.1.0.1050 did not allow upgrades due to http://bugs.mysql.com/bug.php?id=45198).

How to repeat:
- install a 1.3 service manager
- upgrade it to ver. 2.1
  - make sure the 'Is SSL support required?' check box is checked
- observe that SSL does not work for agents to connect to the dashboard

The root cause is that the server.xml in the upgraded installation is missing:
 protocol="HTTP/1.1" SSLEnabled="true"

specifically, the line in server.xml...

is:
    <Connector port="18443" maxThreads="150" minSpareThreads="25" maxSpareThreads="75" enableLookups="false" disableUploadTimeout="true" acceptCount="100" scheme="https" secure="true" clientAuth="false" sslProtocol="TLS" keystoreFile="conf/myKeystore" keystorePass="mysqlnetwork"/>

should be:
    <Connector port="18443" protocol="HTTP/1.1" SSLEnabled="true" maxThreads="150" minSpareThreads="25" maxSpareThreads="75" enableLookups="false" disableUploadTimeout="true" acceptCount="100" scheme="https" secure="true" clientAuth="false" sslProtocol="TLS" keystoreFile="conf/myKeystore" keystorePass="mysqlnetwork"/>

Patch sent to Keith.

Patch installed in versions => 2.1.0.1060.

Verified fixed in Monitor build 2.1.0.1060.

An entry was added to the 2.1.0 changelog:

When MySQL Enterprise Monitor 1.3 was upgraded directly to 2.1, and having requested SSL in the upgrade dialog, SSL did not work in the upgraded Monitor.