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
• Status: Closed
• Category: Connector / Python
• Severity: S3 (Non-critical)
• Version: 2.0.4
• OS: Any
• CPU Architecture: Any

[14 May 2015 12:23] Peeyush Gupta

Description:
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__
    self.connect(**kwargs)
  File "/usr/lib/python2.6/site-packages/mysql/connector/connection.py", line 454, in connect
    self._open_connection()
  File "/usr/lib/python2.6/site-packages/mysql/connector/connection.py", line 418, in _open_connection
    self._do_handshake()
  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.