CVE-2018-20346: SQL Injection
First published: Fri Dec 14 2018(Updated: )
Multiple flaws were found in sqlite. An attacker who is able to run arbitrary SQL statements could use this flaw to corrupt the internal databases, which can lead to arbitrary code execution as the user running sqlite. This issue was fixed via sqlite-3.25.3 release at: <a href="https://www.sqlite.org/releaselog/3_25_3.html">https://www.sqlite.org/releaselog/3_25_3.html</a> Also sqlite-3.36 introduced SQLITE_DBCONFIG_DEFENSIVE option which when added to the config file, could prevent attackers for corrupting the internal database files. This could however break applications which require users to write these database files. <a href="https://www.sqlite.org/releaselog/3_26_0.html">https://www.sqlite.org/releaselog/3_26_0.html</a> <a href="https://www.sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigdefensive">https://www.sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigdefensive</a>
Credit: Tencent Blade Team Tencent Blade Team Tencent Blade Team Tencent Blade Team Tencent Blade Team Tencent Blade Team Tencent Blade Team Tencent Blade Team Tencent Blade Team Tencent Blade Team Tencent Blade Team Tencent Blade Team Tencent Blade Team Tencent Blade Team Tencent Blade Team Tencent Blade Team Tencent Blade Team Tencent Blade Team cve@mitre.org cve@mitre.org
| Affected Software | Affected Version | How to fix |
|---|---|---|
| Apple iCloud for Windows | <7.10 | 7.10 |
| Apple iTunes for Windows | <12.9.3 | 12.9.3 |
| SQLite SQLite | <3.25.3 | |
| Google Chrome | <71.0.3578.80 | |
| Redhat Linux | =6.0 | |
| Debian Debian Linux | =8.0 | |
| openSUSE Leap | =15.0 | |
| openSUSE Leap | =42.3 | |
| Apple watchOS | <5.1.3 | 5.1.3 |
| Apple macOS Mojave | <10.14.3 | 10.14.3 |
| Apple High Sierra | ||
| Apple Sierra | ||
| Apple tvOS | <12.1.2 | 12.1.2 |
| Apple iOS | <12.1.3 | 12.1.3 |
| ubuntu/chromium | <71.0.3578.80-1 | 71.0.3578.80-1 |
| ubuntu/sqlite3 | <3.22.0-1ubuntu0.1 | 3.22.0-1ubuntu0.1 |
| ubuntu/sqlite3 | <3.24.0-1ubuntu0.1 | 3.24.0-1ubuntu0.1 |
| ubuntu/sqlite3 | <3.8.2-1ubuntu2.2+ | 3.8.2-1ubuntu2.2+ |
| ubuntu/sqlite3 | <3.25.3-1 | 3.25.3-1 |
| ubuntu/sqlite3 | <3.11.0-1ubuntu1.2 | 3.11.0-1ubuntu1.2 |
| Google Android | ||
| debian/chromium | 90.0.4430.212-1~deb10u1 120.0.6099.224-1~deb11u1 121.0.6167.139-1~deb12u1 124.0.6367.201-1~deb12u1 124.0.6367.118-1 124.0.6367.201-1 | |
| debian/sqlite | 2.8.17-15 2.8.17-15+deb10u1 | |
| debian/sqlite3 | 3.27.2-3+deb10u1 3.27.2-3+deb10u2 3.34.1-3 3.40.1-2 3.45.3-1 |
Never miss a vulnerability like this again
Sign up to SecAlerts for real-time vulnerability data matched to your software, aggregated from hundreds of sources.
Reference Links
- https://support.apple.com/en-us/HT209451 (Advisory)
- https://support.apple.com/en-us/HT209450 (Advisory)
- https://access.redhat.com/articles/3758321
- https://blade.tencent.com/magellan/index_en.html
- https://bugzilla.redhat.com/show_bug.cgi?id=1659379
- https://bugzilla.redhat.com/show_bug.cgi?id=1659677
- https://chromereleases.googleblog.com/2018/12/stable-channel-update-for-desktop.html
- https://chromium.googlesource.com/chromium/src/+/c368e30ae55600a1c3c9cb1710a54f9c55de786e
- https://crbug.com/900910
- https://github.com/zhuowei/worthdoingbadly.com/blob/master/_posts/2018-12-14-sqlitebug.html
- https://news.ycombinator.com/item?id=18685296
- https://sqlite.org/src/info/940f2adc8541a838
- https://sqlite.org/src/info/d44318f59044162e
- https://worthdoingbadly.com/sqlitebug/
- https://www.mail-archive.com/sqlite-users@mailinglists.sqlite.org/msg113218.html
- https://www.sqlite.org/releaselog/3_25_3.html
- https://lists.debian.org/debian-lts-announce/2018/12/msg00012.html
- https://www.synology.com/security/advisory/Synology_SA_18_61
- http://www.securityfocus.com/bid/106323
- https://www.freebsd.org/security/advisories/FreeBSD-EN-19:03.sqlite.asc
- https://security.gentoo.org/glsa/201904-21
- http://lists.opensuse.org/opensuse-security-announce/2019-04/msg00040.html
- http://lists.opensuse.org/opensuse-security-announce/2019-04/msg00070.html
- https://usn.ubuntu.com/4019-1/
- https://usn.ubuntu.com/4019-2/
- https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/PU4NZ6DDU4BEM3ACM3FM6GLEPX56ZQXK/
- https://support.apple.com/HT209443
- https://support.apple.com/HT209446
- https://support.apple.com/HT209447
- https://support.apple.com/HT209448
- https://support.apple.com/HT209450
- https://support.apple.com/HT209451
- https://www.oracle.com/security-alerts/cpuapr2020.html
- https://lists.debian.org/debian-lts-announce/2020/08/msg00037.html
- https://kc.mcafee.com/corporate/index?page=content&id=SB10365
- https://launchpad.net/bugs/cve/CVE-2018-20346
- https://www.sqlite.org/releaselog/3_26_0.html
- https://www.sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigdefensive
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=1659677
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=1659363
- https://access.redhat.com/errata/RHSA-2018:3803
- https://www.sqlite.org/security.html
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=1659907
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=1659908
- https://www.sqlite.org/src/info/940f2adc8541a838
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=1659379#c27
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=1659379#c29
- https://access.redhat.com/security/cve/CVE-2018-20346
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=1659379#c12
- https://kc.mcafee.com/corporate/index?page=content&id=SB10365
- https://support.apple.com/en-us/HT209448 (Advisory)
- https://support.apple.com/en-us/HT209446 (Advisory)
- https://support.apple.com/en-us/HT209447 (Advisory)
- https://support.apple.com/en-us/HT209443 (Advisory)
- https://lists.fedoraproject.org/archives/list/package-announce%40lists.fedoraproject.org/message/PU4NZ6DDU4BEM3ACM3FM6GLEPX56ZQXK/
- https://www.mail-archive.com/sqlite-users%40mailinglists.sqlite.org/msg113218.html
- https://android.googlesource.com/platform/external/sqlite/+/18c26a364fe8979b5dbbd93a439c49b2db5d104c
- https://source.android.com/docs/security/bulletin/2019-03-01 (Advisory)
- https://src.fedoraproject.org/rpms/sqlite/c/d8da047b90b7eff583c50bf7fa7dc3bc37414249?branch=f28
- https://security-tracker.debian.org/tracker/CVE-2018-20346
- https://ubuntu.com/security/notices/USN-4019-1
- https://ubuntu.com/security/notices/USN-4019-2
- https://www.cve.org/CVERecord?id=CVE-2018-20346
- https://nvd.nist.gov/vuln/detail/CVE-2018-20346
- https://ubuntu.com/security/CVE-2018-20346
Parent vulnerabilities
(Appears in the following advisories)
Peer vulnerabilities
(Found alongside the following vulnerabilities)
- CVE-2018-20346
- CVE-2018-20505
- CVE-2018-20506
- CVE-2019-6215
- CVE-2019-6212
- CVE-2019-6216
- CVE-2019-6217
- CVE-2019-6226
- CVE-2019-6227
- CVE-2019-6233
- CVE-2019-6234
- CVE-2019-6229
- CVE-2019-8570
- CVE-2019-6235
- CVE-2019-6221
- CVE-2019-6202
- CVE-2019-6231
- CVE-2019-6230
- CVE-2019-6224
- CVE-2019-6214
- CVE-2019-6210
- CVE-2019-6213
- CVE-2019-6209
- CVE-2019-6219
- CVE-2019-6200
- CVE-2018-4467
- CVE-2018-4452
- CVE-2019-6225
- CVE-2019-6205
- CVE-2019-6208
- CVE-2019-6218
- CVE-2019-6220
- CVE-2019-6211
- CVE-2019-6206
- CVE-2019-6228
Frequently Asked Questions
What is the vulnerability ID?
CVE-2018-20346
What is the severity of CVE-2018-20346?
The severity of CVE-2018-20346 is high (8.1).
Which versions of SQLite are affected by CVE-2018-20346?
SQLite versions up to and exclusive of 3.25.3 are affected by CVE-2018-20346.
How can remote attackers exploit CVE-2018-20346?
Remote attackers can exploit CVE-2018-20346 by leveraging the ability to run arbitrary SQL statements after crafted changes to FTS3 shadow tables, resulting in arbitrary code execution.
Are there any fixes available for CVE-2018-20346?
The fixed version for CVE-2018-20346 is 3.25.3.
- collector/apple-support
- alias/CVE-2018-20505
- alias/CVE-2018-20506
- agent/first-publish-date
- agent/remedy
- collector/launchpad-cve
- source/Launchpad
- collector/redhat-bugzilla
- source/Red Hat
- alias/CVE-2018-20346
- agent/weakness
- agent/type
- collector/nvd-index
- agent/software-canonical-lookup-request
- agent/severity
- agent/author
- collector/nvd-cve
- source/NVD
- agent/software-canonical-lookup
- agent/description
- agent/event
- collector/android-source
- source/Android
- agent/last-modified-date
- agent/softwarecombine
- collector/usn-cve
- source/Ubuntu
- agent/references
- agent/tags
- collector/security-tracker-debian
- source/Debian
- vendor/apple
- canonical/apple icloud for windows
- canonical/apple itunes for windows
- vendor/sqlite
- canonical/sqlite sqlite
- vendor/google
- canonical/google chrome
- vendor/redhat
- canonical/redhat linux
- version/redhat linux/6.0
- vendor/debian
- canonical/debian debian linux
- version/debian debian linux/8.0
- vendor/opensuse
- canonical/opensuse leap
- version/opensuse leap/15.0
- version/opensuse leap/42.3
- canonical/apple watchos
- canonical/apple macos mojave
- canonical/apple high sierra
- canonical/apple sierra
- canonical/apple tvos
- canonical/apple ios
- canonical/google android
- package-manager/ubuntu
- package-manager/debian