Re: FW: Mysql over HTTP

Ok, not sure how much this will help, but here goes.....

Instead of writing something that adds http headers to mySQL requests, 
it might be easier to write a Web Service.  A webservice uses http to 
send XML over the wire in a very open format.  The hardest part will 
actually learning the JAVA or .NET to actually write the web service 
with mySQL as the backend. 


*Brandon Schenz*
Midwest Sports Supply
IT Manager
Phone: 513-956-4900
Fax: 513-956-4910
E-mail: [email protected]


Jangita wrote:
> 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------
>
>