Melvyn Sopacua wrote: ----------------->>>> >Does MySQL have any facility for using SSH to tunnel ports for use in >replication? Has anyone implemented anything like this? >We can't just assume if we create an SSH tunnel manually that the >connection will stay up.
There was an excellent piece in August 2001's Sysadmin, that described just that - for an intrusion detection system - but the principals remain the same. Unfortunately, it's not been published online: http://sysadminmag.com/articles/2001/0108/ "Distributed Intrusion Detection with Open Source Tools Jason Chan Chan presents an example of an intrusion detection system comprising open source tools such as Snort, OpenSSL, Stunnel, and MySQL. " I remember that Stunnel is used to provide the tunneling and looking at that site, there's a complete example available: http://www.stunnel.org/examples/mysql.html ----------------->>>> Although I have not done this, couldn't you could use ssh port forwarding? ssh -L <local port>:<mysql host>:<hostport> then use mysql -h <local host> -P <local port> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
