{"schemaVersion":3,"id":"CVE-2022-3971","aliases":["GHSA-ffwf-47x2-jpr8"],"status":"published","duplicateOf":null,"title":null,"description":"A vulnerability was found in matrix-appservice-irc up to 0.35.1. It has been declared as critical. This vulnerability affects unknown code of the file src/datastore/postgres/PgDataStore.ts. The manipulation of the argument roomIds leads to sql injection. Upgrading to version 0.36.0 is able to address this issue. The name of the patch is 179313a37f06b298150edba3e2b0e5a73c1415e7. It is recommended to upgrade the affected component. VDB-213550 is the identifier assigned to this vulnerability.","dates":{"published":"2022-11-13T00:00:00.000Z","modified":"2025-04-15T13:15:03.625Z","reserved":null,"kevAdded":[],"kevDue":[]},"cvss":{"headline":{"score":5.6,"severity":"medium","version":"3.1","versionLabel":"v3.1","source":"NVD","vector":"CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:L/I:L/A:L","computed":false,"selection":"backend-summary"},"metrics":[{"version":"3.1","versionLabel":"v3.1","source":"CVE.org","score":4.6,"severity":"medium","vector":"CVSS:3.1/AV:A/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:L","exploitability":null,"impact":null,"computed":false},{"version":"3.1","versionLabel":"v3.1","source":"OSV · Npm","score":5.6,"severity":"medium","vector":"CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:L/I:L/A:L","exploitability":5.6,"impact":5.7,"computed":true},{"version":"3.1","versionLabel":"v3.1","source":"NVD","score":5.6,"severity":"medium","vector":"CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:L/I:L/A:L","exploitability":null,"impact":null,"computed":false}]},"epss":{"probability":0.00572,"percentile":0.46214,"severity":"low","asOf":"2026-10-19T00:00:00.000Z","change":{"pp":0.020000000000000052,"baselineDate":"2026-09-19T00:00:00.000Z","baselineScore":0.00552},"history":[{"date":"2026-09-14T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-15T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-16T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-17T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-18T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-19T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-20T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.00572,"percentile":0.46214}],"last30":[{"date":"2026-09-19T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-20T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.00552,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.00572,"percentile":0.46214}]},"kev":{"state":"not-listed","entries":[],"listedCount":0,"totalCatalogs":3,"catalogs":[{"source":"cisa","label":"CISA","listed":false,"entry":null},{"source":"enisa","label":"ENISA","listed":false,"entry":null},{"source":"circl","label":"CIRCL","listed":false,"entry":null}]},"ransomware":{"state":"none-recorded","sources":[]},"exploits":[],"exploitCount":0,"weaknesses":[{"id":"CWE-707","name":"Improper Neutralization","description":"The product does not ensure or incorrectly ensures that structured messages or data are well-formed and that certain security properties are met before being read from an upstream component or sent to a downstream component.","type":"weakness","status":"Incomplete","abstraction":"Pillar","likelihoodOfExploit":null,"url":"https://cwe.mitre.org/data/definitions/707.html"}],"affected":[{"vendor":"matrix","product":"matrix_irc_bridge","name":"matrix irc bridge","label":"matrix_irc_bridge","ecosystem":null,"cpePart":"a","purl":null,"purlType":null,"versions":[{"text":"≤ 0.36.0","noFixRecorded":false,"fixedIn":null}],"versionsText":"≤ 0.36.0","eol":null,"hubHref":"/vendor/matrix/matrix_irc_bridge"},{"vendor":"Npm","product":"matrix-appservice-irc","name":"matrix-appservice-irc","label":"matrix-appservice-irc","ecosystem":"Npm","cpePart":null,"purl":"pkg:npm/matrix-appservice-irc","purlType":"npm","versions":[{"text":"< 0.36.0","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 0.36.0","eol":null,"hubHref":null},{"vendor":"unspecified","product":"matrix-appservice-irc","name":"matrix-appservice-irc","label":"matrix-appservice-irc","ecosystem":null,"cpePart":"a","purl":null,"purlType":null,"versions":[{"text":"0.35.0","noFixRecorded":false,"fixedIn":null},{"text":"0.35.1","noFixRecorded":false,"fixedIn":null}],"versionsText":"0.35.0 | 0.35.1","eol":null,"hubHref":"/vendor/unspecified/matrix-appservice-irc"}],"affectedCount":3,"eol":{"hasEol":false,"count":0},"references":[{"url":"https://github.com/matrix-org/matrix-appservice-irc/pull/1619","label":"github.com/matrix-org/matrix-appservice-irc/pull/1619","hostname":"github.com","tags":["WEB","Patch","Third Party Advisory"]},{"url":"https://github.com/matrix-org/matrix-appservice-irc/releases/tag/0.36.0","label":"github.com/matrix-org/matrix-appservice-irc/releases/tag/0.36.0","hostname":"github.com","tags":["WEB","Release Notes","Third Party Advisory"]},{"url":"https://github.com/matrix-org/matrix-appservice-irc/commit/179313a37f06b298150edba3e2b0e5a73c1415e7","label":"github.com/matrix-org/matrix-appservice-irc/commit/179313a37f06b298150edba3e2b0e5a73c1415e7","hostname":"github.com","tags":["WEB","Patch","Third Party Advisory"]},{"url":"https://vuldb.com/?id.213550","label":"vuldb.com?id.213550","hostname":"vuldb.com","tags":["WEB","Third Party Advisory"]},{"url":"https://nvd.nist.gov/vuln/detail/CVE-2022-3971","label":"nvd.nist.gov/vuln/detail/CVE-2022-3971","hostname":"nvd.nist.gov","tags":["Advisory"]},{"url":"https://github.com/matrix-org/matrix-appservice-irc","label":"github.com/matrix-org/matrix-appservice-irc","hostname":"github.com","tags":["PACKAGE"]}],"lineage":{"upstream":[],"downstream":[],"duplicates":[],"related":[]},"timeline":[{"kind":"published","date":"2022-11-13T00:00:00.000Z","label":"Published","detail":"Vulnerability first disclosed.","source":null},{"kind":"modified","date":"2025-04-15T13:15:03.625Z","label":"Last modified","detail":"Vulnerability information updated.","source":null}],"risk":{"score":23,"level":"low","profile":"Default","thresholds":{"critical":75,"high":50,"medium":25,"low":10}},"meta":{"dataAsOf":"2026-10-20T04:53:18.566Z","stale":false,"partial":false}}