Page 1 of 1

ZeosLib & SSH ?

Posted: 11.11.2010, 11:06
by peshka
Hi,
Help me please, how to connect to mysql database through SSH. ZeosLib can do SSH -tunnel?
Thanks.

Posted: 11.11.2010, 16:34
by mdaems
peshka,

I see you've got your account working ;)

Concerning your SSH-tunnel. In principle there's no difference between using the mysql command line tool over SSH and using zeoslib-powered applications over the same tunnel.
If you get the command line mysql client working over the tunnel, I'm sure zeoslib will not have trouble with it.
Googling gives me some links:
http://www.murdoch-sutherland.com/mysql.html
http://www.whoopis.com/howtos/mysql_ssh_howto.html
http://www.howtoforge.com/secure_mysql_ ... ssh_tunnel
http://www.howtogeek.com/howto/ubuntu/a ... -over-ssh/

Once the tunnel is set up (which can not be done by zeoslib), you can connect using host=localhost and port=<tunneled port>

Mark

BTW: never done it myself, so I can't help with the practical tunnel details.

Posted: 15.11.2010, 09:31
by peshka
Thank you very much for the detailed response!