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

[Dave Walker]

Hello C, or anyone else affected,

Accepted python-mysqldb into precise-proposed. The package will build
now and be available at http://launchpad.net/ubuntu/+source/python-
mysqldb/1.2.3-1ubuntu0.1 in a few hours, and then in the -proposed
repository.

Please help us by testing this new package.  See
https://wiki.ubuntu.com/Testing/EnableProposed for documentation how to
enable and use -proposed.  Your feedback will aid us getting this update
out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug,
mentioning the version of the package you tested, and change the tag
from verification-needed to verification-done. If it does not fix the
bug for you, please add a comment stating that, and change the tag to
verification-failed.  In either case, details of your testing will help
us make a better decision.

Further information regarding the verification process can be found at
https://wiki.ubuntu.com/QATeam/PerformingSRUVerification .  Thank you in
advance!

** Changed in: python-mysqldb (Ubuntu Precise)
       Status: In Progress => Fix Committed

** Tags added: verification-needed

-- 
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:
  Fix Released
Status in “python-mysqldb” source package in Precise:
  Fix Committed
Status in “python-mysqldb” package in Debian:
  Fix Released

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