Re: connecting to MySQL database thru SSH tunnel

2011-12-08 Thread Bernard Devlin
Are you sure that your tunnel is working? I'm assuming that for some reason SSL is not an option, neither is a VPN. You should be able to tunnel a database connection through a SSH tunnel. I've done it many times with different kinds of databases and servers (although never with MySQL). Can you p

Re: connecting to MySQL database thru SSH tunnel

2011-12-08 Thread Admin
In the past, when I was creating a php database and needed to test it, but did not want to open the floodgates and allow any IP address in, or if I was moving around from place to place and my IP would change depending on where I was, tunnelling was an option with some software. Essentially

Re: connecting to MySQL database thru SSH tunnel

2011-12-08 Thread Sieg Lindstrom
Thanks, Bob. I have to confess that I'm not well educated in networking. I'm a regular guy who uses livecode to facilitate tasks I perform at work. Here's a wikipedia article (yeah, know its limitations as a reference source) that includes an explanation of SSH tunneling. http://en.wikipedia.org/

Re: connecting to MySQL database thru SSH tunnel

2011-12-07 Thread Bob Sneidar
Help says: Syntax: revOpenDatabase("mysql",host[:port], databaseName, [userName],[password],[useSSL], [socket], [timeout], [autoReconnect]) Notice the new useSSL argument? All you have to do now is determine if the host accepts SSL connections, and if so, on what port. I am not

connecting to MySQL database thru SSH tunnel

2011-12-07 Thread Sieg Lindstrom
I have an app for managing data in a MySQL database on a remote server. It¹s worked fine for years but now I would like to route the connection thru an SSH tunnel. It uses a port number other than 3306 (PortNumberHere in the function example below). So I¹ve changed the relevant function from this..