Fork me on GitHub
#datomic
<
2022-06-13
>
cjohansen08:06:03

What version of the Postgresql driver does the latest onprem transactor use? I’m having trouble connecting the transactor to a Postgres 14 instance: “PSQLException: The authentication type 10 is not supported”. I’m no postgres expert, but I think that this means that the client (the transactor) isn’t capable of scram-sha-256 authentication, is that correct?

Ivar Refsdal11:06:05

Version 9.3-1102 as far as I can tell:

$ unzip -l datomic-pro-1.0.6397.zip | grep postgresql
   592322  2022-04-01 21:54   datomic-pro-1.0.6397/lib/postgresql-9.3-1102-jdbc41.jar

cjohansen11:06:26

Right, thanks 👍

cjohansen11:06:39

I ended up using md5 passwords in postgres and got things working

cjohansen11:06:51

But it would be nice to be able to use scram

👍 1
JohnJ17:06:52

you can swap out the driver for the latest one

Joe Lane12:06:16

@U9MKYDN4Q JohnJ is right, you can swap the driver for a newer one. If you are using the PG Setup script packaged w/ Datomic and targeting Postgres 14 you may need to modify it. IIRC there was a change made in Postgres 14 which our script hasn't yet been updated for. If you're aware of using scram-sha-256 auth I'm sure you'll be able to figure out how to modify the script to accomplish your needs. Hope that helps

cjohansen12:06:23

Thanks! I ended up changing the password mechanism in psql, which was the least effort at this point 🙂

Joe Lane12:06:12

please reach out if you have other questions, have fun!