use SSL inside Mysql connection

[Heriberto Torrado]

Hi Tom,

No, I did not search in the forum.
I will do that.

Our project is with Mysql and we don't have the time to switch to 
another database (PostreSQL).
We have a lot of data and queries running with Mysql.

Thanks a lot.


On 01/23/2018 10:26 PM, Tom Glod via use-livecode wrote:
> I've seen this addressed somewhere ..... have you searched the forum?....
> my actual question is does it have to be mysql?
>
> On Tue, Jan 23, 2018 at 9:01 PM, 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.
>>
>>
>>
>>
>> _______________________________________________
>> 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