MIME-Version: 1.0
In-Reply-To: <DM4PR84MB15172CC4665076AB1248F3CC8DDF2@DM4PR84MB1517.NAMPRD84.PROD.OUTLOOK.COM>
References: <DM4PR84MB15172CC4665076AB1248F3CC8DDF2@DM4PR84MB1517.NAMPRD84.PROD.OUTLOOK.COM>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Wed, 17 Jul 2024 08:27:11 -0700
Message-ID: <CAKFQuwZ=zxnSbL_kgK6ZpURoqK8SR+W1v1O+f=ONunifzrYAag@mail.gmail.com>
Subject: Re: Issue with configuration parameter "require_auth"
To: "Gaisford, Phillip" <phillip.gaisford@hpe.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000009dffbc061d731805"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZ%3DzxnSbL_kgK6ZpURoqK8SR%2BW1v1O%2Bf%3DONunifzrYAag%40mail.gmail.com>
Precedence: bulk

--0000000000009dffbc061d731805
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wednesday, July 17, 2024, Gaisford, Phillip <phillip.gaisford@hpe.com>
wrote:

> I am having trouble using require_auth (https://www.postgresql.org/
> docs/16/libpq-connect.html#LIBPQ-CONNECT-REQUIRE-AUTH).
>
>
>
> Using golang sqlx.Connect on the client side, the connection fails and my
> Postgresql 16 server logs the following:
>
> 2024-07-17 14:42:07.285 UTC [115] FATAL:  unrecognized configuration
> parameter "require_auth"
>
>
>
> What could the issue be?
>
>
>

Seems like a bug or version mis-match in the client library.  That is a new
option in v16 so it may not be handled properly.  That option is
client-only, the client should not be sending it to the server, which the
error message indicates it is.  Unless you can reproduce with psql you=E2=
=80=99ll
need to check your installation environment (maybe you only have v15 or
less client libraries installed?) or file a bug with the driver project.

David J.

--0000000000009dffbc061d731805
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wednesday, July 17, 2024, Gaisford, Phillip &lt;<a href=3D"mailto:philli=
p.gaisford@hpe.com">phillip.gaisford@hpe.com</a>&gt; wrote:<br><blockquote =
class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid=
;padding-left:1ex">


<div lang=3D"EN-US" link=3D"#467886" vlink=3D"#96607D" style=3D"word-wrap:b=
reak-word">
<div>
<p class=3D"MsoNormal">I am having trouble using require_auth (<a href=3D"h=
ttps://www.postgresql.org/docs/16/libpq-connect.html#LIBPQ-CONNECT-REQUIRE-=
AUTH" target=3D"_blank">https://www.postgresql.org/<wbr>docs/16/libpq-conne=
ct.html#<wbr>LIBPQ-CONNECT-REQUIRE-AUTH</a>).</p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p><span style=3D"font-size:11.0pt;font-family:&quot;Aptos&quot;,sans-serif=
">Using golang sqlx.Connect on the client side, the connection fails and my=
 Postgresql 16 server logs the following:<br>
<br>
<span>2024-07-17 14:42:07.285 UTC [115] FATAL:</span></span><span><span sty=
le=3D"font-size:11.0pt;font-family:&quot;Aptos&quot;,sans-serif">=C2=A0
</span></span><span><span style=3D"font-size:11.0pt;font-family:&quot;Aptos=
&quot;,sans-serif">unrecognized configuration parameter &quot;require_auth&=
quot;<u></u><u></u></span></span></p>
<p><span><span style=3D"font-size:11.0pt;font-family:&quot;Aptos&quot;,sans=
-serif"><u></u>=C2=A0<u></u></span></span></p>
<p><span><span style=3D"font-size:11.0pt;font-family:&quot;Aptos&quot;,sans=
-serif">What could the issue be?</span></span><span style=3D"font-size:11.0=
pt;font-family:&quot;Aptos&quot;,sans-serif"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p></div></div></blockquote><di=
v><br></div><div>Seems like a bug or version mis-match in the client librar=
y.=C2=A0 That is a new option in v16 so it may not be handled properly.=C2=
=A0 That option is client-only, the client should not be sending it to the =
server, which the error message indicates it is.=C2=A0 Unless you can repro=
duce with psql you=E2=80=99ll need to check your installation environment (=
maybe you only have v15 or less client libraries installed?) or file a bug =
with the driver project.</div><div><br></div><div>David J.</div><div><br></=
div>

--0000000000009dffbc061d731805--