You are welcome! Richard
On Sat, Feb 16, 2013 at 5:40 PM, Osman Masood <[email protected]> wrote: > Thanks, Richard. It worked. > > The command I used was: > ssh linux_user@ip_address -L 3307:database_ip:3306 > > (Our database is hosted on Amazon RDS, so for us ip_address was different > from database_ip. ) > > Our connection string was: > > 'mysql://user:password@localhost:3307/database_name' > > > Thanks again! > > > On Fri, Feb 15, 2013 at 9:27 AM, Richard Vézina < > [email protected]> wrote: > >> Better use SSH with port fowarding... >> >> Something like that in terminal : >> >> ssh -L3307:localhost:3306 linux_user@ip_address >> >> Then you should be able to use this connection string : >> >> db=DAL('mysql://user:[email protected]:3307/database', ...) >> >> Not tested... >> >> Richard >> >> >> On Thu, Feb 14, 2013 at 6:08 PM, Osman Masood <[email protected]> wrote: >> >>> 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 [email protected]. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >>> >> >> -- >> >> --- >> 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 [email protected]. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- > > --- > 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 [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- --- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
