Thread: [SQLObject] MySQL SSH Connection
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Koen B. <ko...@ma...> - 2005-04-26 13:43:35
|
Hello. I would like to connect to my MySQL server through a SSH =20 tunnel with encryption/compression. There is a very neat SSH =20 implementation for Python called Paramiko (http://www.lag.net/=20 paramiko/). What is the best way to do this? I'm not that good in =20 Python yet. What I now have: MySQL<--->SSH<--->Python:Socket<--->Pyhton:Paramiko<--->Python-MySQL It does work, but I have the feeling there must be a more effici=C3=ABnt = =20 way to do this. =EF=BF=BC= |
From: Oleg B. <ph...@ma...> - 2005-04-26 15:17:17
|
On Tue, Apr 26, 2005 at 03:43:23PM +0200, Koen Bok wrote: > Hello. I would like to connect to my MySQL server through a SSH > tunnel with encryption/compression. I am pretty sure MySQL supports SSL. Try to find information on the Net and report your findings. Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Bob I. <bo...@re...> - 2005-04-26 18:00:10
|
On Apr 26, 2005, at 11:17 AM, Oleg Broytmann wrote: > On Tue, Apr 26, 2005 at 03:43:23PM +0200, Koen Bok wrote: >> Hello. I would like to connect to my MySQL server through a SSH >> tunnel with encryption/compression. > > I am pretty sure MySQL supports SSL. Try to find information on the > Net and report your findings. Although a SSH tunnel would still prove useful for getting to a database server that's sitting behind a firewall, assuming you have SSH access to something else on that network (probably the firewall itself). For performance reasons, it might be better to use SSH or Conch (Twisted's SSH implementation) to do the port forwarding.. but that's not really something you should worry about until you've proven that SSH via Paramiko is a bottleneck, it probably won't be. -bob |