Version of PostgresSQL JDBC driver

2,811 views
Skip to first unread message

Francoi...@dti.ulaval.ca

unread,
Sep 26, 2018, 1:54:54 PM9/26/18
to obiba-users
We installed Opal 2.11.2 on a PostgresSQL v10.4 database.

By default, we use a SRAM-SHA-256 authentication instead of MD5. However, when Opal tries to get a connection, we get the following exception:

Caused by: org.postgresql.util.PSQLException: The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver.

The PostgresSQL JDBC driver version included with Opal is quite old (v9.4.0 released in 2015). We worked around this problem by replacing the driver file (postgresql-9.4-1202-jdbc42.jar) with a more recent one (postgresql-42.2.4.jar).

Would it be possible to update the JDBC driver of the Opal installation package within the next releases of Opal?

Thanks,

Yannick Marcon

unread,
Sep 26, 2018, 1:58:31 PM9/26/18
to obiba...@googlegroups.com
Hi,

Thanks for the report. We will include the new driver in opal 2.12 that is due in the next days.

Best
Yannick

--
You received this message because you are subscribed to the Google Groups "obiba-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to obiba-users...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages