Bug #49386 Enterprise Dashboard 2.0 to 2.1 gets certificate errors
Submitted: 3 Dec 2009 1:29 Modified: 12 Feb 2010 20:16
Reporter: Kyle Joiner Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Enterprise Monitor: Installing Severity:S3 (Non-critical)
Version:2.1 OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: .pem file, certificate, upgrade, windmill

[3 Dec 2009 1:29] Kyle Joiner
Description:
Uprading the Enterprise Dashboard from 2.0 to 2.1 may receive an error:

Unable to load certificate key /opt/mysql/enterprise/monitor/apache-tomcat/conf/hostname.pem
(error:02001002:system library:fopen:No such file or directory)

How to repeat:
upgrade 2.0 to 2.1

Suggested fix:
Correct the upgrade process.
[2 Feb 2010 15:23] MySQL Verification Team
reproduced using mysqlmonitor-2.1.0.1096-linux-x86_64-installer.bin and mysqlmonitor-2.1.1.1141-linux-x86_64-update-installer.bin.

1. installed first mysqlmonitor-2.1.0.1096-linux-x86_64-installer.bin
2. setup SSL certificate
3. checked that tomcat successfully run using my myKEY.pem file
4. stop monitor
5. upgrade using mysqlmonitor-2.1.1.1141-linux-x86_64-update-installer.bin
6. check catalina.out:

SEVERE: Error starting endpoint
java.io.FileNotFoundException: /data2/users/victoria/mysql/enterprise/monitor/apache-tomcat/conf/myKEY.pem (No such file or directory)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(Unknown Source)

file was copied to backup directory but not back. problem fixed if you manually copy file back.
[12 Feb 2010 20:13] Andy Bang
This is a duplicate of Bug #44525 (Upgrade Service Manager installer overwrites SSL certificate information).