Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sZvCn-005Fwf-EM for pgsql-general@arkaria.postgresql.org; Fri, 02 Aug 2024 16:32:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sZvCl-001mdP-BM for pgsql-general@arkaria.postgresql.org; Fri, 02 Aug 2024 16:32:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sZvCk-001mdE-V7 for pgsql-general@lists.postgresql.org; Fri, 02 Aug 2024 16:32:35 +0000 Received: from mail-yb1-xb2e.google.com ([2607:f8b0:4864:20::b2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sZvCi-002nkK-Mz for pgsql-general@lists.postgresql.org; Fri, 02 Aug 2024 16:32:34 +0000 Received: by mail-yb1-xb2e.google.com with SMTP id 3f1490d57ef6-e0b286b922eso6262503276.1 for ; Fri, 02 Aug 2024 09:32:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1722616351; x=1723221151; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Y0ii+3i6LaxInoLosFnLcV34nfprF2sRDmEAOjK+NDg=; b=BLgCfC8kHVHt2jGA7DeuDLK2uN9XLfBMTVhIUuF21lbUbwf8DfP579j1MqYQJ4tYum dncZ7Qh8l+Ko2TSjuLl8ThUuhK9mLYnVLQ2Fz6e8Z/4gtNsyItTBQ2juAq9CpwMtZyr4 T+XFFoT/2TzqemFCsWRedy8f7FKYtVchte4f7e3fGLRCAxo1kJ1PugdwONhZZ9CzKL0t 6R/qdmbascpdsdf+8BkE3DNq38WpygcCIcypokSC2+e9AWePn1B6+YCWVljuaoHM++kN /Kb+tmfZHNcrZdZY7ws7URaw0oBDq/FNStYsZdnudPB7tpjK1pK0lGlleNtiRz/FvB2W xiZg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1722616351; x=1723221151; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Y0ii+3i6LaxInoLosFnLcV34nfprF2sRDmEAOjK+NDg=; b=vMm0ciyRdocIPjp+mlCAOau1p/jucO1M766MLMk4rx812J+ZBq7UGd/fuep+0x2vW6 271j+9joOAIFRkIn4OsQyRxOAN+M2VHXqoRvc3SlhmiTuuEtB12YdlLrsDwvKx2aKqgt 11uLA1MZb3EgJlpoI3CdabKLpyS9xnnD2vyb8OnzCS7lHbh+kxHORO3iIysIWRYvtdy1 hbRpScIrOK3umN5LwMhAJW/e/r6+V6k6IQ0ryfOHrZIXYlcQN29JkE+ciqfAdVQJIw6j SvmuZ3b44eZLhGvFxAJPeR2OzBef9XW/21qAtefaYUJaBQLUGTyG0qylxuO09Z/2xl0G 45jg== X-Gm-Message-State: AOJu0YxiNwMTL8VPvLUKlKrETChTvZ/UBquqJixNH3pbgC+98zdLE4/T w4NQL30QtIfXTKZlostii671c1vMK9rohw+mm/QwCLgFMwLH1WMFrUOX+RrC3eLIRFAFH/hdLPI qcktIbpWcv86861qpswl8/z8RFP/iOQ== X-Google-Smtp-Source: AGHT+IGseeKwXAD7lsn/P2hSY+HwY2g3rW3b1Oj8Qi6Dn6xWuJ8PhwQ864BgDEAR6D0RD/e6flleFqend3UFrX+k0DE= X-Received: by 2002:a25:361b:0:b0:e0b:a2d1:3526 with SMTP id 3f1490d57ef6-e0bde33fa18mr4861419276.32.1722616350996; Fri, 02 Aug 2024 09:32:30 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Andy Hartman Date: Fri, 2 Aug 2024 12:32:19 -0400 Message-ID: Subject: Re: Connection Issue To: Adrian Klaver Cc: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000af82bc061eb5df9a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000af82bc061eb5df9a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable How can I tell that? Thanks. On Fri, Aug 2, 2024 at 12:18=E2=80=AFPM Adrian Klaver wrote: > > > On 8/2/24 9:00 AM, Andy Hartman wrote: > Reply to list also. > Ccing list. > > I changed to md5 and I can connect via HeideSQL interface no problem > > Changed what to md5? > > The issue is with Npgsql(?) though. > > What is the Npgsql version? > > > > > On Fri, Aug 2, 2024 at 11:05=E2=80=AFAM Adrian Klaver > > wrote: > > > > On 8/2/24 07:56, Andy Hartman wrote: > > > I'm using a Powershell script to connect to a remote 16.3(window= s) > > > version of the DB. > > > > > > Add-type -path 'C:\Program Files > > > (x86)\PostgreSQL\Npgsql\bin\net451\Npgsql.dll' > > > > > > # Define connection strings for MS SQL and PostgreSQL > > > $pgsqlConnectionString =3D > > > "Host=3Dxxxxxx;Port=3D5432;Username=3Dxxx;Password=3Dxx;Database= =3Dxxx;" > > > > > > # Create connection to PostgreSQL > > > $pgsqlConn =3D New-Object Npgsql.NpgsqlConnection > > > $pgsqlConn.ConnectionString =3D $pgsqlConnectionString > > > $pgsqlConn.Open() > > > > > > > > > When this statement hits I get an error: > > > > > > Exception calling "Open" with "0" argument(s): "Authentication > > method > > > not supported (Received: 10)" > > > > Best bet old library that does not understand scram-sha-256 > > authentication. > > > > > > > > > > Any ideas? > > > > > > Thanks. > > > > -- > > Adrian Klaver > > adrian.klaver@aklaver.com > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > --000000000000af82bc061eb5df9a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
How can I tell that?

=C2=A0Thanks.

On Fri, Aug 2, 2024 at 12:18=E2=80=AFPM Adrian Klaver <adrian.klaver@aklaver.com> wrote:


On 8/2/24 9:00 AM, Andy Hartman wrote:
Reply to list also.
Ccing list.
> I changed to md5 and I can connect via HeideSQL=C2=A0interface no prob= lem

Changed what to md5?

The issue is with Npgsql(?) though.

What is the Npgsql version?

>
> On Fri, Aug 2, 2024 at 11:05=E2=80=AFAM Adrian Klaver <adrian.klaver@aklaver.co= m
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
>=C2=A0 =C2=A0 =C2=A0On 8/2/24 07:56, Andy Hartman wrote:
>=C2=A0 =C2=A0 =C2=A0 > I'm using a Powershell script to connect = to a remote 16.3(windows)
>=C2=A0 =C2=A0 =C2=A0 > version of the DB.
>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 > Add-type -path 'C:\Program Files
>=C2=A0 =C2=A0 =C2=A0 > (x86)\PostgreSQL\Npgsql\bin\net451\Npgsql.dll= '
>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 > # Define connection strings for MS SQL and Po= stgreSQL
>=C2=A0 =C2=A0 =C2=A0 > $pgsqlConnectionString =3D
>=C2=A0 =C2=A0 =C2=A0 > "Host=3Dxxxxxx;Port=3D5432;Username=3Dxx= x;Password=3Dxx;Database=3Dxxx;"
>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 > # Create connection to PostgreSQL
>=C2=A0 =C2=A0 =C2=A0 > $pgsqlConn =3D New-Object Npgsql.NpgsqlConnec= tion
>=C2=A0 =C2=A0 =C2=A0 > $pgsqlConn.ConnectionString =3D $pgsqlConnect= ionString
>=C2=A0 =C2=A0 =C2=A0 > $pgsqlConn.Open()
>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 > When this statement hits I get an error:
>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 > Exception calling "Open" with "= ;0" argument(s): "Authentication
>=C2=A0 =C2=A0 =C2=A0method
>=C2=A0 =C2=A0 =C2=A0 > not supported (Received: 10)"
>
>=C2=A0 =C2=A0 =C2=A0Best bet old library that does not understand scram= -sha-256
>=C2=A0 =C2=A0 =C2=A0authentication.
>
>
>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 > Any ideas?
>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 > Thanks.
>
>=C2=A0 =C2=A0 =C2=A0--
>=C2=A0 =C2=A0 =C2=A0Adrian Klaver
>=C2=A0 =C2=A0 =C2=A0adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com><= br> >

--
Adrian Klaver
adrian.klave= r@aklaver.com
--000000000000af82bc061eb5df9a--