sql-fundamentals
sql-fundamentals copied to clipboard

Published 20 hours ago •

Reame
Issues

chore(deps): update dependency mysql2 to v3 [security]

Open renovate[bot] opened this issue 1 year ago • 2 comments

This PR contains the following updates:

Package	Change	Age	Adoption	Passing	Confidence
mysql2 (source)	`1.7.0` -> `3.9.8`

GitHub Vulnerability Alerts

CVE-2024-21507

Versions of the package mysql2 before 3.9.3 are vulnerable to Improper Input Validation through the keyFromFields function, resulting in cache poisoning. An attacker can inject a colon : character within a value of the attacker-crafted key.

CVE-2024-21509

Versions of the package mysql2 before 3.9.4 are vulnerable to Prototype Poisoning due to insecure results object creation and improper user input sanitization passed through parserFn in text_parser.js and binary_parser.js.

CVE-2024-21508

Versions of the package mysql2 before 3.9.4 are vulnerable to Remote Code Execution (RCE) via the readCodeFor function due to improper validation of the supportBigNumbers and bigNumberStrings values.

CVE-2024-21511

Versions of the package mysql2 before 3.9.7 are vulnerable to Arbitrary Code Injection due to improper sanitization of the timezone parameter in the readCodeFor function by calling a native MySQL Server date/time function.

CVE-2024-21512

Versions of the package mysql2 before 3.9.8 are vulnerable to Prototype Pollution due to improper user input sanitization passed to fields and tables when using nestTables.

Release Notes

sidorares/node-mysql2 (mysql2)

`v3.9.8`

Bug Fixes

