5 ms·
I don't see the practical attack vector. For every use case I have for SQLite, none of them involve allowing someone to execute arbitrary SQL against one of my
by bob1029 6y ago
I don't see the practical attack vector. For every use case I have for SQLite, none of them involve allowing someone to execute arbitrary SQL against one of my databases. We also don't do any loading of databases from untrusted parties. Seems like a hypothetical scenario was invented here that could just as well be applied to any database engine with similar outcomes.
- zorked 6y agoThere are a few applications that use SQL databases as their save file format.
- ysleepy 6y agoThe exploit works with any query performed on the sqlite db file. The expected tables are replaced by views that execute the arbitrary sql.
- SQLite 6y agoThe attack is clever and original. AFAIK, nothing like it has ever been seen before. Since this attack came to light, SQLite has added features so that an application can ensure that views and triggers do not have side-effects (outside of the database file itself). And if there are no side-effects then the attack is basically harmless. Sure, the attacker can still exfiltrate or corrupt data, but the attacker had to have write access to the database file in order to carry out the attack in the first place, so exfiltrating or corrupting data is not an issue - they could already do that. See a quick summary at https://sqlite.org/forum/forumpost/8beceed68e https://sqlite.org/forum/forumpost/8beceed68e
- Drip33 6y agoWas the write a shell php file portion of the video/exploit patched? Sites like https://sqliteonline.com/ https://sqliteonline.com/ and https://inloop.github.io/sqlite-viewer/ https://inloop.github.io/sqlite-viewer/ could be perpetually vulnerable if not?
- dsabanin 6y agoIf you watch the actual presentation, you will see clear attack vectors, exploited right there for you.
- devwastaken 6y agoWatched it, but all I'm seeing is queries that require arbitrary access in the first place. If you're using sqlite with prepared statements via another programming language, I'm failing to see how these attacks can be used. Most of these attacks rely on creation of virtual table. Can that be done using a simple select statement with prepared statements?
- cortesoft 6y agoThis is related to the other top post on HN right now about using SQLite as your application file format, which would conceivably involve sending saved files to others.