Excellent. Thanks Matthias. Both your comments and the other discussion were of help. Looks like I'll be making a server app then.
Sean Cole *Pi Digital * On Fri, 16 Oct 2020 at 10:51, matthias rebbe via use-livecode < firstname.lastname@example.org> wrote: > Hi Sean, > > there was a discussion a few weeks ago with the topic "Strange behavior > between Mysql, MariaDB and SSL." > I am not sure if the information in that discussion will solve your > problem. > > Another approach is the following. For security reasons we do not let > communicat our LC apps directly with MySQL Databases, if the Database is > hosted on a public server. > > We using a Livecode Server Script on the Webserver for doing the complete > DB communication. > Our standalones (Mobile and Desktop) send the requests (password encrypted > string) either as POST or GET to the LC Server script. The script encrypts > the request string and executes it. The return from the DB is then > returned to our standalone. > > Another way would be to use an LC server api HostM is providing for free. > https://www.hostm.com/tutorials/livecode/api-mariadb-mysql > > > Regards, > Matthias > > - > Matthias Rebbe > Life Is Too Short For Boring Code > > > Am 16.10.2020 um 10:34 schrieb Pi Digital via use-livecode < > email@example.com>: > > > > Hi > > > > I’ve found myself out of my depth and in need of advice. > > We have a cPanel webspace with mySQL running on a phpMyAdmin layer > within the cPanel setup. Communicating with it from LC has been a breeze. > However, doing a traffic scan we noticed that our queries and responses > from the database are completely visible. Obviously a high security risk. > > > > Using an ssl certificate set, how do I implement this? How do I get > cPanel to allow for it and get LC to make use of them when using > revOpenDatabase? I have the useSSL flag set to Boolean ‘true’. I’ve tried > using the set certificates pointing it at the three ssl files. But the data > still is fully readable as plaintext in both direction when checked by our > traffic scanner. > > > > Thanks > > > > Sean > > > > _______________________________________________ > > use-livecode mailing list > > firstname.lastname@example.org > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > _______________________________________________ > use-livecode mailing list > email@example.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 firstname.lastname@example.org Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode