-----Original Message----- From: Jangita [mailto:jang...@jangita.com] Sent: 07 April 2006 9:58 p To: win...@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.