Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0046847Openbravo ERPA. Platformpublic2021-05-26 16:312022-02-02 16:39
Reportershuehner 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR21Q3 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0046847: Fix support for SCRAM authentication with PostgreSQL database by updating jdbc driver to version supporting it (again)
DescriptionIssue 44832 updated the jdbc driver to a version implementing scram authentication.

However that version used 42.2.16 has a bug where it fails when the password contains a space character.

That is fixed in version 42.2.19 so we should update the driver again to the latest version to include the bugfix.

https://jdbc.postgresql.org/ [^]
PostgreSQL JDBC Driver 42.2.19 Released
Now the driver uses SASLprep normalization for SCRAM authentication fixing some issues with spaces in passwords.
Steps To ReproduceSame as in 44832 just use a password with a space character i.e. for bbdd.password
Proposed SolutionUpdate jdbc driver to latest version (currently 42.2.20) but at least the .19 version containing the fix we need:
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0044832PR20Q4 closed cberner Support SCRAM authentication with PostgreSQL database by updating jdbc driver to version supporting it 
related to feature request 0046376 closed shuehner support PostgreSQL 14 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2021-05-26 16:31shuehnerNew Issue
2021-05-26 16:31shuehnerAssigned To => platform
2021-05-26 16:31shuehnerOBNetwork customer => No
2021-05-26 16:31shuehnerModules => Core
2021-05-26 16:31shuehnerTriggers an Emergency Pack => No
2021-05-26 16:31shuehnerRelationship addedrelated to 0044832
2021-05-26 16:31shuehnerRelationship addedrelated to 0046376
2021-05-26 16:32shuehnerNote Added: 0128678
2021-05-26 16:33shuehnerNote Added: 0128679
2021-06-07 09:05alostaleStatusnew => scheduled
2021-06-07 09:05alostaleAssigned Toplatform => alostale
2021-06-07 09:16hgbotMerge Request Status => open
2021-06-07 09:16hgbotNote Added: 0129117
2021-06-09 10:57hgbotNote Added: 0129229
2021-06-09 11:13hgbotNote Added: 0129241
2021-06-09 11:26hgbotNote Added: 0129247
2021-06-10 09:52hgbotMerge Request Statusopen => approved
2021-06-10 13:30hgbotResolutionopen => fixed
2021-06-10 13:30hgbotStatusscheduled => closed
2021-06-10 13:30hgbotFixed in Version => PR21Q3
2021-06-10 13:30hgbotNote Added: 0129332
2021-06-10 13:30hgbotNote Added: 0129333
2021-06-11 07:27hgbotNote Added: 0129373
2021-06-11 07:27hgbotNote Added: 0129374
2021-06-11 07:27hgbotNote Added: 0129375
2021-06-11 07:27hgbotNote Added: 0129376
2021-06-11 07:27hgbotNote Added: 0129377
2021-06-11 07:27hgbotNote Added: 0129378
2022-01-05 12:11hgbotNote Added: 0134133
2022-02-02 16:38shuehnerOBNetwork customerNo => OBPS
2022-02-02 16:38shuehnerNote Added: 0134735
2022-02-02 16:39shuehnerNote Deleted: 0134735

Notes
(0128678)
shuehner   
2021-05-26 16:32   
Note that the following change from 42.2.20 sounds like it could cause some compatibility issues potentially:

DatabaseMetaData.getTables returns columns in UPPER case as per the spec PR 0002092 fixes Issue 0000830

Needs to be tested also with dbsm
(0128679)
shuehner   
2021-05-26 16:33   
Note that upcoming pg14 release switched the password_encryption to SCRAM.
(0129117)
hgbot   
2021-06-07 09:16   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/379 [^]
(0129229)
hgbot   
2021-06-09 10:57   
Merge Request created: https://gitlab.com/openbravo/tools/platform/dependencies/-/merge_requests/3 [^]
(0129241)
hgbot   
2021-06-09 11:13   
Merge Request created: https://gitlab.com/openbravo/ci/mobile-test/-/merge_requests/103 [^]
(0129247)
hgbot   
2021-06-09 11:26   
Merge Request created: https://gitlab.com/openbravo/ci/backoffice-test/-/merge_requests/21 [^]
(0129332)
hgbot   
2021-06-10 13:30   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 370b8d40237bec9da8e7b59851fc8c6b0e3bb851
Author: Asier Lostalé <asier.lostale@openbravo.com>
Date: 2021-06-10T13:28:55+02:00
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/370b8d40237bec9da8e7b59851fc8c6b0e3bb851 [^]

