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@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@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode