revOpenDatabase over SSH tunnel?

[Ben Rubinstein]

Yes, my case is that the database is on a hosted platform which only supports 
access over SSH.

My reading of your document, Matthias, is that we simply invoke SSH in a 
terminal, and then LiveCode/revOpenDatabase uses that tunnel automatically 
because the database host is at the same address. Can that be right? Or does 
this only work with LiveCode server?

Ben

On 10/03/2022 16:42, matthias rebbe via use-livecode wrote:
> There is nothing wrong with your method. But there might be situations where you need direct access to the MySQL database, e.g. you are using 3rd party software (in my case SQLPro Studio) or libraries. I have a customer who is using a special Delphi library that only supports direct connections.
> 
> Okay that is not the case when using Livecode. But there might be servers that do not run Livecode Server. In this case you cannot use your solution.
> In this case SSH tunneling would be a safe solution.
> 
> 
> 
>> Am 10.03.2022 um 17:14 schrieb Bob Sneidar via use-livecode <use-livecode at lists.runrev.com>:
>>
>> I am not sure what SSH tunneling is, but I did a proof of concept where I had an LC client app communicating with an LC server app that encrypted the data at the client end before sending it, and the server end decrypted it. I just used non-secured sockets. I used AES encryption with a key only I know, and a method for corrupting the data in a way only the server can "cleanse".
>>
>> I suppose some may advise me on what is wrong with this method, and I welcome the input, but it worked for me. No unencrypted data went "over the wire".
>>
>> The reason I developed this method is because I do not want to deal with expiring security certificates or secure websites to handle the data transfer. The method works out of the box.
>>
>> Bob S
>>
>>
>>> On Mar 10, 2022, at 03:34 , Ben Rubinstein via use-livecode <use-livecode at lists.runrev.com> wrote:
>>>
>>>
>>> I need to access a (MySQL) database on a remote service - which has to be done over an SSH tunnel.
>>>
>>> Has anyone done this in LiveCode? Is it trivial/possible/impossible?
>>>
>>> TIA,
>>>
>>> Ben
>>>
>>> _______________________________________________
>>> use-livecode mailing list
>>> use-livecode at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>>
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode