We have been recently approached by a customer to conduct a MySQL upgrade on their Windows server which runs SmarterTrack 5.4 Enterprise with MySQL 5.5.9 community edition as the database backend. The upgrade has been running pretty smooth without any major issues . However, things start get nasty when we try to login to the SmarterTrack admin management interface upon restarting all the services. It just does not work and we have been thrown for the screen message :
The page or resource that you are accessing is unavailable or an error has occurred.
This error occurred at 7/24/2011 12:08:44 AM and has been logged. Please contact your system administrator.
Nothing was changed on the SmarterTrack configuration other than the MySQL upgrade. Event log has this logged – however :
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 7/24/2011 12:08:45 AM
Event time (UTC): 7/24/2011 7:08:45 AM
Event ID: 68c71ec9be3441b4b82551c2fb68013d
Event sequence: 21
Event occurrence: 3
Event detail code: 0
Application domain: /LM/W3SVC/2/ROOT-1-129461807462329645
Trust level: Full
Application Virtual Path: /
Application Path: C:inetpubwwwroothelpdesk
Machine name: SERVER23
Process ID: 3220
Process name: w3wp.exe
Account name: NT AUTHORITYNETWORK SERVICE
Exception type: MySqlException
Exception message: Bad handshake
It turns out to be some MySQL bug in the in edition starting from 5.5.12 which was yet to be fixed on the latest 5.5.14 as well. Certain SmarterTrack user has reported the same MySQL Bad Handshake error at SmarterTools forum with few different error message logged.
If you are looking for an upgrade to the latest MySQL 5.5.14, hold back until the bug has been confirmed fixed as it may affect other of your applications. We have reverted MySQL back to MySQL 5.5.9 and SmarterTrack just started to work back again.