CVE-2022-41946 (Markdown, published 2022-11-23T20:15Z)
Description: value: pgjdbc is an open source postgresql JDBC Driver. In affected versions a prepared statement using either `PreparedStatement.setText(int, InputStream)` or `PreparedStatemet.setBytea(int, InputStream)` will create a temporary file if the InputStream is larger than 2k. This will create a temporary file which is readable by other users on Unix like systems, but not MacOS. On Unix like systems, the system's temporary directory is shared between all users on that system. Because of this, when files and directories are written into this directory they are, by default, readable by other users on that same system. This vulnerability does not allow other users to overwrite the contents of these directories or files. This is purely an information disclosure vulnerability. Because certain JDK file system APIs were only added in JDK 1.7, this this fix is dependent upon the version of the JDK you are using. Java 1.7 and higher users: this vulnerability is fixed in 4.5.0. Java 1.6 and lower users: no patch is available. If you are unable to patch, or are stuck running on Java 1.6, specifying the java.io.tmpdir system environment variable to a directory that is exclusively owned by the executing user will mitigate this vulnerability.
Severity: nan (CVSS v3 base score: 5.5)
Weakness: CWE-668 \u2014 Exposure of Resource to Wrong Sphere
The product exposes a resource to the wrong control sphere, providing unintended actors with inappropriate access to the resource.
Repository: https://github.com/pgjdbc/pgjdbc
Files changed:
CHANGELOG.md
contributors.json
docs/content/changelogs/2022-11-21-42.5.1-release.md
docs/data/homepagedata.toml
docs/data/versions.toml
docs/layouts/partials/home/info.html
pgjdbc/src/main/java/org/postgresql/util/StreamWrapper.java
Commit message: Merge pull request from GHSA-562r-vg33-8x8h

* Fix: createTempFile vulnerability on unix like systems where temporary files can be read by other users on the system

* Update site with change logs and new version information

Vulnerable code:
[Unreleased]: https://github.com/pgjdbc/pgjdbc/compare/REL42.5.0...HEAD
   "Sasa Vilic" : "sasavilic@gmail.com"
date = "09 JUne 2022"
version= "42.5.0"
url= "/download/postgresql-42.5.0.jar"
version= "42.2.26"
url= "/download/postgresql-42.2.26.jre7.jar"
version= "42.2.26"
url= "/download/postgresql-42.2.26.jre6.jar"
v_name= "Postgresql JDBC 42.4.0"
version= "42.4.0"
url= "/download/postgresql-42.4.0.jar"
v_name= "Postgresql JDBC 42.3.6"
version= "42.3.6"
url= "/download/postgresql-42.3.6.jar"
v_name= "Postgresql JDBC 42.3.5"
version= "42.3.5"
url= "/download/postgresql-42.3.5.jar"
[[past]]
v_name= "Postgresql JDBC 42.3.4"
version= "42.3.4"
suffix=""
url= "/download/postgresql-42.3.4.jar"
            pgJDBC has released v42.5.0 on 24 August, 2022. Please see the release notes below.
        final File tempFile = File.createTempFile(TEMP_FILE_PREFIX, null);

