[Bug 1027075] Re: SSL support broken, despite SSL support in command line mysql client

[Brian Murray]

This has been fixed in Debian using the same patch that was linked to:

 python-mysqldb (1.2.3-2) unstable; urgency=low

   [ Mika Pflüger ]
   * Team upload.
   * debian/patches/05_ssl.patch: Add upstream patch to force building
     SSL support with newer MySQL client libraries. Thanks to Eldon Koyle
     for isolating the fix in the upstream VCS. (Closes: #678169)
   * Delete now obsolete debian/patches/README.source which referred to
     dpatch.
 
   [ Thomas Goirand ]
   * Added a debian/rules clean: rm MySQL_python.egg-info/PKG-INFO, so it is
     possible to build the package twice.

 -- Mika Pflüger <debian at mikapflueger.de>  Mon, 11 Mar 2013 18:03:06
+0100

** Bug watch added: Debian Bug tracker #678169
   http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=678169

** Also affects: python-mysqldb (Debian) via
   http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=678169
   Importance: Unknown
       Status: Unknown

** Changed in: python-mysqldb (Ubuntu)
       Status: Confirmed => Triaged

** Changed in: python-mysqldb (Ubuntu)
   Importance: Undecided => High

** Changed in: python-mysqldb (Ubuntu)
     Assignee: (unassigned) => Brian Murray (brian-murray)

-- 
You received this bug notification because you are a member of Ubuntu
Foundations Bugs, which is subscribed to python-mysqldb in Ubuntu.
https://bugs.launchpad.net/bugs/1027075

Title:
  SSL support broken, despite SSL support in command line mysql client

Status in “python-mysqldb” package in Ubuntu:
  Triaged
Status in “python-mysqldb” package in Debian:
  Unknown

Bug description:
  With python-mysqldb 1.2.3-1build1 in Ubuntu "precise", when connecting
  with SSL enabled, mysqldb fails due to missing support:

    File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
      return Connection(*args, **kwargs)
    File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
      super(Connection, self).__init__(*args, **kwargs2)
  _mysql_exceptions.NotSupportedError: client library does not have SSL support

  Here's a test script:

  #! /usr/bin/python
  import MySQLdb
  ssl =  { 'key':  'key.pem', 'cert': 'cert.pm', 'ca': 'ca.pem', }
  self.mysqlconnection = MySQLdb.connect( ssl=ssl, host='localhost', user='anyuser', db='anydb', passwd='anypassword' )

  There is some rumour of a change in the output of mysql_config, which
  no longer says -lssl -lcrypto and -DHAVE_OPENSSL:

  $ mysql_config 
  Usage: /usr/bin/mysql_config [OPTIONS]
  Options:
          --cflags         [-I/usr/include/mysql -DBIG_JOINS=1  -fno-strict-aliasing  -g]
          --include        [-I/usr/include/mysql]
          --libs           [-L/usr/lib/i386-linux-gnu -lmysqlclient -lpthread -lz -lm -lrt -ldl]
          --libs_r         [-L/usr/lib/i386-linux-gnu -lmysqlclient_r -lpthread -lz -lm -lrt -ldl]
          --plugindir      [/usr/lib/mysql/plugin]
          --socket         [/var/run/mysqld/mysqld.sock]
          --port           [0]
          --version        [5.5.24]
          --libmysqld-libs [-L/usr/lib/i386-linux-gnu -lmysqld -lpthread -lz -lm -lrt -lwrap -lcrypt -ldl]

  Suddenly SSL based mysql connections that worked are busted.  This is
  possibly part of a larger conspiracy to make SSL suck even more than
  it already does :-)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/python-mysqldb/+bug/1027075/+subscriptions