iOS and MySQL SSL

Getting into LiveCode for iOS? Ask your questions here.

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
Doug Lyman
Posts: 30
Joined: Thu Jun 30, 2011 6:13 am

iOS and MySQL SSL

Post by Doug Lyman » Mon Mar 14, 2016 10:08 pm

What are the latest versions of LiveCode, MySQL, and OpenSSL that are tested to work for MySQL SSL connections? I am able to connect using SSL from within the IDE but not from the iOS simulator. I get the error: "Cannot load SSL Library." Presently using LC 7.1.1, xCode 7.1.1, MySQL Community Edition 5.6.26.
Last edited by Doug Lyman on Wed Mar 16, 2016 5:22 pm, edited 1 time in total.

quailcreek
Posts: 746
Joined: Sun Feb 04, 2007 11:01 pm

Re: iOS and MySQL SSL

Post by quailcreek » Tue Mar 15, 2016 4:49 pm

Look up SSL in the dictionary.

Right from the Dictionary:
If you use this feature in a standalone application, remember to select 'SSL Encryption' from among the available 'script libraries' in the standalone application settings panel.
Tom
MacBook Pro OS Mojave 10.14

Doug Lyman
Posts: 30
Joined: Thu Jun 30, 2011 6:13 am

Re: iOS and MySQL SSL

Post by Doug Lyman » Tue Mar 15, 2016 5:27 pm

Of course. MySQL selected (General), MySQL selected (iOS), Encryption selected (iOS), SSL Encryption selected (iOS), All done before I made this posting.

FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 10043
Joined: Sat Apr 08, 2006 7:05 am
Contact:

Re: iOS and MySQL SSL

Post by FourthWorld » Tue Mar 15, 2016 5:28 pm

If your database is exposed to the Internet you might consider using PHP or LiveCode to provide an API to protect it.
http://serverfault.com/questions/19945/ ... 9961#19961
Richard Gaskin
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn

peter-b
Posts: 182
Joined: Thu Nov 20, 2014 2:14 pm

Re: iOS and MySQL SSL

Post by peter-b » Wed Mar 16, 2016 3:11 pm

Hi Doug,

I note that you're using LiveCode 7.1.1. Could you please try deploying your stack with LiveCode 7.1.2 or LiveCode 7.1.3 and see if the problem goes away?

Thanks!
LiveCode Open Source Team — @PeterTBBrett — peter.brett@livecode.com

Doug Lyman
Posts: 30
Joined: Thu Jun 30, 2011 6:13 am

Re: iOS and MySQL SSL

Post by Doug Lyman » Wed Mar 16, 2016 3:54 pm

Done and done. No luck. Works in the IDE, not in the Simulator.

Doug Lyman
Posts: 30
Joined: Thu Jun 30, 2011 6:13 am

Re: iOS and MySQL SSL

Post by Doug Lyman » Thu Mar 17, 2016 3:56 pm

I wrote this up and it has been confirmed as a bug.

FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 10043
Joined: Sat Apr 08, 2006 7:05 am
Contact:

Re: iOS and MySQL SSL

Post by FourthWorld » Thu Mar 17, 2016 4:37 pm

Doug Lyman wrote:I wrote this up and it has been confirmed as a bug.
What is the bug report number so others encountering this can follow its progress?
Richard Gaskin
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn

Doug Lyman
Posts: 30
Joined: Thu Jun 30, 2011 6:13 am

Re: iOS and MySQL SSL

Post by Doug Lyman » Thu Mar 17, 2016 9:14 pm

Bug No. 17150

Post Reply