The Linux distillery
Bringing the world of Linux to you, David cuts through the tech and shows you how it works and how to use it, in terms that apply to any distro. RSS
IT NEWS      iTWire Technology Feature - Virtualisation
Technology news and Jobs arrow The Linux distillery arrow The dark side of open source: Hacking MySQL
The dark side of open source: Hacking MySQL PDF E-mail
User Rating: / 8
PoorBest 
by David M Williams   
Sunday, 10 February 2008
Open source software advocates – like myself – will point out that a user can have confidence in the application’s integrity because the program code is readily viewable. However, not everyone who reads source code has pure intentions. Here’s how MySQL has been cracked in the past, and how you can keep safe.

Among other benefits, open source software can claim to be Trojan-free. If ever you have fears a program doesn’t really do what it claims or is possibly doing something else just check out the source code and even build it from source. You don’t need to trust any pre-compiled binaries or packages either.

On the one hand it’s easier said than done to “check out the source code”; the number of non-programmers in the world would certainly exceed the number of programmers. Even then, the programmers no doubt have other things to do than pore over every line of every item they wish to run. Nevertheless, because the source code is available you can generally be assured someone somewhere probably has reviewed it and any clearly fake programs would be weeded out by the community.

Yet, just as it is possible to read the source code to verify the program has genuine intentions, there are also those people who read it to find vulnerabilities which they hope to exploit.

This isn’t an argument against open source software by any means; a proprietary system may not have exploits which are found as quickly but there’s a far greater likelihood that the developers of a closed system will not discover these vulnerabilities until after they’ve already been used by the “bad guys.”

By contrast, security defects in open source software will generally be published quickly giving the development team a chance to write and release a fix quickly.

The problem is, however, no matter how many fixes come out or how quickly, unless the existing production systems are patched or upgraded the vulnerabilities will still be out in the wild and open for plucking. This is true no matter if the software is open source or not.

Let’s illustrate with MySQL, the world’s most popular open source database system. This system has a nice feature whereby it prints its version number in clear text to any person or application that connects to it via TCP. You don’t even need to be running a “real” program; the excellent port scanner netcat can be used like so:

nc –w 1 host 3306

The resulting output may be a string like any of these

5.0.15
4.0.20a-nt
3.23.29a-gamma


or something along the same lines. Successfully getting the version number will do wonders; you need now just look it up in the US government sponsored National Vulnerability Database – this site so helpfully provides a vulnerability database. Searching for nothing more than MySQL 5.0.15 brings a page of results including one flagged as high risk, vulnerability summary CVE-2006-2753.

What does it say? And what can you do? Please read on!

CONTINUED








 
< Next story in category   Previous story in the category >
iTWire Technology feature

Virtualisation

dollsmaximise your infrastructure, maximise your business

Read more...



Search the web
Search iTWire

 
You don't need to login to post a comment





Lost Password?
No account yet? Register
Subscribe to our free daily newsletter.
KM Australia 2008
July 21 (8:00 am) - July 22 (11:59 pm), 2008
Web Linkwww.kmaustralia.com Moving forward with an enterprise approach to knowledge, information...

Usability Fundamentals Training Course [Melbourne]
July 21 (9:00 am) - July 22 (11:59 pm), 2008
The success of your website is inextricably linked to how well-versed those involved in the devel...

Business Innovation Forum
July 22 (8:30 am) - July 23 (2:00 pm), 2008
Business Innovation Forum: a morning of innovative thinking that will help you gain business resu...

Toshiba MobileXchange 2008
July 22 (9:00 am) - July 23 (11:59 pm), 2008
Event: Toshiba MobileXchange 2008 What: The Tenth Annual MobileXchange is the largest mobile c...

ISTQB Foundation Certification Course
July 22 (9:00 am) - July 23 (11:59 pm), 2008
This accredited and instructor-led course focuses on developing the student’s knowledge, understa...

Market Research in the Digital Age
July 22, 2008 (9:30 am - 12:00 pm)
Sydney, July 22, 2008 http://www.aimia.com.au/i-cms?page=4539 Four experts share insights on ...

VoIP World 2007
July 23 (8:00 am) - July 25 (11:59 pm), 2008
Australasia’s leading and most established VoIP and IP communications event . . . now into its 4t...

Business Innovation Forum
July 24 (8:00 am) - July 25 (1:30 pm), 2008
Business Innovation Forum: a morning of innovative thinking that will help you gain business resu...

Broadband 2008
July 24 (8:45 am) - July 25 (11:59 pm), 2008
Broadband Australia 2008 The original forum for debating the future of Australia’s broadband i...

The Rapidly Emerging Mobile Media Market
July 24, 2008 (All Day)
Mobile media is the way of the future, and by 2015, it is expected that it will be the major reve...
New event listings
SolidWorks Innovation Day (Melbourne and Adelaide)
October 17, 2008 (All Day)
Hosted by Intercad, SolidWorks’ Innovation Days will give designers, engineers and manufacturers ...

SolidWorks Innovation Day (Sydney)
October 16, 2008 (All Day)
Hosted by Intercad, SolidWorks’ Innovation Days will give designers, engineers and manufacturers ...

SolidWorks Innovation Day (Brisbane and Perth)
October 15, 2008 (All Day)
Hosted by Intercad, SolidWorks’ Innovation Days will give designers, engineers and manufacturers ...

LIXI Industry Forum 2008
September 10, 2008 (All Day)
Wednesday, 10 September 2008 The Westin Sydney The second annual major industry event for the...

Mobile Feast!
August 22, 2008 (All Day)
Join us as we discuss all things mobile! The history of technology tells us that the true inno...

The Business of Digital Content - Melbourne
August 5, 2008 (All Day)
The Business of Digital Content Melbourne – August 5, 2008 Extract maximum value from your...

View Full Calendar
Subscribe to our free daily e-newsletter
Contact , Register , Advertise with iTWire , Links , About iTWire , Feedback , Post your jobs , Events , iTWire site map , Start Blogging , MyBlogLog page
Industry Releases , Submit your release now