Fixed code:
[42.5.1] (2022-11-21 15:21:59 -0500)
### Security
- security: StreamWrapper spills to disk if setText, or setBytea sends very large Strings or arrays to the server. createTempFile creates a file which can be read by other users on unix like systems (Not macos).
This has been fixed in this version fixes CVE-2022-41946 see the [security advisory](https://github.com/pgjdbc/pgjdbc/security/advisories/GHSA-562r-vg33-8x8h) for more details. Reported by [Jonathan Leitschuh](https://github.com/JLLeitschuh) This has been fixed in versions 42.5.1, 42.4.3 42.3.8, 42.2.27.jre7. Note there is no fix for 42.2.26.jre6. See the security advisory for work arounds.

### Fixed

- fix: make sure we select array_in from pg_catalog to avoid duplicate array_in functions fixes [#Issue 2548](https://github.com/pgjdbc/pgjdbc/issues/2548) [PR #2552](https://github.com/pgjdbc/pgjdbc/issues/2552)
- fix: binary decoding of bool values [PR #2640](https://github.com/pgjdbc/pgjdbc/pull/2640)
- perf: improve performance of PgResultSet getByte/getShort/getInt/getLong for float-typed columns [PR #2634](https://github.com/pgjdbc/pgjdbc/pull/2634)
- chore: fix various spelling errors [PR #2592](https://github.com/pgjdbc/pgjdbc/pull/2592)
- chore: Feature/urlparser improve URLParser [PR #2641](https://github.com/pgjdbc/pgjdbc/pull/2592)

[42.5.0]: https://github.com/pgjdbc/pgjdbc/compare/REL42.5.0...REL42.5.1
[Unreleased]: https://github.com/pgjdbc/pgjdbc/compare/REL42.5.1...HEAD
   "Sasa Vilic" : "sasavilic@gmail.com",
   "Evgeniy Devyatykh" : "devyatyh@gmail.com",
   "Josh Soref" : "2119212+jsoref@users.noreply.github.com",
   "Kevin222004" : "kevinpatel222004@gmail.com",
   "Knut Olav Løite" : "koloite@gmail.com",
   "μtkarsh" : "61664827+utkar-sh-ukla@users.noreply.github.com"
---
title:  PostgreSQL JDBC Driver 42.5.1 Released
date:   2022-11-21 15:21:47 -0500
categories:
    - new_release
version: 42.5.1
---
**Notable changes**

### Security
- security: StreamWrapper spills to disk if setText, or setBytea sends very large Strings or arrays to the server. createTempFile creates a file which can be read by other users on unix like systems (Not macos).\
This has been fixed in this version fixes CVE-2022-41946 see the [security advisory](https://github.com/pgjdbc/pgjdbc/security/advisories/GHSA-562r-vg33-8x8h) for more details.\
Reported by [Jonathan Leitschuh](https://github.com/JLLeitschuh)\
This has been fixed in versions 42.5.1, 42.4.3 42.3.8, 42.2.27.jre7.\
**Note** there is no fix for 42.2.26.jre6. See the security advisory for work arounds.

### Fixed

- fix: make sure we select array_in from pg_catalog to avoid duplicate array_in functions fixes [#Issue 2548](https://github.com/pgjdbc/pgjdbc/issues/2548) [PR #2552](https://github.com/pgjdbc/pgjdbc/issues/2552)
- fix: binary decoding of bool values [PR #2640](https://github.com/pgjdbc/pgjdbc/pull/2640)
- perf: improve performance of PgResultSet getByte/getShort/getInt/getLong for float-typed columns [PR #2634](https://github.com/pgjdbc/pgjdbc/pull/2634)
- chore: fix various spelling errors [PR #2592](https://github.com/pgjdbc/pgjdbc/pull/2592)
- chore: Feature/urlparser improve URLParser [PR #2641](https://github.com/pgjdbc/pgjdbc/pull/2592)


<!--more-->

**Commits by author**

Dave Cramer (13):
  Update README.md [PR 2609](https://github.com/pgjdbc/pgjdbc/pull/2609)\
  Ignore simplequery for postgresql 8.4 [PR 2614](https://github.com/pgjdbc/pgjdbc/pull/2614)\
  Single commit to move newdocs into master [PR 2618](https://github.com/pgjdbc/pgjdbc/pull/2618)\
  update versions [PR 2619](https://github.com/pgjdbc/pgjdbc/pull/2619)\
  fix grammar, fix downloads, minor edits [PR 2626](https://github.com/pgjdbc/pgjdbc/pull/2626)\
  fix: make sure we select array_in from pg_catalog to avoid duplicate array_in functions fixes #Issue 2548 [PR 2552](https://github.com/pgjdbc/pgjdbc/pull/2552)\
  clarify prepared statement usage [PR 2629](https://github.com/pgjdbc/pgjdbc/pull/2629)\
  fix maven coordinates [PR 2631](https://github.com/pgjdbc/pgjdbc/pull/2631)\
  remove javadoc links for java 17 and above [PR 2637](https://github.com/pgjdbc/pgjdbc/pull/2637)\
  revert change to PGProperty.get() to keep the API the same [PR 2644](https://github.com/pgjdbc/pgjdbc/pull/2644)\
  exclude ArrayTest versions less than 9.1 [PR 2645](https://github.com/pgjdbc/pgjdbc/pull/2645)\

Evgeniy Devyatykh (1):
      perf: improve performance of PgResultSet getByte/getShort/getInt/getLong for float-typed columns [PR 2634](https://github.com/pgjdbc/pgjdbc/pull/2634)

Josh Soref (1):
      chore: fix various spelling errors [PR 2592](https://github.com/pgjdbc/pgjdbc/pull/2592)

Kevin222004 (1):

Knut Olav Løite (1):
      fix: binary decoding of bool values [PR 2640](https://github.com/pgjdbc/pgjdbc/pull/2640)

Marek Läll (1):
      Feature/urlparser improve3 pr1 [PR 2641](https://github.com/pgjdbc/pgjdbc/pull/2641)

Vladimir Sitnikov (4):
      docs: clarify we ship security fixes by default for the latest 42.x and 42.2 only [PR 2586](https://github.com/pgjdbc/pgjdbc/pull/2586)

μtkarsh (1):
      Optimize png files [PR 2621](https://github.com/pgjdbc/pgjdbc/pull/2621)


    
[[info]]
date = "21 October 2022"
url = "/changelogs/2022-11-21-42.5.1-release/"
version = "42.5.1"

date = "09 June 2022"
version= "42.5.1"
url= "/download/postgresql-42.5.1.jar"
version= "42.2.27"
url= "/download/postgresql-42.2.27.jre7.jar"
version= "42.2.27"
url= "/download/postgresql-42.2.27.jre6.jar"
v_name= "Postgresql JDBC 42.5.0"
version= "42.5.0"
url= "/download/postgresql-42.5.0.jar"
v_name= "Postgresql JDBC 42.4.2"
version= "42.4.2"
url= "/download/postgresql-42.4.2.jar"
v_name= "Postgresql JDBC 42.3.7"
version= "42.3.7"
url= "/download/postgresql-42.3.7.jar"
            pgJDBC has released v42.5.1 on 21 October, 2022. This is a security release which fixes CVE-2022-41946 
            see <a href="https://github.com/pgjdbc/pgjdbc/security/advisories/GHSA-562r-vg33-8x8h" >Security Advisory</a>
            for details
import java.nio.file.Files;
        final File tempFile = Files.createTempFile(TEMP_FILE_PREFIX, null).toFile();