News for hackers. Stuff that matters.
Re:Remote code execution vulnerability in SQLite by coleifer on Friday December 14, 2018 @06:21PM (#18685839)
Not sure why this is being downvoted, but you're correct. Now, a networked application that exposes some level of access to sqlite? That's another story. The question I think we all are asking is just how much "leg" does sqlite have to show to be vulnerable?
Re:Remote code execution vulnerability in SQLite by tptacek on Friday December 14, 2018 @06:42PM (#18685934)
It's a pretty silly definition; it's like saying PDF or JPEG parsers can't be vulnerable to RCE, when they are in fact major vectors for RCE attacks.
Re:Remote code execution vulnerability in SQLite by ATsch on Friday December 14, 2018 @09:02PM (#18686573)
I think the reverse definition is just as silly... Calling a JPEG parser vulnerability an RCE just because some online service is using it in a way that can be exploited remotely. By that definition, any bug is an RCE, since I can just set up a web server to run that program.

I think a better way of looking at it is that it's an ACE Vulnerability in the e.g. JPEG parser that causes an RCE in the Online Service.

Or, in this case, an ACE vulnerability in SQLite that causes an RCE in Chromium.

Re:Remote code execution vulnerability in SQLite by tptacek on Friday December 14, 2018 @11:34PM (#18687046)
Sure, though what I'd say is silly is epistemological conceit of trying to pin down vulnerabilities as "remote" or "local". A lot of vulnerability research terms are silly (sillier than RCE). Either way: it's a "term of art", and it means what it means, and this is a clear and obvious instance of an RCE.
Re:Remote code execution vulnerability in SQLite by schoen on Friday December 14, 2018 @06:58PM (#18686023)
I assume people making this distinction are thinking about "network services that the public can compromise by interacting with them over the Internet" vs. "software that someone can compromise by getting it to accept a malicious input". But I agree that "RCE" is commonly used for both; otherwise we would have to maintain that browsers don't suffer RCE vulnerabilities because a malicious document is no longer "remote" once the browser has downloaded it.
Re:Remote code execution vulnerability in SQLite by eli on Friday December 14, 2018 @08:44PM (#18686500)
Sure, but I very frequently parse PDFs and JPEGs from untrusted sources, but almost never open untrusted .sqlite files.

(This is still a serious security vulnerability)

Re:Remote code execution vulnerability in SQLite by tptacek on Friday December 14, 2018 @08:45PM (#18686503)
It's an RCE in Chrome.
Re:Remote code execution vulnerability in SQLite by eli on Friday December 14, 2018 @08:46PM (#18686512)
Ok I see your point
Re:Remote code execution vulnerability in SQLite by armitron on Friday December 14, 2018 @09:29PM (#18686674)
Risk is transitive.
Re:Remote code execution vulnerability in SQLite by pedrocr on Saturday December 15, 2018 @09:15AM (#18688451)
> but almost never open untrusted .sqlite files

You may not notice that you do when apps use sqlite as their file format:

https://www.sqlite.org/appfileformat.html

Re:Remote code execution vulnerability in SQLite by tlrobinson on Friday December 14, 2018 @08:48PM (#18686520)
I don't know. I'd say PDF or JPEG parsers (and SQLite) can have arbitrary code execution vulnerabilities, which can in turn be responsible for remote code execution vulnerabilities when used in network-connected software.

e.g. SQLite has an ACE. Chrome has a RCE (which is SQLite's fault).

Re:Remote code execution vulnerability in SQLite by tptacek on Friday December 14, 2018 @10:19PM (#18686836)
If what you're observing is that industry lingo is suboptimal, you'll get no argument from me. Consider for instance "XSS" and "CSRF", which are just manifestly silly names. But the names mean what they mean; try as I might, I can't get people to accept "Javascript injection".
Re:Remote code execution vulnerability in SQLite by burfog on Saturday December 15, 2018 @04:01AM (#18687700)
The actual industry term is just "code execution", or maybe "arbitrary code execution" if you want to get more specific than is typically worthwhile, not "RCE".

Usage example: "I got code execution!"

Re:Remote code execution vulnerability in SQLite by tlrobinson on Saturday December 15, 2018 @03:38AM (#18687662)
I’m observing there are reasonable terms for both the vulnerability in SQLite (https://en.m.wikipedia.org/wiki/Arbitrary_code_execution) and the vulnerability in Chrome due to the vulnerability in SQLite (https://en.m.wikipedia.org/wiki/Remote_code_execution) and wondering why we can’t just use those?
Re:Remote code execution vulnerability in SQLite by tptacek on Saturday December 15, 2018 @06:16PM (#18690885)
I don't know what to tell you. Try this: Google [browser rce], and then [browser ace] (or [browser ace vulnerability] or whatever). It'll be immediately apparent what the term of art for drive-by code execution vulnerabilities in browsers is.

I sort of intellectually in the back of my head know that "arbitrary code execution" is a term that has been coined and used in the past, but I don't offhand know of anyone that uses it (among other things, it's kind of redundant). "Local only" code execution vulnerabilities aren't "LCE", but rather (usually) "privilege escalation".

Re:Remote code execution vulnerability in SQLite by tlrobinson on Sunday December 16, 2018 @08:16PM (#18696288)
In both my comments I explicitly said that vulnerabilities in browsers can and should be called RCEs. I was only arguing about what to call vulnerabilities in the underlying libraries (like SQLite) which aren't inherently exposed to "remote" data/manipulation.

Say for some reason someone used an exploitable version of SQLite in a program that had the setuid bit set. You wouldn't say SQLite had a privilege escalation vulnerability, would you?

Re:Remote code execution vulnerability in SQLite by ynniv on Friday December 14, 2018 @07:16PM (#18686106)
They're only vulnerable to RCE if image data can be supplied remotely. What's the analog here? Accessing the JavaScript API? Specifying a query string? Maliciously encoded data? Some of these are scarier than others.
Re:Remote code execution vulnerability in SQLite by tptacek on Friday December 14, 2018 @07:28PM (#18686179)
This isn't, like, a real debate. Go here:

https://pwnies.com/

Start with the 2018 nominations but feel free to check the archives. Drive-by browser vulnerabilities are RCEs.

Re:Remote code execution vulnerability in SQLite by blattimwind on Friday December 14, 2018 @07:57PM (#18686311)
> Drive-by browser vulnerabilities are RCEs.

I would never argue they aren't, but by this logic ("it's like saying PDF or JPEG parsers can't be vulnerable to RCE") virtually every code execution vuln in a library can be called RCE. I haven't noticed this to be the case with e.g. libtiff vulnerabilities (of which many make it into my inbox regularly), although image libraries are one of the cases were CE = RCE is still fairly reasonable.

Let's assume this SQLite bug is only exploitable if you can input arbitrary SQL. Almost no applications use it this way (except Chrome). I think it's clearly unreasonable to call it a RCE in SQLite then.

Re:Remote code execution vulnerability in SQLite by tptacek on Friday December 14, 2018 @08:28PM (#18686431)
Uh, no, for example, it could also potentially impact any application that uses sqlite as (part of) a file format.
Re:Remote code execution vulnerability in SQLite by stefan_ on Friday December 14, 2018 @10:57PM (#18686952)
In that sense, soon USB kernel stacks have remote code execution vulnerabilities because browsers added dumb APIs.

Should we fix bugs? Yes. Should we scream at people that expose raw APIs they don't understand far beyond their design constraints? Yes yes yes.

Re:Remote code execution vulnerability in SQLite by ynniv on Saturday December 15, 2018 @09:45AM (#18688542)
I think you're assuming the target is a browser, but my question was how this might affects servers. Does the attack use malicious SQL statements, API calls, or encoded data?
Re:Remote code execution vulnerability in SQLite by tzakrajs on Friday December 14, 2018 @08:51PM (#18686529)
Technically, this attack is actually is two separate attacks in a chain. The first node in the chain is delivering malicious SQL. The second node is executing code remotely via SQLite. The proof is that SQLite or the application linking it could have mitigated this attack independently by either filtering the query string or better protecting the memory which is being written to.

In practice, however, the community gets more bang for their buck if they label the SQLite code execution vulnerability as an RCE since the vast majority of use is in a networked setting. You have to remember the audience used for these terms. They aren’t scientists in the traditional sense where taxonomy is highly aligned the ontology — instead, the labeling serves the operators with metaphors that depart from reality insofaras they increase security engineers ability to do their job effectively.

Re:Remote code execution vulnerability in SQLite by LolNoGenerics on Friday December 14, 2018 @08:48PM (#18686518)
Sql databases are usually behind an application layer. Still they can suffer from RCE. Sqlites model is no protection.