Dark Reading is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Perimeter

6/21/2010
08:53 PM
Adrian Lane
Adrian Lane
Commentary
50%
50%

Open-Source Database Security

A recent article on Dark Reading underscores a growing concern in IT: how to secure open-source databases.

A recent article on Dark Reading underscores a growing concern in IT: how to secure open-source databases.According to the article, "Open-Source Databases Pose Unique Security Challenges," by Ericka Chickowski, Ingres and MySQL are being used for large-scale commercial applications. They support Web commerce sites and are growing in use as fast as their commercial counterparts. They are used as a replacement for Oracle, DB2, and SQL Server when cost or flexibility is an issue. The issue Ericka raises is not that these platforms are less secure by nature, but that they lack the supporting security knowledge and tools available on other platforms.

Until recently, the major database vendors did not offer a full suite of database security options. Now they do, with activity monitoring, assessment, and transparent encryption to go along with access controls and authorization schemes. Rummage around the open-source Web sites and you will discover deployment guides and basic security tips -- but these center around access controls and secure communication (i.e., SSL). Security research and tools designed to help secure these platforms is generally absent. Third-party vendors have not ported their monitoring, masking, auditing, and assessment tools because customer demand has not been high enough to justify the costs.

To get a better idea of why this is important, let's look at vulnerability assessment. There are no formalized assessment products, and beyond a smattering of policies for MySQL, no research teams perform policy development for open-source databases.

1. Research for threats, remediation and workarounds: DBAs for the most part are not security professionals, they don't spend their days researching security threats, and they don't know what to look for. What does the attack look like? What is a suitable resolution? Are patches available? If not, is there a workaround/resolve the issue?

2. Automation for the collection of user permissions, manual comparison of settings in relation to established policies, and keeping up to date with patches are all time-consuming, mistake-prone process.

3. Writing the queries to find the information is time-consuming. One of the aspects I hated most about creating assessment policies was writing the queries as a simple check, which could take a day to write and optimize, then test it across all revisions of the database. It might be cost-effective for very large firms to do, but small security firms have trouble justifying the cost of this development.

Apache Derby, Open Ingres, MySQL, and Postgres (or PostgreSQL for some of you) have millions of databases in use. Look at the vendor best practices guides and you will see a preponderance of the discussion around access control and use of SSL. Advanced security usually falls onto the shoulders of the application developers to thwart SQL injection and memory exploits. There are few generic tools over and above file/OS encryption, and that only addresses media protection. Only MySQL has support for monitoring, assessment, third-party auditing, blocking, advanced configuration guides and the like. The other databases? Not so much.

I don't bring this up as some form of advertisement for tools and tool vendors because, frankly, the security vendors don't make solutions for these platforms. My point is to illustrate that security goes largely unaddressed, offering something of a greenfield for attackers. And while we don't hear about these attacks, they do happen.

Is it time for the open-source community to build security policies? Probably. Will it happen? I doubt it. Heck, I can't even find good tuning and performance guide for Postrges: It took years of speaking to other DBAs, along with trial and error, before I found what worked. And believe me, performance questions are far more common than security questions. There is not enough customer demand to motivate third parties or vendors to invest in development. As use of these platforms increases, especially as low-cost, cloud-based services, attacks will increase in frequency, much as they have with Oracle and SQL Server. Unless the open-source community steps up, the platforms will likely suffer a black eye before things change.

Adrian Lane is an analyst/CTO with Securosis LLC, an independent security consulting practice. Special to Dark Reading. Adrian Lane is a Security Strategist and brings over 25 years of industry experience to the Securosis team, much of it at the executive level. Adrian specializes in database security, data security, and secure software development. With experience at Ingres, Oracle, and ... View Full Bio

Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
News
Inside the Ransomware Campaigns Targeting Exchange Servers
Kelly Sheridan, Staff Editor, Dark Reading,  4/2/2021
Commentary
Beyond MITRE ATT&CK: The Case for a New Cyber Kill Chain
Rik Turner, Principal Analyst, Infrastructure Solutions, Omdia,  3/30/2021
Register for Dark Reading Newsletters
White Papers
Video
Cartoon
Current Issue
2021 Top Enterprise IT Trends
We've identified the key trends that are poised to impact the IT landscape in 2021. Find out why they're important and how they will affect you today!
Flash Poll
How Enterprises are Developing Secure Applications
How Enterprises are Developing Secure Applications
Recent breaches of third-party apps are driving many organizations to think harder about the security of their off-the-shelf software as they continue to move left in secure software development practices.
Twitter Feed
Dark Reading - Bug Report
Bug Report
Enterprise Vulnerabilities
From DHS/US-CERT's National Vulnerability Database
CVE-2021-31414
PUBLISHED: 2021-04-16
The unofficial vscode-rpm-spec extension before 0.3.2 for Visual Studio Code allows remote code execution via a crafted workspace configuration.
CVE-2021-26073
PUBLISHED: 2021-04-16
Broken Authentication in Atlassian Connect Express (ACE) from version 3.0.2 before version 6.6.0: Atlassian Connect Express is a Node.js package for building Atlassian Connect apps. Authentication between Atlassian products and the Atlassian Connect Express app occurs with a server-to-server JWT or ...
CVE-2021-26074
PUBLISHED: 2021-04-16
Broken Authentication in Atlassian Connect Spring Boot (ACSB) from version 1.1.0 before version 2.1.3: Atlassian Connect Spring Boot is a Java Spring Boot package for building Atlassian Connect apps. Authentication between Atlassian products and the Atlassian Connect Spring Boot app occurs with a se...
CVE-2018-19942
PUBLISHED: 2021-04-16
A cross-site scripting (XSS) vulnerability has been reported to affect earlier versions of File Station. If exploited, this vulnerability allows remote attackers to inject malicious code. We have already fixed this vulnerability in the following versions: QTS 4.5.2.1566 build 20210202 (and later) QT...
CVE-2021-27691
PUBLISHED: 2021-04-16
Command Injection in Tenda G0 routers with firmware versions v15.11.0.6(9039)_CN and v15.11.0.5(5876)_CN , and Tenda G1 and G3 routers with firmware versions v15.11.0.17(9502)_CN or v15.11.0.16(9024)_CN allows remote attackers to execute arbitrary OS commands via a crafted action/setDebugCfg request...