Page 1 of 1
Connect to MySQL works on Mac standalone and not on PC
Posted: Sun Jun 05, 2016 4:01 am
by Jordy
I was ready for compiling a test app finally. Made a standalone for Mac and PC. All database use works flawlessly on Mac. Nothing at all happens on PC, no errors, or connection "answer". I basically follows this code.
http://lessons.livecode.com/m/4071/l/70 ... l-database
Thanks for suggestions of where to start
Re: Connect to MySQL works on Mac standalone and not on PC
Posted: Sun Jun 05, 2016 8:56 am
by SparkOut
I would start with checking the database connection parameters.
Then the Windows firewall.
Re: Connect to MySQL works on Mac standalone and not on PC
Posted: Sun Jun 05, 2016 2:51 pm
by Jordy
Ok windows firewall seems like it could be the problem. As a side note current version isn't signed as a verified publisher and Windows firewall prevented one of my friends from downloading it (didn't even give him an option). Can I please ask what you mean by check DB connection parameters?
Re: Connect to MySQL works on Mac standalone and not on PC
Posted: Sun Jun 05, 2016 8:09 pm
by Jordy
I disabled my firewall on PC and I get the same results.
Re: Connect to MySQL works on Mac standalone and not on PC
Posted: Wed Jun 08, 2016 11:32 pm
by Jordy
I had a friend with a mac download this and the application doesn't work on macs either. Apparently the application is only connecting or attempting to connect on the computer it was made on.
Re: Connect to MySQL works on Mac standalone and not on PC
Posted: Wed Jun 08, 2016 11:47 pm
by FourthWorld
Are you using a full path to the database file?
Re: Connect to MySQL works on Mac standalone and not on PC
Posted: Thu Jun 09, 2016 10:52 am
by dave.kilroy
Hi Jordy - it may be due to something happening on the server. I don't know why they keep that lesson on connecting directly to a remote MySQL - much more secure etc to have your app talk to a .lc (or php) web service on the server, and let that connect to the db.
Are you by any chance connecting to an on-rev service or other shared account? If so then in cPanel go to 'Remote MySQL' and try adding the ip of where your windows machine is at as well as your friend with the mac...