Application connecting to MySQL DB with port 3306 blocked?

Anything beyond the basics in using the LiveCode language. Share your handlers, functions and magic here.

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
kellymdeters
Posts: 23
Joined: Wed Oct 31, 2007 9:16 pm

Application connecting to MySQL DB with port 3306 blocked?

Post by kellymdeters » Sun Dec 02, 2007 3:34 am

I've created a stand-alone with RunRev for students and teachers to input lab report information and it's stored in a mysql db on my server. the problem is that some schools have port 3306 blocked and they can't use the program (that's the port mysql connects to by default).

How can I use this runrev program (it's so much better than my first generation program with just php--but that was accessible by all) to allow people to connect to mysql without having to open ports (something some schools refuse to do).

Kelly

BvG
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 1236
Joined: Sat Apr 08, 2006 1:10 pm
Location: Zurich
Contact:

Post by BvG » Sun Dec 02, 2007 12:40 pm

if you're not allowed to use any custom ports, then you have to use an allowed port, for example 80 (http). If you already have a website on your server that hogs port 80, you need to make an interface on the server, for example a php script that access the database locally on the server, and receives commands via http from your rev client.
Various teststacks and stuff:
http://bjoernke.com

Chat with other RunRev developers:
chat.freenode.net:6666 #livecode

Post Reply

Return to “Talking LiveCode”