Hi,
I'm trying to connect get web2py to connect to MySQL via SSL (or SSH). 
Based on the code, seems like I need to do something like:

db = DAL('..', 
driver_args=dict(ssl=dict(ca='/path/to/mysql-ssl-ca-cert.pem')))

(I only need the CA cert file, the key and certificate files are not needed 
for the connection.)

It works through my SQL client (Sequel Pro), but not through web2py. Anyone 
have any ideas? It gives me the following error message:

<type 'exceptions.RuntimeError'> Failure to connect, tried 5 times: 
Traceback (most recent call last): File 
"/Users/oamasood/src/web2py/gluon/dal.py", line 6853, in __init__ 
self._adapter = ADAPTERS[self._dbname](**kwargs) File 
"/Users/oamasood/src/web2py/gluon/dal.py", line 2402, in __init__ if 
do_connect: self.reconnect() File 
"/Users/oamasood/src/web2py/gluon/dal.py", line 576, in reconnect 
self.connection = f() File "/Users/oamasood/src/web2py/gluon/dal.py", line 
2400, in connector return self.driver.connect(**driver_args) File 
"/Users/oamasood/src/web2py/gluon/contrib/pymysql/__init__.py", line 93, in 
Connect return Connection(*args, **kwargs) File 
"/Users/oamasood/src/web2py/gluon/contrib/pymysql/connections.py", line 
575, in __init__ self._connect() File 
"/Users/oamasood/src/web2py/gluon/contrib/pymysql/connections.py", line 
741, in _connect self._request_authentication() File 
"/Users/oamasood/src/web2py/gluon/contrib/pymysql/connections.py", line 
796, in _request_authentication self._send_authentication() File 
"/Users/oamasood/src/web2py/gluon/contrib/pymysql/connections.py", line 
822, in _send_authentication self.socket = 
ssl.wrap_self.socketet(self.socket, keyfile=self.key, AttributeError: 
'module' object has no attribute 'wrap_self'


Thanks,
Osman

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to