[Sqlalchemy-tickets] [sqlalchemy] #2047: connecting with ssl using mysql+oursql fails

[sqlalchemy <mi...@zz...>]

#2047: connecting with ssl using mysql+oursql fails
---------------------------------------+------------------------------------
    Reporter:  guest                   |        Type:  defect
      Status:  new                     |    Priority:  medium
   Milestone:                          |   Component:  access
    Severity:  no triage selected yet  |    Keywords:        
Status_field:  awaiting triage         |  
---------------------------------------+------------------------------------
 sqlalchemy will fail to connect when using ssl in the connect string for a
 mysql database server using ssl for auth with the oursql dialect.

 Fails when a query is executed against the engine:
 {{{
 sqlalchemy.create_engine(
 "mysql+oursql://localhost:3306/databaseName?ssl_ca=/ca.pem&ssl_cert=/cert.pem&ssl_key=/key.pem"
 )
 }}}

 But this works fine:
 {{{
 sqlalchemy.create_engine(
 "mysql://localhost:3306/databaseName?ssl_ca=/ca.pem&ssl_cert=/cert.pem&ssl_key=/key.pem"
 )
 }}}

 Both MySQLdb and oursql connections take the same set of params with the
 ssl auth variables living in a dict with 'ssl_ca' 'ssl_cert' and 'ssl_key'
 as the keys of the dict.

 Required to test: mysql server with ssl auth sqlalchemy and oursql

 Traceback (starting at sqlalchemy entry after calling .one() on a query
 object):

 {{{
   File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line
 1522, in one
     ret = list(self)
   File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line
 1565, in __iter__
     return self._execute_and_instances(context)
   File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line
 1570, in _execute_and_instances
     mapper=self._mapper_zero_or_none())
   File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line
 734, in execute
     return self._connection_for_bind(engine,
 close_with_result=True).execute(
   File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line
 699, in _connection_for_bind
     return self.transaction._connection_for_bind(engine)
   File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line
 315, in _connection_for_bind
     conn = bind.contextual_connect()
   File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line
 1742, in contextual_connect
     self.pool.connect(),
   File "/usr/lib/python2.6/dist-packages/sqlalchemy/pool.py", line 158, in
 connect
     return _ConnectionFairy(self).checkout()
   File "/usr/lib/python2.6/dist-packages/sqlalchemy/pool.py", line 329, in
 __init__
     rec = self._connection_record = pool.get()
   File "/usr/lib/python2.6/dist-packages/sqlalchemy/pool.py", line 177, in
 get
     return self.do_get()
   File "/usr/lib/python2.6/dist-packages/sqlalchemy/pool.py", line 692, in
 do_get
     con = self.create_connection()
   File "/usr/lib/python2.6/dist-packages/sqlalchemy/pool.py", line 138, in
 create_connection
     return _ConnectionRecord(self)
   File "/usr/lib/python2.6/dist-packages/sqlalchemy/pool.py", line 213, in
 __init__
     self.connection = self.__connect()
   File "/usr/lib/python2.6/dist-packages/sqlalchemy/pool.py", line 279, in
 __connect
     connection = self.__pool._creator()
   File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/strategies.py",
 line 76, in connect
     return dialect.connect(*cargs, **cparams)
   File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py",
 line 238, in connect
     return self.dbapi.connect(*cargs, **cparams)
   File "connection.pyx", line 76, in oursql.Connection.__cinit__
 (oursqlx/oursql.c:4175)
 sqlalchemy.exc.DBAPIError: (TypeError) __cinit__() got an unexpected
 keyword argument 'ssl_key' None None
 }}}

-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2047>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python