use SSL inside Mysql connection

[Bob Sneidar]

Which version of mySQL? The Windows community version does not support OpenSSL because of licensing restrictions. It uses some other flavor of SSL, which I was never able to get to work. 

Bob S


> On Jan 23, 2018, at 18:01 , Heriberto Torrado via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> Hi,
> 
> I'm going crazy trying to make a SSL mysql connection from a Livecode Stack.
> I was searching information in Livecode dictionary and Livecode guides, but there's not much information about that.
> 
> I'm developing a small application for a customer.
> 
> This applications will be run inside my customer's premises.
> 
> I don't want to build a middleware between that database and the applications because we don't have the time and resources.
> 
> Well, my mysql connection is this:
> 
> put revOpenDatabase("MySQL", tserver, tDatabaseName, tuser, tpass, useSSL=true, autoReconnect) into tResult
> 
> But SSL seems not to work.
> 
> My questions are:
> 
> Is my string database connection well done?
> Where do I have to put the client certificates for my MYSQL database?
> Could you please send me a couple of small samples?
> 
> Thank you very much in advance.