Support for scram-sha-256 (/ the latest version of PostgreSQL)

Suggestion shared 1 year, 11 months ago by Tom McQuillan

Related Packages: PostgreSQL Library

Details

Hi James,
I don't know if you're still supporting this library, but it would be great if scram-sha-256 authentication support was added so your toolkit can be used with the latest version of PostgreSQL.

When trying to connect to new DBs using the latest version of PostgreSQL we get the following error message: CONNECTION_BAD: authentication method 10 not supported. After a quick Google it seems to be caused by the new password encryption.

Comments

Tom McQuillan Just an update, I just replaced the libPQ library on disk (and the DLLs it's dependent on) and it "just worked"!

• Reply • 1 year

kaviyarasi . Hi TOM gr8 info..what other dlls you replaced other than libPQ

• Reply • 7 months

kaviyarasi . do you i have to dowload older versions of dll and replace

• Reply • 7 months

kaviyarasi . Now it works for me ..Just loaded the libpq.dll from PostGres16.0.0 binariy download..Thanks Tom and Powel.

• Reply • 7 months

Eric Stach For others who find this: I tried this with 16.4 Postgres and 32-bit LabVIEW 2024. Ran into issues with the Postgres DLLs being 64 bit. I just downgraded password encryption to md5 using the toolkit DLLs and it works. I haven't tried but, scram encryption and the Postgres DLLs might work with 64-bit LabVIEW?

• Reply • 3 weeks

Please sign in to leave a comment.