LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices


Reply
  Search this Thread
Old 05-18-2014, 08:16 AM   #16
Hangdog42
LQ Veteran
 
Registered: Feb 2003
Location: Maryland
Distribution: Slackware
Posts: 7,803
Blog Entries: 1

Rep: Reputation: 422Reputation: 422Reputation: 422Reputation: 422Reputation: 422

Quote:
Originally Posted by mlewis
Knowing that putting mysql directly on the net is a bad idea, I wondered if some had done that, perhaps there was a known practice, a way of doing so which was pretty safe. Everyone seems to agree, no, look for an intermediary.
Well, yes, there are safe ways of doing this, but I think the problem is you're looking for an off-the-shelf solution, and I'm not sure there is such a beast. Everyone's data and schema are going to be different so there really isn't a universal way of doing this, you generally need to roll your own. You might be able to use a pipelining tool like Pentaho to pull it off, but I'm not sure that is any easier than learning how to do a basic PHP or HTML/Python/Perl page that can parse a standardized file.

From a security standpoint, what you are really after is space between mysql and the user. As long as you are running only your vetted SQL statements, and sanitizing the user's input to prevent sql injection attacks, you're about as safe as you can be in this situation.
 
Old 05-19-2014, 11:12 AM   #17
mlewis
Member
 
Registered: Mar 2006
Posts: 187

Original Poster
Rep: Reputation: 16
Yes, ultimately, it ends up being something in between, like a php app, etc. I wanted to ask in the forums in case there might be some things I was not aware of.

Not really looking for an off-the-shelf, I know those things don't exist but often there are tools which are the basis of a solution, where you customize it for your needs.

In the end, there don't seem to be any tricks of the trade that I am unaware of so it will end up being exactly what you are saying.

Thanks to everyone for their help.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] how to sort two mysql table on their date or time column golden_boy615 Programming 3 07-27-2011 03:49 AM
Is there a sort of 2nd SSH daemon server, sort of JAILKIT, in the debian repositories frenchn00b Debian 5 06-20-2010 04:03 AM
Net::Mysql mindsport *BSD 1 01-10-2010 10:32 PM
Could sort of deb-src directly install source packages from SOURCEFORGE.NET/ frenchn00b Debian 1 05-02-2008 02:13 PM
Is there a line limit with the sort utility? Trying to sort 130 million lines of text gruffy Linux - General 4 08-10-2006 08:40 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Networking

All times are GMT -5. The time now is 12:58 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration