[PLUG] Methods of secure SQL Database data exchange over Internet?

Alex Daniloff alex at daniloff.com
Tue Apr 30 23:23:49 UTC 2002


Hello,

> 
> what is the client set up? just using generic MySQL clients or could
this be 
> done via web pages, etc.?
> 

The client setup is perl or expect scripts that connect to web DB,
identify client and perform nessesary data exchange. 
Nothing is complicated. 


> >From past experience, the mysql server listening on an accessible
port can be 
> a problem....This is also dependant upon the sensitivity of the data
you are 
> storing there.  
> 

Should I write MySQL wrapper by myself or existing solutions are
available?

Alex



> 
> 
> On Tuesday 30 April 2002 06:50 pm, you wrote:
> > Hello,
> > Thank you for your reply.
> > VPN is not suitable in this case 'cause some remote hosts
temporarily
> > connected to Internet over dialup connections.
> > Thus their temporary IPs are assigned dynamically by their ISPs.
> >
> > Alex
> >
> > -------------------
> >
> > > VPN.
> > >
> > > -----Original Message-----
> > > From: plug-admin at lists.pdxlinux.org
> > > [mailto:plug-admin at lists.pdxlinux.org]On Behalf Of Alex Daniloff
> > > Sent: Tuesday, April 30, 2002 2:54 PM
> > > To: plug at lists.pdxlinux.org
> > > Subject: [PLUG] Methods of secure SQL Database data exchange
over
> > > Internet?
> > >
> > >
> > > Hello Linux folkz,
> > > I need to setup Web based MySQL database service over Internet.
> > > Remote clients should be able to connect to database port 3306
and
> > > perform secure data exchange (queries, reads and writes).
> > > Are there any methods to perform such data exchanges in a most
> >
> > secure
> >
> > > manner?
> > > I was thinking about keeping port 3306 open for remote
connections
> > > 'cause Mysql has a very good (per host, per user, per database,
per
> > > table, per row based) security mechanisms.
> > > But in this case the use of firewall on a separate box is
> >
> > purposeless.
> >
> > > It it the same as having database server and firewall on the
same
> >
> > box.
> >
> > > May be you can point me to other more secure solutions?
> > > Is it possible to use ssl for database connections? I couldn't
find
> >
> > a
> >
> > > decent answer on this question.
> > > Thank you in advance for any advises or sources of information.
> > > Alex
> > >
> > > _______________________________________________
> > > PLUG mailing list
> > > PLUG at lists.pdxlinux.org
> > > http://lists.pdxlinux.org/mailman/listinfo/plug
> > >
> > > _______________________________________________
> > > PLUG mailing list
> > > PLUG at lists.pdxlinux.org
> > > http://lists.pdxlinux.org/mailman/listinfo/plug
> >
> > _______________________________________________
> > PLUG mailing list
> > PLUG at lists.pdxlinux.org
> > http://lists.pdxlinux.org/mailman/listinfo/plug
> 
> -- 
> Brian Horan
> bhoran at hexdev.com
> 
> _______________________________________________
> PLUG mailing list
> PLUG at lists.pdxlinux.org
> http://lists.pdxlinux.org/mailman/listinfo/plug
> 




More information about the PLUG mailing list