Bug #77040 handshake with server fails with server version 5.5.8
Submitted: 14 May 2015 12:23 Modified: 19 Jun 2015 17:12
Reporter: Peeyush Gupta Email Updates:
Status: Closed Impact on me:
Category:Connector / Python Severity:S3 (Non-critical)
Version:2.0.4 OS:Any
Assigned to: CPU Architecture:Any

[14 May 2015 12:23] Peeyush Gupta
Connection with MySQL server version 5.5.8 fails with following error
Traceback (most recent call last):
  File "test.py", line 8, in <module>
    cnx = mysql.connector.connect(**config)
  File "/usr/lib/python2.6/site-packages/mysql/connector/__init__.py", line 162, in connect
    return MySQLConnection(*args, **kwargs)
  File "/usr/lib/python2.6/site-packages/mysql/connector/connection.py", line 129, in __init__
  File "/usr/lib/python2.6/site-packages/mysql/connector/connection.py", line 454, in connect
  File "/usr/lib/python2.6/site-packages/mysql/connector/connection.py", line 418, in _open_connection
  File "/usr/lib/python2.6/site-packages/mysql/connector/connection.py", line 149, in _do_handshake
    'Failed parsing handshake; {0}'.format(err))
mysql.connector.errors.InterfaceError: Failed parsing handshake; end byte not present in buffer

This is due to an error with server 5.5.8  BUG#59453

How to repeat:
Try to make a connection with server 5.5.8

Suggested fix:
Ignore the check for end byte if not present in handshake packet for server 5.5.8
[19 Jun 2015 17:12] Paul DuBois
Noted in 2.1.3 changelog.

Connector/Python failed to complete the connection handshake with
MySQL Server 5.5.8.