fixes ISSUE-46847: PG SCRAM authentication issue in jdbc

Updates PostrgreSQL JDBC driver: 42.2.16 -> 42.2.20 (latest as of
today), which includes the fix for SCRAM authentication.

---
A lib/runtime/postgresql-42.2.20.jar
M legal/Licensing.txt
---
(0129333)
hgbot   
2021-06-10 13:30   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/379 [^]
(0129373)
hgbot   
2021-06-11 07:27   
Merge request merged: https://gitlab.com/openbravo/tools/platform/dependencies/-/merge_requests/3 [^]
(0129374)
hgbot   
2021-06-11 07:27   
Repository: https://gitlab.com/openbravo/tools/platform/dependencies [^]
Changeset: a48aaa033c7b5eed7c788b59e8abed20e74119aa
Author: Asier Lostalé <asier.lostale@openbravo.com>
Date: 2021-06-09T10:56:31+02:00
URL: https://gitlab.com/openbravo/tools/platform/dependencies/-/commit/a48aaa033c7b5eed7c788b59e8abed20e74119aa [^]

ISSUE-46847: PG JDBC update 42.2.16 -> 42.2.20

---
M build.gradle
---
(0129375)
hgbot   
2021-06-11 07:27   
Repository: https://gitlab.com/openbravo/ci/mobile-test [^]
Changeset: 472d0a8e10ce0f4de0691ae832bfc5e1b794bee9
Author: Asier Lostalé <asier.lostale@openbravo.com>
Date: 2021-06-09T11:12:02+02:00
URL: https://gitlab.com/openbravo/ci/mobile-test/-/commit/472d0a8e10ce0f4de0691ae832bfc5e1b794bee9 [^]

ISSUE-46847: PG JDBC update: 42.2.16 -> 42.2.20

---
A lib/runtime/choosables/postgresql-42.2.20.jar
M lib/runtime/postgresql-default.jar
---
(0129376)
hgbot   
2021-06-11 07:27   
Merge request merged: https://gitlab.com/openbravo/ci/mobile-test/-/merge_requests/103 [^]
(0129377)
hgbot   
2021-06-11 07:27   
Merge request merged: https://gitlab.com/openbravo/ci/backoffice-test/-/merge_requests/21 [^]
(0129378)
hgbot   
2021-06-11 07:27   
Repository: https://gitlab.com/openbravo/ci/backoffice-test [^]
Changeset: 8ac65be53185d56af903f165171a25e29384c985
Author: Asier Lostalé <asier.lostale@openbravo.com>
Date: 2021-06-09T11:24:23+02:00
URL: https://gitlab.com/openbravo/ci/backoffice-test/-/commit/8ac65be53185d56af903f165171a25e29384c985 [^]

ISSUE-46847: PG JDBC update: 42.2.16 -> 42.2.20

---
A lib/postgresql-42.2.20.jar
M .classpath.template
---
(0134133)
hgbot   
2022-01-05 12:11   
Repository: https://gitlab.com/openbravo/ci/backoffice-test [^]
Changeset: 8ac65be53185d56af903f165171a25e29384c985
Author: Asier Lostalé <asier.lostale@openbravo.com>
Date: 09-06-2021 11:24:23
URL: https://gitlab.com/openbravo/ci/backoffice-test/-/commit/8ac65be53185d56af903f165171a25e29384c985 [^]

ISSUE-46847: PG JDBC update: 42.2.16 -> 42.2.20

---
A lib/postgresql-42.2.20.jar
M .classpath.template
---