FW: Mysql over HTTP

True, I could write a browser app with apache/mysql/php - but there are some
things that just can't be done with a browser, for example back to my chat
example; having a web based yahoo chat is fun and will work; but those
notifications at the bottom of the screen the sounds etc. Or another example
like a news popup program that sits on the system tray. You probably agree
that there is stuff that an application is better (and more secure as
doing).Frankly I'm not that good in http and php - can whip up a Delphi app
in seconds tho :) )

I'm thinking packing it well enough (the way you can download a regular file
from a website) should hide the traffic well enough;

As for the client and server conversion apps I could probably sell then :)

-----Original Message-----
From: Daniel da Veiga [mailto:[email protected]] 
Sent: 07 April 2006 10:18 p
To: MySQL Win32 List
Subject: Re: Mysql over HTTP

On 4/7/06, Jangita <[email protected]> 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.
>

Is there any specific reason for you not to write your application
using a web language like PHP, Perl, ASP, .NET or anything like that?
You mentioned some weird convertions regarding TCP packages headers
and filtering, while searching for a solution to let an app access
MySQL trough firewalls and/or proxies, why not simply write a CGI or
server-side based app?

You'll have LOTS of problems while dealing with TCP/IP packaging and
headers and converting it all to HTTP traffic, besides, you'll
probably load your server a LOT while still having to write a
client-side AND a server-side conversion tool for traffic. Besides, it
won't be fail proof as you can still step in some routers that may
block your converted packages.

If you want to use a browser-like app, why not let the browser do its work?

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]