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

[Dmitrijs Ledkovs]

** Tags removed: verification-needed
** Tags added: verification-done

-- 
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