revOpenDatabase over SSH tunnel?

[matthias_livecode_150811 at m-r-d.de]

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