use SSL inside Mysql connection

[Devin Asay]

Heribito,

Your revOpenDatabase call is incorrectly formed. The useSSL and autoReconnect parameters should be booleans, like this:

put revOpenDatabase(“mysql”, tServer, tDatabaseName, tUser, tPass,true,,,true) into tConnectionID

Note also that you have to put the values into the correct parameter sequence, leaving empty items for params you are not using.

Hope this helps,

Devin



On Tue, Jan 23, 2018 at 9:01 PM, Heriberto Torrado via use-livecode <
use-livecode at lists.runrev.com<mailto: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.

Devin Asay
Director
Office of Digital Humanities
Brigham Young University