search

dbacvetkov / PASH-Viewer

PostgreSQL ASH Viewer (PASH Viewer) provides graphical view of active session history data within the PostgreSQL database
GNU General Public License v3.0
120 stars 18 forks source link

SCRAM authentication #13

Open stedliu opened 2 years ago

stedliu commented 2 years ago

Is SCRAM authentication supported by PASH-Viewer? My JDK is 11.0.12. I don't think I have control of the pgjdbc version.

C:\PASH\PASH-Viewer-0.4.2\PASH-Viewer-0.4.2\bin>PASH-Viewer.bat SQL Exception occured while connection pool initialize: SCRAM authentication is not supported by this driver. You need JDK >= 8 and pgjdbc >= 42.2.0 (not ".jre" vesions)

C:\PASH\PASH-Viewer-0.4.2\PASH-Viewer-0.4.2\bin>java --version java 11.0.12 2021-07-20 LTS Java(TM) SE Runtime Environment 18.9 (build 11.0.12+8-LTS-237) Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.12+8-LTS-237, mixed mode)

portnov commented 2 years ago

This particular issue I've worked around by simply downloading newer postgresql jdbc driver (jar file) and replacing the reference to driver file in the bat / shell script.

Haric110 commented 1 year ago

Yes, it is JDK version used in postgresql jdbc driver library. But in newer versions of this library there is new other issue #17 with nullPointerException on getting connection from the connection pool.