Ever tried just setting up a proxy on the server (like a reverse proxy
- I guess) and let RB handle the SQL connection without having to
tunnel anything?
On 6/29/05, David Washburn <DWashburn at aminfo dot com> wrote:
> I am interested in opening a SSH tunnel so my Realbasic application can
> talk to a MySQL database server where direct access is not allowed.
> I have opened a SSH tunnel successfully - and I have been able to
> interact with the data successfully from within my RB application.
> I am looking for a clean way to create the SSH tunnel from within my
> application. I would like to establish the tunnel when the application
> starts and disable it when it finishes.
>
> This is a Windows application.
>
> Here what I have tried:
> - I have Plink installed and using the command line I can create a SHH
> Tunnel.
> - I created a batch file with the Plink commands that can hold the Plink
> command line and parameters - and this works.
> - I was able to start Plink using the RB Shell command - but on Windows
> this is synchronous so my application either hangs because the command
> line can't end until the application ends, or I end the command line and
> the tunnel closes.
> - I tried to put the shell command in a thread thinking I could isolate
> it. But that seems to hang.
> - I made a BAT command file and I placed a START PLINK command in it.
> This worked because it started a separate command file in a separate
> process that ran independent of my application. There doesn't seem to be
> an obvious way to stop this command file when the user quits the
> application. Also - if the user closes the command processor the tunnel
> goes away.
> - I tried to create a Windows service in RealBasic to create the tunnel
> - seem that didn't work If this worked it would make the application
> installation more complicated since the service would be necessary. At
> least it would be hidden.
> - I successfully built a ConsolApplication that opened the tunnel. It
> must be started when the application is started.
>
> What I would like:
> 1) Ideally I would like to be able to create the tunnel as part of the
> MySQL plugin/MySQL Class.
> 2) I would like a "hidden" technique to start a tunnel when my
> application starts and terminate it when my application ends.
> 3) I would prefer not to have to install a separate application like
> Plink to make the SSH tunnel.
>
> Anyone have any suggestions?
> _______________________________________________
> Unsubscribe or switch delivery mode:
> <http://www.realsoftware.com/support/listmanager/>
>
> Search the archives of this list here:
> <http://support.realsoftware.com/listarchives/lists.html>
>
--
Roses are red,
Violets are blue,
In soviet russia
Poems write you.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|