I am very intrigued by the TM SQL features, namely, running a
arbitrary SQL command in the editor, as well as the browser. So far,
reading the help, I see I have a small connection window in which I
can enter in the usual host, user, pass, and database name.
The trouble is, I do not want to open my databases up to remote
connections. Almost always they are allowed access from localhost.
Most ISP's are not going to allow access from some other host as well,
not to mention, if you do not have a static IP, you are going to be a
moving target anyway.
What are my options at this point? I have a ssh/ftp/sftp type
connection in which TM is opened against it, and I can save right back
to the server. The sql stuff happens locally on the server.
Any way to integrate that type of connection with TM's sql tools?
Scott * If you contact me off list replace talklists@ with scott@ *
Show replies by date
You can set up a reverse ssh tunnel and use TM to connect via that tunnel.
Do a man ssh to read more about it.