SSL Connection to remote DB

[townsend]

Is it possible to establish a SSL connection to a PostgreSQL
or mySQL DB? Any references or examples would be appreciated.

[jesse]

not fully tested but dont you just add SSL

put revOpenDatabase("MySQL",server.com,"databasename","username","password",useSSL)

From the documentation: determines whether a connection to a MySQL database uses SSL for the connection. If useSSL is not specified, the connection uses SSL. If the databaseType is not "MySQL", this parameter has no effect.

I'm beginning to wonder if the wording is backwards and it should say is useSSL is specified instead of is not specified.

I'd like to hear everyone elses feedback on this.

[townsend]

I'd like to hear everyone elses feedback on this.

Me too!

Hey-- Where did you find that documentation?
There's nothing in the Dictionary for "useSSL".
Nothing in the User Guide. I even did a Google
search for "livecode useSSL". What documentation?

[bangkok]

put revOpenDatabase("MySQL",server.com,"databasename","username","password",useSSL)

watch out. You have to put "true", not "useSSL).

From the doc : " When connecting to MySQL databases the databaseSpecificOption specifies whether to use SSL for the connection or not, the default is false"

[jesse]

noted. thanks.