Bug #130644 for DBD-Pg: Postgres SHA-25 authentication issue

Fri Oct 04 10:51:58 2019 jlagarza [...] mosscm.com - Ticket created

Subject:	Postgres SHA-25 authentication issue
Date:	Fri, 4 Oct 2019 14:33:04 +0000
To:	"bug-DBD-Pg [...] rt.cpan.org" <bug-DBD-Pg [...] rt.cpan.org>
From:	Joycel Lagarza <jlagarza [...] mosscm.com>

Connecting to Postgres I get the following error: DBI connect('dbname=db;host=host;port=5432','user',...) failed: authentication method 10 not supported This is my connection string #connect to database my $dbh = DBI->connect("dbi:Pg:dbname=$dbname;host=$host;port=$port", $username, $password ); perl 5, version 24, subversion 0 (v5.24.0) built for MSWin32-x64-multi-thread DBD::Pg version 3.10.0

Fri Oct 04 12:09:54 2019 greg [...] turnstep.com - Correspondence added

That error is coming from libpq, not DBD::Pg itself. Can you verify that you are compiling DBD::Pg against a current libpq? Running the t/01_connect.t should show you that information: just run "make test" to see it.

Fri Oct 04 12:09:55 2019 The RT System itself - Status changed from 'new' to 'open'

Fri Oct 04 15:14:46 2019 jlagarza [...] mosscm.com - Correspondence added

Subject:	RE: [rt.cpan.org #130644] Postgres SHA-25 authentication issue
Date:	Fri, 4 Oct 2019 19:14:06 +0000
To:	"bug-DBD-Pg [...] rt.cpan.org" <bug-DBD-Pg [...] rt.cpan.org>
From:	Joycel Lagarza <jlagarza [...] mosscm.com>

Issue resolved for my case had to download latest lib files from pg v.12, install them in the C:\Strawberry\c\bin, then run the following commands in the directory:pexports libpq.dll > libpq.def dlltool -dllname libpq.dll --def libpq.def --output-lib ..\lib\libpq.a the files are the following: libiconv-2.dll libcrypto-1_1-x64.dll libpq.dll libssl-1_1-x64.dll libintl-8.dl Joycel Lagarza Systems Developer II Moss Direct: 954.769.8321 | Office: 954.769.8448 mosscm.com Show quoted text

-----Original Message----- From: Greg Sabino Mullane via RT <bug-DBD-Pg@rt.cpan.org> Sent: Friday, October 04, 2019 12:10 PM To: Joycel Lagarza <jlagarza@mosscm.com> Subject: [rt.cpan.org #130644] Postgres SHA-25 authentication issue CAUTION: This email originated from outside of Moss. Be careful of any attachments or links that ask for your password. <URL: https://urldefense.proofpoint.com/v2/url?u=https-3A__rt.cpan.org_Ticket_Display.html-3Fid-3D130644&d=DwIDaQ&c=5Npu7sU1o1eHaxSLMZ-pkg&r=wInKohKCGCqHepGw1_mLf8ReoZIyxG2aRATT_JCn_FE&m=bRWUzEOg7rpPJWhroERtU7k9mU2uBv37J6uM6-yd79o&s=IZS3CZ13l7UTPdFMkgM6piR2-hOAQJshSma-CuuxPbI&e= > That error is coming from libpq, not DBD::Pg itself. Can you verify that you are compiling DBD::Pg against a current libpq? Running the t/01_connect.t should show you that information: just run "make test" to see it.

Mon Oct 07 09:12:31 2019 greg [...] turnstep.com - Status changed from 'open' to 'resolved'

Mon Oct 07 09:13:35 2019 greg [...] turnstep.com - Correspondence added

Glad you got it to work!