Mysql over HTTP

More info here on how asta (a thin client database layer) explains this
(although I think it sucks and my explanation is much better)

Check here

http://www.astatech.com/support/white/firewalls.asp



-----Original Message-----
From: Jangita [mailto:jangita@jangita.com]
Sent: 07 April 2006 9:58 p
To: win32@lists.mysql.com
Subject: Mysql over HTTP

Hi all,

It's all well and good having mysql using port 3309 (or any other port for
that matter); I'm writing an application that will be used by loads of users
off the internet - so I'm expecting firewall issues.

One easy way is to have the mysql traffic flow over port 80; that works
sometimes but not with intelligent firewalls that only allow http traffic or
companies that have only http ports open (yes there are many of these)

One method I've thought about that goes around this is to write an interface
that sits in-front of the mysql client and translates the mysql traffic into
http get or put requests and use wininet.dll to send these requests to the
server. Since these are get and put requests I'll have to write and install
a cgi or isapi dll on the webserver which translates these requests into
normal traffic and relays it to the mysql server and vice versa.

This would in effect produce an environment where as long as you can browse
you can use the mysql client application (with iexplore because of wininet)
- and with linux to some extent and this will also be able to go thru http
proxies etc (basically anything that ie can go thru)

Before I get my hands dirty; is there anything like this that exists out
there? I have a week leave from Monday and if there isn't well im about to
start writing one.

Jangita


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=jangita@jangita.com




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org