security: sanitize fields and tables when using nestTables (#2702) (efe3db5)
support deno + caching_sha2_password FULL_AUTHENTICATION_PACKET flow (#2704) (2e03694)
typings: typo from jonServerPublicKey to onServerPublicKey (#2699) (8b5f691)

`v3.9.7`

Bug Fixes

security: sanitize timezone parameter value to prevent code injection (#2608) (7d4b098)

`v3.9.6`

Bug Fixes

binary parser sometimes reads out of packet bounds when results contain null and typecast is false (#2601) (705835d)

`v3.9.5`

Bug Fixes

revert breaking change in results creation (#2591) (f7c60d0)

`v3.9.4`

Bug Fixes

docs: improve the contribution guidelines (#2552) (8a818ce)
security: improve results object creation (#2574) (4a964a3)
security: improve supportBigNumbers and bigNumberStrings sanitization (#2572) (74abf9e)

`v3.9.3`

Bug Fixes

security: improve cache key formation (#2424) (0d54b0c)
- Fixes a potential parser cache poisoning attack vulnerability reported by Vsevolod Kokorin (Slonser) of Solidlab
update Amazon RDS SSL CA cert (#2131) (d9dccfd)

`v3.9.2`

Bug Fixes

stream: premature close when it is paused (#2416) (7c6bc64)
types: expose TypeCast types (#2425) (336a7f1)

`v3.9.1`

Bug Fixes

types: support encoding for string type cast (#2407) (1dc2011)

`v3.9.0`

Features

introduce typeCast for execute method (#2398) (baaa92a)

`v3.8.0`

Features

perf: cache iconv decoder (#2391) (b95b3db)

Bug Fixes

stream: premature close when using for await (#2389) (af47148)
The removeIdleTimeoutConnectionsTimer did not clean up when the … (#2384) (18a44f6)
types: add missing types to TypeCast (#2390) (78ce495)

`v3.7.1`

Bug Fixes

add condition which allows code in callback to be reachable (#2376) (8d5b903)

`v3.7.0`

Features

docs: release documentation website (#2339) (c0d77c0)

`v3.6.5`

Bug Fixes

add decodeuricomponent to parse uri encoded special characters in host, username, password and datbase keys (#2277) (fe573ad)

`v3.6.4`

Bug Fixes

malformed FieldPacket (#2280) (8831e09)
move missing options to ConnectionOptions (#2288) (5cd7639)

`v3.6.3`

Bug Fixes

correctly pass values when used with sql-template-strings library (#2266) (6444f99)

`v3.6.2`

Bug Fixes

sql-template-strings/tag compatibility (#2238) (f2efe5a)

`v3.6.1`

Bug Fixes

EventEmitter on method signatures to use spread syntax (#2200) (5d21b81)

`v3.6.0`

Features

add conn-level infileStreamFactory option (#2159) (5bed0f8)

`v3.5.2`

Bug Fixes

Update events that are propagated from pool cluster to include remove (#2114) (927d209)

`v3.5.1`

Bug Fixes

improvements to allow to use Bun and tls (#2119) (fd44a2a)
missing ResultSetHeader[] to query and execute (f649486)

`v3.5.0`

Features

improved inspection of columns (#2112) (69277aa)

`v3.4.5`

Bug Fixes

handle prepare response with actual number of parameter definition less than reported in the prepare header. Fixes #2052 (b658be0)

`v3.4.4`

Bug Fixes

add ProcedureCallPacket to execute overloads (3566ef7)
add ProcedureCallPacket to query overloads (352c3bc)
add ProcedureCallPacket to promise-based execute overloads (8292416)
add ProcedureCallPacket to promise-based query overloads (0f31a41)
create ProcedureCallPacket typings (09ad1d2)

`v3.4.3`

Bug Fixes

remove acquireTimeout invalid option (#2095) (eb311db)

`v3.4.2`

Bug Fixes

changing type files to declaration type files (98e6f3a)

`v3.4.1`

Bug Fixes

createPool uri overload (98623dd)
PoolCluster typings (3902ca6)
create promise-based PoolCluster typings (7f38496)
missing parserCache in promise.js (7f35cf5)
missing constants in promise.js (4ce2c70)
missing keys for Types constant (86655ec)
missing typings for Charsets constants (01f77a0)
missing typings for CharsetToEncoding constants (609229a)
missing typings for parserCache (891a523)
missing typings for Types constant (04601dd)
rename file of typings Charsets constants (51c4196)

`v3.4.0`

Features

support STATE_GTIDS session track information (2b1520f)

`v3.3.5`

Bug Fixes

createPool promise as PromisePool (#2060) (ff3c36c)
keepAliveInitialDelay not taking effect (#2043) (585911c)

`v3.3.4`

Bug Fixes

PromisePoolConnection import name (76db54a)
releaseConnection types and promise (4aac9d6)

`v3.3.3`

Bug Fixes

add package.json to exports (#2026) (09fd305)

`v3.3.2`

Bug Fixes

respect enableKeepAlive option (#2016) (f465c3e)

`v3.3.1`

Bug Fixes

LRU constructor (#2004) (fd3d117)
Missing types in "mysql" import (#1995) (b8c79d0)

`v3.3.0`

Features

Added updated/new error codes gathered from MySQL 8.0 source code (#1990) (85dc6e5)

`v3.2.4`

Bug Fixes

server: Added missing encoding argument to server-handshake (#1976) (a4b6b22)

`v3.2.3`

Bug Fixes

types: add decimalNumbers to createConnection/createPool typings. fixes #1803 (#1817) (bb48462)

`v3.2.2`

Bug Fixes

ConnectionOptions conflict between mysql and mysql/promise (#1955) (eca8bda)

`v3.2.1`

Bug Fixes

Add typings for Connection.promise(). (#1949) (e3ca310)
PoolConnection redundancy when extending Connection interface in TypeScript (7c62d11)

`v3.2.0`

Features

maxVersion ssl option to tls.createSecureContext (0c40ef9)

`v3.1.2`

Bug Fixes

update lru-cache reset method to clear (114f266)

`v3.1.1`

Bug Fixes

remove accidental log in caching_sha2_password.js (c1202b6)

`v3.1.0`

Features

cleanup buffer/string conversions in hashing/xor helpers that were failing in Bun (a2392e2)

Bug Fixes

when port is pased as a string convert it to a number (Bun's net.connect does not automatically convert this) (703ecb2)

`v3.0.1`

Miscellaneous Chores

release 3.0.1 (d5a6b2c)

`v3.0.0`

named-placeholders library is updated to use newer lru-cache dependency, allowing it do dedupe and be shared between mysql2 and named-placeholders - https://github.com/sidorares/node-mysql2/issues/1711, https://github.com/mysqljs/named-placeholders/pull/19
chai and mocha moved to devDependencies #1774
Amazon RDS ssl certificates updated including AWS China #1754
TCP_NODELAY flag enabled, avoiding long connect timeout in some scenarios #1751
typing improvements: #1675, #1674
fix: ensure pooled connections get released #1666

Miscellaneous Chores

release 3.0.0 (11692b2)

`v2.3.3`

`v2.3.2`

`v2.3.1`

`v2.3.0`

`v2.2.5`

`v2.2.4`

`v2.2.3`

`v2.2.2`

`v2.2.1`

`v2.2.0`

`v2.1.0`

`v2.0.2`

`v2.0.1`

`v2.0.0`

Configuration

📅 Schedule: Branch creation - "" (UTC), Automerge - At any time (no schedule defined).

🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.

♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.

🔕 Ignore: Close this PR and you won't be reminded about this update again.

[ ] If you want to rebase/retry this PR, check this box

This PR was generated by Mend Renovate. View the repository job log.

Apr 12 '24 14:04 renovate[bot]

⚠ Artifact update problem

Renovate failed to update an artifact related to this branch. You probably do not want to merge this PR as-is.

♻ Renovate will retry this branch, including artifacts, only when one of the following happens:

any of the package files in this branch needs updating, or
the branch becomes conflicted, or
you click the rebase/retry checkbox if found above, or
you rename this PR's title to start with "rebase!" to trigger it manually

The artifact failure details are included below:

File name: yarn.lock

[23:16:13.925] INFO (64): Installing tool [email protected]...
[23:16:21.873] WARN (64): Npm error:
npm ERR! weird error 1
[23:16:21.880] FATAL (64): node-gyp update command failed
    err: {
      "type": "Error",
      "message": "node-gyp update command failed",
      "stack":
          Error: node-gyp update command failed
              at InstallNodeService.updateNodeGyp (/snapshot/dist/containerbase-cli.js:53540:13)
              at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
              at async InstallNodeService.install (/snapshot/dist/containerbase-cli.js:53797:7)
              at async InstallToolService.execute (/snapshot/dist/containerbase-cli.js:54326:11)
              at async InstallToolShortCommand.execute (/snapshot/dist/containerbase-cli.js:54543:14)
              at async InstallToolShortCommand.validateAndExecute (/snapshot/dist/containerbase-cli.js:2430:26)
              at async _Cli.run (/snapshot/dist/containerbase-cli.js:3543:22)
              at async _Cli.runExit (/snapshot/dist/containerbase-cli.js:3551:28)
              at async main (/snapshot/dist/containerbase-cli.js:54737:3)
    }
[23:16:22.012] INFO (64): Installed tool node with errors in 8s.

Apr 12 '24 14:04 renovate[bot]

⚠️ Artifact update problem

Renovate failed to update an artifact related to this branch. You probably do not want to merge this PR as-is.

♻ Renovate will retry this branch, including artifacts, only when one of the following happens:

any of the package files in this branch needs updating, or
the branch becomes conflicted, or
you click the rebase/retry checkbox if found above, or
you rename this PR's title to start with "rebase!" to trigger it manually

The artifact failure details are included below:

File name: yarn.lock

[19:25:47.822] INFO (66): Installing tool [email protected]...
[19:25:58.215] WARN (66): Npm error:
npm ERR! weird error 1
[19:25:58.220] FATAL (66): node-gyp update command failed
    err: {
      "type": "Error",
      "message": "node-gyp update command failed",
      "stack":
          Error: node-gyp update command failed
              at InstallNodeService.updateNodeGyp (/snapshot/dist/containerbase-cli.js:51593:13)
              at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
              at async InstallNodeService.install (/snapshot/dist/containerbase-cli.js:51853:7)
              at async InstallToolService.execute (/snapshot/dist/containerbase-cli.js:52399:11)
              at async InstallToolShortCommand.execute (/snapshot/dist/containerbase-cli.js:52617:14)
              at async InstallToolShortCommand.validateAndExecute (/snapshot/dist/containerbase-cli.js:2428:26)
              at async _Cli.run (/snapshot/dist/containerbase-cli.js:3541:22)
              at async _Cli.runExit (/snapshot/dist/containerbase-cli.js:3549:28)
              at async main (/snapshot/dist/containerbase-cli.js:52811:3)
    }
[19:25:58.991] INFO (66): Installed tool node with errors in 11.1s.

May 30 '24 19:05 renovate[bot]