Re: use SSL inside Mysql connection

[Heriberto Torrado via use-livecode]

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@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@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

Re: use SSL inside Mysql connection

[Bob Sneidar via use-livecode]

It doesn't. It's the community version that cannot bind OpenSSL. The Mac 
version that comes with OS X Server is not the community version and therefore 
supports OpenSSL. That is why I mentioned Windows. If he is running a MacOS X 
Server, SSL should just work. 

Bob S


> On Jan 24, 2018, at 10:51 , Richard Gaskin via use-livecode 
>  wrote:
> 
> Bob Sneidar wrote:
> > 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.
> 
> Why would licensing affect only Windows but not other proprietary OSes?
> 
> -- 
> Richard Gaskin


___
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

Re: use SSL inside Mysql connection

[Richard Gaskin via use-livecode]

Bob Sneidar wrote:
> 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.

Why would licensing affect only Windows but not other proprietary OSes?

--
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.com

___
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

Re: use SSL inside Mysql connection

[Devin Asay via use-livecode]

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@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

___
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

Re: use SSL inside Mysql connection

[Bob Sneidar via use-livecode]

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

Re: use SSL inside Mysql connection

[Tom Glod via use-livecode]

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@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@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 SSL inside Mysql connection

[Heriberto Torrado via use-livecode]

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