FW: Mysql over HTTP

Yes this is very true Eric, thanks.

BUT there are LOADS of firewalls that don't allow non http traffic (like
mysql) over port 80; and your method wont work if all that's available is a
http proxy!

It is true that most firewalls open port 80 but as soon as they don't get a
valid http request they kill the connection hence the disguising of mysql
traffic as a normal (stateless I must add) http request

Some firewalls go as far as disconnecting anyone connected for more than 1
minute (assuming retrieving a page from a http server doesn't take more than
a minute)...

-----Original Message-----
From: Eric Braswell [mailto:ebraswell@mysql.com]
Sent: 07 April 2006 10:15 p
To: Jangita
Cc: mysql@lists.mysql.com
Subject: Re: Mysql over HTTP

No need to re-invent that wheel:

Just use port=80 in my.cnf or start with --port=80

See http://dev.mysql.com/doc/refman/5.0/en/server-options.html

Eric


--
Eric Braswell
Web Manager MySQL AB
Cupertino, USA


Jangita wrote:
> 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=gcdmw-win32@m.gmane.org